TSDS > Education Data Warehouse > ODS and eDM > Data Loading and the Operational Data Store
"We have seen a significant time savings in data management since switching to the SSIS. We are able to spend less time and money on paperwork and backing up files, and more time with our students."
Andy Baker - Superintendent, Edgewood ISD
Read more: TSDS Case Studies
The Operational Data Store (ODS) is the central district-controlled data repository for TSDS. The eDM Data Loads tool and the Data Transfer Utility allow users to load local data to the ODS.
Users can perform one-time manual loads from anywhere in their local system using the eScholar Data Manager (eDM) data loader. eDM picks up the specified file and validates it, and then the user directs the system to process the file into the ODS.
Users can also schedule loads locally in the Data Transfer Utility (DTU--illustrated in the diagram above). The DTU can perform on demand (manual) loads as well as scheduled one-time or recurring loads from the local staging area. The DTU transfers the selected files, and if they pass validations, they are automatically processed into the ODS.
Whether files are loaded via the DTU or the eDM, the ODS can only accept data that is in Texas Education Data Standards (TEDS)-compliant XML format. In addition, some errors will prevent a file from being loaded--to ensure that your file is loadable, run it through the downloadable TSDS Validation Tool to check for errors.
Once the data has been processed into the ODS, the user can promote it to the appropriate TSDS subsystem or data collection.
The ODS is the central repository that integrates data across multiple years from the LEAs' education data systems. From the ODS, the data flows to PEIMS and the optional studentGPS® Dashboards.