The Series25 LYNX Interface uses a database integration to connect to any student information system which is hosted locally on an institution's servers.
The integration has two parts:
- A series of custom tables that track historical changes to SIS data
- The LYNX-APP, a lightweight Java application that exchanges data between those tables and the hosted Series25 database
This article explains how to deploy the LYNX Interface scripts necessary for database integration with Campus Solutions using a Microsoft SQL Server database. (For Oracle instructions, see here.) After the scripts are in place, you will be ready to install the LYNX-APP.
System Requirements
Your SIS environment must meet the following requirements:
- MS SQL Server 2012 or later
Download the SQL Scripts Package
Download the LYNX-CS-MSS.zip package of scripts from: https://collegenet.exavault.com/share/view/1q87x-k734qcu. (Contact Series25 Support at support@collegenet.com for credentials.)
The script package contains the following files:
Script | Name | Purpose |
---|---|---|
A | a_cs_sis_mssql_security.sql | Creates database user to provide access to LYNX database tables for the LYNX-APP |
B | b_cs_sis_mssql_schema.sql | Creates database tables, sequences, and triggers owned by user created in the "A" script |
C | c_cs_sis_mssql_routines.sql | Creates database functions and procedures owned by user created in the "A" script |
Deploy the SQL Scripts
Follow this procedure to properly deploy the scripts in your Oracle database.
Prepare the LYNX Username and Password
These scripts create and reference a user which provides access for the LYNX application. This is a new user. (Do not re-use credentials for an existing user.)
Before running any scripts, choose a username and password for this new user. You will use these values to update the scripts.
Update the Creation Scripts
Certain lines within the scripts need to be customized to reflect your individual environment.
- Open the "A" script (a_cs_sis_mssql_security.sql).
- Search for 'DB_USERNAME'.
- Update LYNX_USER to your chosen username.
- Update LYNX_USER_PASS to your chosen password.
Save changes to the "A" script after making these updates.
- Open the "B" script (b_cs_sis_mssql_schema.sql).
- Update LYNX_USER to the chosen username.
- Save changes to the "B" script.
- Open the "C" script (c_cs_sis_mssql_routines.sql).
- Update LYNX_USER to the chosen username.
- Save changes to the "C" script.
Run the Scripts
You are now ready to run the A, B, and C scripts which create objects in your SIS database.
- Log in to your SIS database as an administrator.
- Run the updated "A" script to create the LYNX user, set private synonyms, and establish rights.
- Log in to your SIS database as the newly created LYNX user from step 2.
- Run the "B" script within the SQL Server DB.
- Run the "C" script within the SQL Server DB.
Install the LYNX-APP
Once you have completed the steps to deploy the LYNX database objects into your SIS database, you are ready to install the LYNX-APP.