Anchor
Appendix-A Appendix-A

Appendix A: Ed-Fi ODS / API Databases

The Ed-Fi ODS / API uses several databases for various aspects of the application and to store data for each sandbox.

In addition to these databases, copies of either the minimal or populated template databases are made for each sandbox in the environment.

Anchor
Appendix-B Appendix-B

Appendix B: Creating a Developer Certificate

A default development certificate is provided with the material in GitHub. Alternatively, you may create your own developer certificate by issuing the following commands using OpenSSL.

openssl req -x509 -nodes -days 9999 -subj '/CN=Development_Encryption' -newkey rsa:2048 -keyout Development.pem -out Development.pem
openssl pkcs12 -export -out Development.pfx -in Development.pem -name 'Development_Encryption'

After creating and installing a new certificate, you will also need to generate an encrypted database passwords file containing SQL logins. This may be performed by removing the credentials-*.xml files from the C:\Ed-Fi-ODS-Implementation\logistics\scripts\activities\build directory and running the initdev command from PowerShell. This will prompt you for passwords that are then encrypted in a new credentials-*.xml file.

To make the file non-machine specific, remove the name of the machine from the file so you have something like “credentials-Development.xml”. If you wish to use integrated authentication, remove the <Username>edfiAdmin</Username> and <Username>edfiLoader</Username> values from the XML. Do not change any other sections of the XML documents.

Anchor
Appendix-C Appendix-C

Appendix C: Windows Azure

Windows Azure is not required for the installing and running to install and run the Ed-Fi ODS / API, though Azure deployment and infrastructure is a deployment option. If an Azure deployment is desired, the Azure SDK for .NET is required to perform local testing and cloud deployment from a developer workstation.

There are a few components that have been designed to work in the Azure environment. These components utilize Azure Queues and Blob Storage. The following table lists the Windows components as well as their Azure counterparts:

Anchor
azuresdk azuresdk

Windows Azure SDK Installation

The Windows Azure SDK is used to simulate the Azure environment in a non-production environment (i.e., development machine) and includes local implementations of Azure components as well as tools for deploying to the Azure environment from Visual Studio 2013. The SDK is not required to compile the non-Azure configurations (Debug and Release) of the Ed-Fi ODS / API release.

The Windows Azure SDK is required to compile the EdFi.Ods.WindowsAzure, EdFi.Workers.BulkLoad, and EdFi.Workers.UploadCommit projects. These projects utilize various Windows Azure-specific components including Azure Blob Storage and Azure Queue Service.

Install the Windows Azure SDK, version 2.3 by following the directions at http://www.microsoft.com/en-us/download/details.aspx?id=42317. You will need to follow the manual instructions in the "Install Instructions" section on that page.