eLumenation 2021 has ended
eLumenation Conference 2021
Back To Schedule
Wednesday, July 28 • 3:15pm - 3:45pm
Wizarding the Data Load

Sign up or log in to save this to your schedule, view media, leave feedback and see who's attending!

Feedback form is now closed.

In this session, we will demonstrate how a successful data load solution may be implemented, through identifying and extracting SIS data and staging it in an intermediary workspace, validating the extracted data and converting it to an XML file for upload. The presentation will include examples of dependency and referential integrity checking of the data, as well as creating a functional specification that covers the scope of the SIS data that is extracted, and how it is mapped to the respective eLumen items. Finally, we will demonstrate a fully self-contained integration solution that generates the XML file directly from SQL Script and stages the file for upload.


Matthew Reeves

Database Administrator / SQL Data Warehouse Programmer,, Cabrillo College

Wednesday July 28, 2021 3:15pm - 3:45pm PDT