Sms 2 0 odbc launch kit skyward

Pdf File 781.32 KByte, 26 Pages

SMS 2.0 ODBC Launch Kit

_________________________________________________________________________________________________________

Table of Contents

WHAT IS ODBC? .............................................................................................................................................................................. 3 WHAT PRODUCTS USE ODBC TO ACCESS THE SKYWARD DATABASE? ...................................................................... 3 ODBC/JDBC DRIVERS....................................................................................................................................................................3 SKYWARD CUSTOM REPORTING OPTIONS........................................................................................................................... 3 ODBC DRIVER INSTALL METHODS..........................................................................................................................................4 INSTALLING AN ODBC DRIVER ON A NON-SKYWARD COMPUTER; WORKSTATION OR SERVER. .................... 6 WHERE DO I FIND THE IP ADDRESS OF A SKYWARD DATABASE SERVER?............................................................. 10 WHAT IS THE STANDARD SQL PORT NUMBER OF A SKYWARD DATABASE?.......................................................... 11 WHERE DO I FIND THE SQL PORT NUMBER OF A SKYWARD DATABASE?............................................................... 11 WHAT ARE READ-ONLY ODBC USERS IN A SKYWARD DATABASE? ........................................................................... 12 CREATING READ-ONLY SQL USER IN A SKYWARD DATABASE ................................................................................... 12 INSTALLING ODBC DATA SOURCE CONNECTIVITY TO A SKYWARD DATABASE ................................................. 13 VIEWING THE CONTENTS OF AN ODBC DATA SOURCE ................................................................................................. 17 ODBC AND SKYWARD MAINTENANCE ................................................................................................................................. 19

DBTool Utility .......................................................................................................................................................................... 19 Updating Read-Only SQL User task via Monolith 2 ................................................................................................................ 19 Update Statistics task via Monolith 2 ....................................................................................................................................... 19 Testing Read Only User Connectivity of an ODBC Data Source ............................................................................................. 20 How to create ODBC users with ODBC User Control Program ............................................................................................. 22 Software to Test Queries against the Skyward database .......................................................................................................... 22 Manually Create an ODBC Data Source ................................................................................................................................. 23 WHAT IS JDBC? ............................................................................................................................................................................. 26

_________________________________________________________________________________________________________

05.26.2021



Page 2 of 26

_________________________________________________________________________________________________________

What is ODBC?

Open Database Connectivity (ODBC) provides a standard software API method for using database management systems (DBMS). The designers of ODBC aimed to make it independent of programming languages, database systems, and operating systems. Skyward also supports JDBC (Java Database Connectivity) which is the Java version of ODBC commonly used for Unix/Linux based connections.

ODBC allows your district to read data from or write data to your Skyward Database(s) when SkyBuild/Data Mining does not provide an export or import that meets your district's needs. This connection gives IT personal the ability to run SQL queries against the Skyward Database(s).

ODBC is available for both Cloud hosted and Self-hosted customers with on-premise servers.

What products use ODBC to access the Skyward Database?

? Crystal Reports /Report Viewer ? Business Objects BI Platform 4.0 (formerly Crystal Enterprise) ? Skyward PaC Reporting Options ? Web Quick Pick reports using SkyRAS (Crystal for the Web) ? SQL Management Studio ? Microsoft Reporting Services ? Cognos (IBM) ? Squirrel SQL Client (Open Source) ? Skyward ODBC Query Tool ? Too many others to list...

ODBC/JDBC Drivers

The Skyward OpenEdge ODBC/JDBC drivers will need to be loaded on any system that will be accessing the Skyward Database. Skyward provides ODBC/JDBC drivers for all operating systems; including 32 bit and 64-bit Windows. The drivers are available to all Skyward customers at no additional cost.

Skyward Custom Reporting Options

If you are interested in Skywards Custom reporting options please visit the following website. (Customer Support Center login required)

_________________________________________________________________________________________________________

05.26.2021



Page 3 of 26

_________________________________________________________________________________________________________

ODBC Driver Install Methods

You will need to install either the OpenEdge 32-bit or 64-bit driver on a non-Skyward server or workstation. The "bit" version of the driver needs to match the "bit" version of the application that you are using to query the database. An example of this scenario would be if you run a third party 32-bit product setup on a Skyward server and it is configured to access the Skyward database using ODBC then you will need to install the 32 -bit ODBC driver on the Skyward server.

ODBC Driver 32 Bit

32 Bit

Installation Methods

11.7 ? SMS 2.0 ? PaC Workstation Install.msi 11.7 ? SMS 2.0 ? PaC Workstation Install.exe

32 Bit

64 Bit

32 Bit 64 Bit

11.7 ? SMS 2.0 ? ODBC 32-bit Driver Install.exe 11.7 ? SMS 2.0 ? ODBC 64-bit Driver Install.exe 11.7 - Role - Base Install.exe1 (This was run when server was initially setup; only run when new server is set up.)

\Install folder

Not needed

Needed on Program server connected from workstation. Not needed

Not needed

Needed on Skyward server.

Use

PaC Client includes 32-bit driver PaC Client includes 32-bit driver

32-bit driver only

64-bit driver only

Base server install includes 32-bit and 64-bit driver

1 11.7 ? Role ? Base Install.exe is run when installing a new Skyward db/web/report server. If Skyward server is already set up, DO NOT run this installer.

FTP Connect Instructions for downloading files from Skyward FTP site ons.pdf

Skyward Server Install Directory: The ?:\skyward\install directory is created by the 11.7 - Skyward Software Distribution .exe and 11.7 ? Skyward Software Distribution.2-5 files. The files are located on the Skyward FTP Site in the Hardware\Public\OE117-Customer-DVD\Windows folder. The software distribution files contain folders and files for OpenEdge 11.7, Sun Java, Microsoft .NET, ODBC drivers and other files needed for installers. Some Installer.exe files need to `see' this folder, and some do not, or some will create the folder during the running of the install file.

_________________________________________________________________________________________________________

05.26.2021



Page 4 of 26

_________________________________________________________________________________________________________

Skyward Database/Web/Report Server Installs The 11.7 32-bit and the 11.7 64-bit ODBC drivers are installed on each server when the 11.7 ? SMS 2.0 ? Base Install.exe installer is run. This installer will be run on the SMS 2.0 Database/Web/Report Server(s).

_________________________________________________________________________________________________________

05.26.2021



Page 5 of 26

_________________________________________________________________________________________________________

Installing an ODBC driver on a non-Skyward Computer; workstation or server.

Note: This installer will be the most common one used for a non-Skyward computer; workstation or server. 1. Navigate to 11.7 ? SMS 2.0 ? ODBC 32-bit Driver Install.exe file from a Skyward server

?:\skyward\install folder Double click 11.7 ? SMS 2.0 ? ODBC 32-bit Driver Install.exe.

2. The Important Information notice will display. OK.

3. The screen will display stating the `bit' level being installed Next.

_________________________________________________________________________________________________________

05.26.2021



Page 6 of 26

Download Pdf File