Getting Started - Appendix

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

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_Security

SQL Scripts

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.

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.

Feature

Is Enabled by Default

Description

Feature

Is Enabled by Default

Description

changeQueries

true

The Changed Record Queries feature can be enabled or disabled via configuration. Database configuration remains a separate step, see Using the Changed Record Queries.

openApiMetadata

true

The metadata API endpoint used by Swagger UI can be enabled or disabled via configuration. It is recommend for Production deployments to disable this.

composites

true

The 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.

profiles

true

The Profiles feature can be enabled or disabled via configuration. 

identityManagement

false

Enables the Identity API endpoints.

extensions

true

Enables 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.

uniqueIdValidation

false

Enables Unique ID Validation. This requires custom implementation of IUniqueIdToIdValueMapper and its registration within the WebApi. 

tokenInfo

true

Enables oauth token_info introspective endpoint which provides the additional security configuration information for the token. See Token Info section for mode details.