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
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.
Gliffy Diagram is only supported by the cloud editor
Because Forge macros arent supported by the legacy editor, you'll need to convert this content to the cloud editor to display this macro properly. Find out more about converting to the cloud editorETL 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