How To: Load the ODS using Sample XML Data (Tech Preview)

This article describes the steps needed to populate an Ed-Fi ODS with sample XML data, using the Ed-Fi Console Bulk Loader. The steps can be summarized as:

Step 1. Build the Ed-Fi Console Bulk Loader

• Ensure that you have an instance of the Ed-Fi ODS / API running locally that has been set up following the Getting Started - Installation Steps.

• The Bulk Load Console project is built as part of the overall solution, and you can verify that the console application (EdFi.Ods.BulkLoad.Console.exe) has been built by browsing to  <source directory>\Ed-Fi-ODS-Implementation\Application\EdFi.Ods.BulkLoad.Console\bin\Debug.

Step 2. Download Scripts and Sample Data

• Download the 'Bulk Console Loader Script' (to the right) to a local folder (we recommend C:\Ed-Fi-SampleDataLoad). It contains the scripts to initiate the Bulk Console Loader, as well as a copy of the Manifest file used by the console loader.

• Navigate to the downloaded file directory for 'Bulk Console Loader Script' and download the Sample XML and Descriptors to Sample Data folder (C:\Ed-Fi-SampleDataLoad\Sample Data).

Step 3. Run the Load Script and Populate the EdFi_ODS_Empty Database

• From a PowerShell session, navigate to the downloaded file directory for 'Bulk Console Loader Script' (i.e., C:\Ed-Fi-SampleDataLoad).

• Execute LoadEmptyDatabaseWithSampleData.ps1.

• The script will reset your EdFi-Ods-Empty and load all sample data in one script run. 

Step 4. Provision the EdFi_ODS_Populated_Template Database

• Back up the EdFi_ODS_Empty database.

• Restore the backup you just made with the name EdFi_ODS_Populated_Template.

• Create a Sandbox using the Ed-Fi ODS / API Admin Console.

• Use the database created as the source of data for loading dashboards and other activities.