How to deploy School Data Sync using SDS V2.1 CSV files

You can use Comma Separated Value (CSV) files with School Data Sync (SDS) to import and synchronize your Student Information System (SIS) data to Office 365. SDS can sync students, teachers, schools, sections, and roster information from your SIS to Azure Active Directory and Office 365. Using this method, you will export or create CSV files for School Data Sync from your SIS data, set up a synchronization profile, and upload the CSVs into SDS to process.

Note

Current customers of CSV V2 format may continue to use until May, 2022. We recommend using the CSV V2.1 format with its additional capabilities.

Using SDS V2.1 CSV file format



In this article:

Before you get started

Make sure you meet the following prerequisites:

  • An Office 365 for Education tenant

  • Global Administrator Account

  • School Data Sync (Plan 1) enabled

    Note

    The data that provided through SDS may be accessible via MS Graph to third-party applications within your tenant. Sync only the data that you want to make available to these third parties.

Create a Sync Profile and Import your CSV files

Export or create your five required CSV files and if you wish, all or some of the optional five CSV files and ensure they're ready to use.

Note

If you are syncing Guardians (Contacts), you will need to also include a record for them in the users.csv. The fields of familyName, givenName, and email are required for users that have guardian roles, however phone number is optional. To support the relationship between the guardian and student you will need to include a record for each relationship and relationship role in relationships.csv.

Follow these steps to create your sync profile and import the files. A sync profile is a group of options and settings used by SDS to sync the CSV data you plan to upload. You can create up to three sync profiles within a single Office 365 tenant.

SDS sign-in

  1. To access SDS, launch a private web browser, navigate to sds.microsoft.com, select sign-in, and enter your Office 365 Global Admin account credentials when prompted.

Create a Sync Profile and Upload your CSV Files

  1. After logging in, select + Add Profile in the left-hand navigation pane to create a sync profile.

Add profile.

  1. On the Choose Connection Type page, enter a name for the sync profile and select Upload CSV files and CSV files: SDS V2.1 Format. Once complete, select Start.

Choose Connection Type.

  1. On the Sync Options page, select the appropriate option to create new users or sync existing users. Then select Upload Files to upload your four SDS V2.1 CSV files. Once uploaded, complete your selections on the page as appropriate and select Next.

Note

If you are running SDS to create users using the SDS v1 CSV format, Clever CSV format, OneRoster API, or PowerSchool API, you must first create a "Sync existing users" profile to update the anchor ID to the new V2.1 schema on all of the previously created users. Once the initial sync is complete, you can create a SDS V2.1 sync profile and include those same users that SDS previously created.

Sync options.

When you select the upload button on this screen, you will be asked to upload all required files, and have the option to upload additional files.

Select data files to be added.

Once you add your files, select the Upload button and then continue to make your selections on the Sync options screen.

Select data files to be uploaded.

  • Team Creation Option – Checking this box will ensure SDS creates both the Microsoft 365 Group and Class Team for each class synced. If you leave the box unchecked, SDS will only create the Microsoft 365 Groups.

  • Replace unsupported special characters- Checking this box will allow SDS to automatically replace unsupported special characters while the sync is running. Special characters will be replaced with an "_", and no longer result in an error during the sync process for that object.

  • Sync option for class group display name - Checking this box will allow teachers to control the section display name after the first sync, and prevents SDS from overwriting Section DisplayName changes made by teachers.

  • Delay Student Access - Enabling this option will allow you to set a date for SDS to synchronize memberships and enabled students to view their classes. Disable this option to sync students immediately.

  • When should we stop syncing? - You will typically want to do this at the end of the school year or term. Once SDS stops syncing the profile, you will have the option to clean up the classes associated with this profile, as appropriate.

Note

If you wish to have Insights data included with Education Insights Premium, you will need to go to SDS for Insights to update the linked from this profile to your SDS for Insights incoming flow. For more information, please see: SDS for Insights, Edit incoming flow or Back to School transition.

Note

At this time, single tenant with mixed formats (i.e. having V1 and V2 sync profiles actively running and both set to 'Sync to Insights') will not work.

  1. On the User options page, select the appropriate identity matching options, and then click Next.

User options.

  • Primary Key (Source Directory) - This is the attribute in the CSV file used for SDS Identity Matching. Watch the Identity Matching video for additional information on how to select the appropriate source directory attribute, and properly configure the identity matching setting.

  • Primary Key (Azure Active Directory) - This is the User attribute in Azure AD used for SDS Identity Matching. Watch the Identity Matching video for additional information on how to select the appropriate target directory attribute, and properly configure the identity matching settings for the teacher.

  1. On the Review page, ensure you've made the appropriate selections. If no additional changes are needed, click Create Profile. Once you create a sync profile, SDS will begin a pre-sync validation process. If any errors are found during this process, you will have the option to fix them and re-upload files before clicking the resume sync button and starting the real synchronization process. If you receive errors and choose not to update them, you can still choose to resume sync without addressing the errors.

Review page.

To help automate the sync process after setting up your sync profile Use Microsoft Flow to upload CSV files to SDS. This allows you to configure automated CSV uploads.

Overview of School Data Sync

SDS V2.1 CSV File Format

How to deploy School Data Sync by using CSV files in the Clever format

How to deploy School Data Sync by using OneRoster CSV files

How to deploy School Data Sync using CSV files in the V1 format

SDS Errors