Skip to main content
Version: 7.3

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.

DatabaseMethodPurpose
EdFi_Ods_Minimal_TemplateSQL BackupA template database used to create empty sandboxes or to create production ODS.
EdFi_Ods_Populated_TemplateSQL BackupA template database populated with sample data used to create sample data sandboxes.
EdFi_ODS_*SQL BackupA database that stores data for the ODS / API
EdFi_AdminSQL ScriptsA 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 - Alternative Education Program 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.