Specifications include, but are not limited to: The Bureau of Educational Statistics within the NHED is seeking a vendor to map its current SLDS (State Longitudinal Data System) data warehouse tables to a new CEDS (Common Educational Data Standards) data warehouse model as well as create the necessary ETL (Extract, Transform, Load) code to extract the data from the old databases to the new CEDS data model. The services will be delivered remotely by the vendor. The Department plans to align all SLDS data warehouse elements from approximately 150 tables (many of the tables are lookup tables that just the option sets need to be aligned) with the CEDS data model. If an element from our SLDS data warehouse does not align with the CEDS data model, the vendor will extend the CEDS data model to incorporate it. • Get all the data from the CEDS model that is needed for Generate and the ETL from the existing Access database used for Edfacts reporting into the Generate Database. • Windows Active directory will be used to maintain security to the new CEDS data model. • DDL script to be used to create the initial CEDS data model that will be completed by DoIT.
