Some implementations implementers of the Ed-Fi technology may have changed the default database schema from edfi  to a custom value. In keeping with the majority of implementations, the Analytics Middle Tier assumes that all Ed-Fi ODS database tables are in the edfi  schema, with . There is no built-in mechanism for changing or configuration option to change to a different schema. However, anyone interested in installing the Analytics Middle Tier over their a customized database can do so by following these steps:

.

Instructions

Prerequisite

• This procedure requires installation of .NET Core SDK 3.1 on the developer workstation in order to

• recompile the source code.

Steps

1. Fork the source code repository in GitHub (https://github.com/Ed-Fi-Alliance/Ed-Fi-Analytics-Middle-Tier).
2. Clone the fork onto a developer computer.

3. Place the following script in the root repository directory: View filename amt-change-source-schema.ps1height.150

4. Execute the script against the desired release tag (for example, "2.0.0" for the AMT 2.0.0 release), commit all changes in a new branch, and push back to GitHub.*.

   Code Block
   language powershell title Execute in PowerShell
   git checkout 2.0.0 git checkout -b master-mystate .\amt-change-source-schema.ps1 "mystateschemaname" git commit -am "Replace edfi schema" git push master-mystate

   * Strictly speaking you do not need to commit changes and push to GitHub. This These instructions adheres adhere to the standard advice of always backing up your work.

5. Now you can compile the application and run it pointing to your custom database.:

   Code Block
   cd src/ # Compile an executable for use on a Windows 10 or Windows Server 2016+ machine: dotnet publish -c Release -r win10-x64 # Output is in src\EdFi.AnalyticsMiddleTier.Tests\bin\Release\netcoreapp3.1\win10-x64\publish\