Getting Started - Appendix

Ed-Fi ODS / API Database Overview


The Ed-Fi ODS / API uses several databases for various aspects of the application. The table below summarizes the databases with a brief statement of the creation method and purpose.

Database

Method

Purpose

EdFi_Ods_Minimal_Template

SQL Backup

A template database used to create empty sandboxes or to create production ODS.

EdFi_Ods_Populated_Template

SQL Backup

A template database populated with sample data used to create sample data sandboxes.

EdFi_ODS_*

SQL Backup

A database that stores data for the ODS / API

EdFi_Admin

SQL Scripts

A database containing administration configuration information specific to the ODS / API.

EdFi_SecuritySQL ScriptsA 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.

Ed-Fi ODS / API Features 


The Ed-Fi ODS / API comes with a set of configurable features that can be enabled or disabled using configuration settings in deployed API. See the Configuration Details section for more details on these settings.

FeatureIs Enabled by DefaultDescription
changeQueriestrueThe Changed Record Queries feature can be enabled or disabled via configuration. Database configuration remains a separate step, see Using the Changed Record Queries.
openApiMetadatatrueThe metadata API endpoint used by Swagger UI can be enabled or disabled via configuration. It is recommend for Production deployments to disable this.
compositestrueThe Composites API endpoints can be enabled or disabled via configuration. This includes the default Enrollments composite and any custom composites that have been added to the platform.
profilestrueThe Profiles feature can be enabled or disabled via configuration. 
identityManagementfalseEnables the Identity API endpoints.
extensionstrueEnables the API endpoints created for all Extensions. Installations can be extended by modifying source code see How To: Extend the Ed-Fi ODS / API - Student Transportation Example or by deploying dynamic extension plugins see How To: Deploy an Extension Plugin for details.
uniqueIdValidationfalseEnables Unique ID Validation. This requires custom implementation of IUniqueIdToIdValueMapper and its registration within the WebApi. 
tokenInfotrueEnables oauth token_info introspective endpoint which provides the additional security configuration information for the token. See Token Info section for mode details.

Contents

Find out more about how to begin using the Ed-Fi ODS / API: