Build and Transform SIS Extract

The ETL (Export, Transform, and Load) process is detailed and illustrated as follows.

To build and transform your SIS extract:

1.    Export the data from the SIS by doing one of the following:

–      Use the export functionality included in the SIS system to download the data to CSV and load to a local database.

–      If your SIS vendor hosts your data, use the  ODBC/DB access (if the vendor allows) or use export tools to CSV and upload the data to a server in your LAN.

2.    Transform the SIS extracted table data into the HMH template format by moving data from “staged-SIS tables” to the vendor-based tables, which may be the Simple File Format (SFF) or OneRoster.

For example: You may need to take data from a teachers table and load that to a users table. Then, you will need to take data from the student table and export that to the users table.

3.    To get the tables into a final CSV state, build the extract package, most likely using SQL DTSX packages, to export the data for transit or export and use "MERGE" or "Powershell" scripting.

4.    Zip up all the CSV files.

➔    Your next steps are:

–      Manually test the files by uploading them in Import Management.

–      Set up automation to the SFTP site using WinSCP or Putty.