Data Integrations Between Various Environments
Closed     Case # 10017     Affiliated Job:  New Trier Township District 2031
Opened:  Unknown     Closed:  Unknown
Total Hit Count:  38547     Last Hit:  Sunday, July 21, 2024 6:25:02 PM
Unique Hit Count:  9203     Last Unique Hit:  Sunday, July 21, 2024 6:25:02 PM
Case Type(s):  Database, Server
Case Notes(s):  All cases are posted for review purposes only. Any implementations should be performed at your own risk.

Shortly after I started at New Trier, we lost our MIS Manager who had a variety of manually run synchronization routines in place to carry data between our many environments. I was tasked to review these integrations and either get them running or improve upon them.

I took his manually run routines, which were being performed through a Windows based Linux emulator which ran scripts that pulled data into temporary tables, adjusted the data and then carried that data into the destination system, and revised them into a single query with join statements that in the query "massaged" the data for the destination environments.

Action(s) Performed:
Total Action(s): 2
Action # Recorded Date Type Hit(s) User Expand Details
10064 2/16/2010 2:58:46 PM Database 3619 We have internal and also outsourced hosted, almost all web products which   More ...
10068 2/16/2010 2:35:29 PM Database 3558 Sample A.D. Query to Batch below, this assembles data from the eSchool stud  More ...

The above scripts are now entirely automated in the form of DTS packages that run across our SQL 2000 & 2005 environment and also out to our vendors to supply any updated and year to year roll over activity. Through these scripts, a great number of previously manual activities, like a new student in the middle of a current year, can now be achieved entirely automated also allowing a single point of entry through the Student Records or Finance system.

Profile IMG: Footer Left Profile IMG: Footer Right