Data Integrations Between Various Environments
Closed     Case # 10017     Affiliated Job:  New Trier Township District 2031
Opened:  Unknown     Closed:  Unknown
Total Hit Count:  40828     Last Hit:  Monday, December 9, 2024 2:10:33 AM
Unique Hit Count:  9936     Last Unique Hit:  Monday, December 9, 2024 2:10:33 AM
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.

Project:
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 3849 contact@danieljchu.com We have internal and also outsourced hosted, almost all web products which   More ...
10068 2/16/2010 2:35:29 PM Database 3785 contact@danieljchu.com Sample A.D. Query to Batch below, this assembles data from the eSchool stud  More ...

Outcome:
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