Data Integrations Between Various Environments Closed     Case # 10017     Affiliated Job:  New Trier Township District 2031 Opened:  Unknown     Closed:  Unknown Total Hit Count:  40969     Last Hit:  Saturday, December 21, 2024 11:09:06 AM Unique Hit Count:  9968     Last Unique Hit:  Saturday, December 21, 2024 11:09:06 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 3860 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 3796 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.