The Ed-Fi “Classic Dashboards” are no longer supported through the Ed-Fi Alliance. You can still receive support and maintenance through the Ed-Fi vendor community. Please look at any of the vendors’ dashboard solutions on the Registry of Ed-Fi Badges or the Ed-Fi Starter Kits if you are looking for a visualization solution to use with the Ed-Fi ODS. This documentation will remain available to assist existing Classic Dashboard implementers.
ETL Developers' Guide - Overview
- Itzel Torres
The Ed-Fi ETL Application is the code that Extracts the data from the ODS, Transforms it into meaningful student measures that we generally refer to as metrics, and finally Loads these metrics into the dashboard databases. This process is represented in step 2 in the diagram below.
The Ed-Fi ETL Application transforms the raw student data from an Ed-Fi ODS into meaningful, actionable data for the classroom, school, and district to support students on their journey through K–12 education system.
ETL Runtime Executable
The three core components of the ETL Application architecture are:
- Readers, which extract the data from the ODS into application objects. Data is read once and published to be consumed by the relevant translators.
- Translators, which transform the objects into metric calculations. These are responsible for applying the business logic defined for each metric.
- Writers, which load the data into the dashboard databases, improving performance by optimizing data writes via buffers.
Minimum System Requirements
- Windows Server 2012 or higher
- SQL Server 2014 Developer or Enterprise Edition
- 64 GB RAM
- 3 Ghz Dual-Core CPU
- 100 GB free HD Space