Overview

Ed-Fi adopters may choose "Year-Specific" configuration within their ODS environments to partition data per-year within a SQL Server instance.  Beginning with Admin App 1.6, year-specific mode is supported and configuration instructions are below.  For more information on enabling year-specific mode for the Ed-Fi ODS / API platform, please see: /wiki/spaces/ODSAPI32/pages/27099724.

Checklist

Use this checklist and the details below to modify your ODS and Admin App to run in Year-Specific mode

•  ODS API: configure the ODS API Web.config for YearSpecific startup
•  ODS SwaggerUI: configure the swagger.webApiMetadataUrl to contain the configured year. For example, http://localhost:54746/metadata/{year}/
•  ODS Database: Rename the EdFi_Ods database to EdFi_Ods_2019
•  Admin App: update database value in EdFi_Ods_Production connectionString
•  Admin App: enable and configure year specific app settings yearSpecific:isEnabled and yearSpecific:year

Year-Specific Configuration

ODS Web API and SwaggerUI Config

The ODS API and SwaggerUI each require changes to configure them in Year-Specific mode. If installed through exe installers you can locate the Web.config for each by using IIS. Right click "Explore" on the web application and then find the Web.config file.

Image Modified

In the SwaggerUI Web.config, make the following changes:

1. Update swagger.webApiMetadataUrl to contain a school year
   1. Image Modified

In the WebApi Web.config, make the following changes:

1. Update the owin:appStartup app setting to have the value of "YearSpecific"
   1. Image Modified

ODS Database Year-Specific Naming Convention

In Year-Specific mode, the database is identified with a "_{year}" suffix value in the database name. To enable, install the database as usual, either through the initdev process or through the Windows Installers for the Ed-Fi ODS/API Suite 3. Once installed, you can manually rename the database through SQL Server Management Studio by right clicking on the database name and selecting "Rename":

Image Modified

Admin App Configuration

Admin App requires three configuration changes in the Web.config file in order to enable connections to a Year Specific ODS.

1.) To find the Web.config file, open IIS Manager and navigate to the AdminApp web application. Right click and select the "Explore" option. This will open the installation directory of Admin App where you will find Web.config.

Image Modified

2.) In Web.config, make the following changes:

1. Set the "EdFi_Ods_Production" connection string to contain the year specific database name created while setting up the ODS. The example below uses the "EdFi_Ods_2019" database and windows authentication

   1. Image Modified

2. To enable year specific functionality inside Admin App add the two items shown below into the AppSettings node in Web.config, placing them below any items that already exist.
   1. Image Modified

Reporting Issues

If there are issues during installation of the Admin App, please login a ticket in the EDFI queue in the Ed-Fi Tracker to begin the support process.