This version of the Ed-Fi ODS / API is no longer supported. See the Ed-Fi Technology Version Index for a link to the latest version.
Getting Started - Appendix
- Ian Christopher
- Vinaya Mayya
- Chris Moffatt (Deactivated)
Ed-Fi ODS / API Database Overview
The Ed-Fi ODS / API uses several databases for various aspects of the application and to store data for each sandbox. The table below summarizes the databases with a brief statement of the creation method and purpose.
Database | Method | Purpose |
|---|---|---|
EdFi_Ods_Empty | SQL Scripts | An empty database used for code generation when building the solution. |
EdFi_Ods_Minimal_Template | SQL Scripts | A template database used to create empty sandboxes. |
EdFi_Ods_Populated_Template | SQL Backup | A template database populated with sample data used to create sample data sandboxes. |
EdFi_Bulk | Entity Framework Code First | A database that stores bulk upload files and tracking information. |
EdFi_Admin | Entity Framework Code First | A database containing administration configuration information specific to the ODS / API. |
| EdFi_Security | Entity Framework Code First | A database containing security configuration information. |
In addition to these databases, copies of either the minimal or populated template databases are made for each sandbox in the environment.