SIS2000: Set-Up
To begin using the SIS2000 (Data Extractor) with Discovery’s Acorn there are a few things you will need to set-up at your school/district before you begin:
- You must set up Acorn on a computer that has network access to your SIS2000 data.
- You must have the appropriate views installed in your database. If you do not have these views installed please contact our support department and we will be able to get the appropriate views to you.
- Data extraction from SIS2000 requires an ODBC DSN that has read access to the SIS2000 database. Typically you will already have an ODBC connection to SIS2000 for use with other programs such as: Crystal Reports, or COGNOS. If you already have an ODBC DSN set up on your machine, you may continue to the next step. Otherwise you will need to follow the directions for setting up the ODBC connection below:
To check for an existing ODBC DSN:
- Open the Windows Data Sources (ODBC) control panel:
- From the Start menu, choose Control Panel.
- On Windows 2000/XP/Vista, open the Administrative Tools folder.
- Double-click the Data Sources (ODBC) icon.
- On the User DSN or System DSN tab, in the User Data Sources or System Data Sources list, check for an entry that matches your school.
- Note the name of the DSN if you found one, this is the same name that you will enter in the DSN field in the Discovery Data Extractor later.
If you have no ODBC DSN entries matching your school, please follow these steps to add an ODBC DSN for MS SQL Server:
For this set up you will need the following information:
- The name of the SIS2000 MS SQL server.
- The name of the SIS2000 database on the MS SQL server.
- Username and Password for an account that has a minimum of read access to the appropriate views in the SIS2000 database.
Follow the instruction on the MS SQL ODBC setup page to setup and configure your ODBC connection.
Your Data Source is now set up and ready to be used by Acorn.
Move on to SIS2000: Connections