How to deploy School Data Sync using SDS v2 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'll 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.
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.
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
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 created your four CSV files and ensure they're ready to use. 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.
- 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
- After logging in, select + Add Profile in the left-hand navigation pane to create a sync profile.
On the Choose Connection Type page, enter a name for the sync profile and select Upload CSV files and CSV files: SDS V2 Format. Once complete, select Start.
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 CSV files. Once uploaded, complete your selections on the page as appropriate and select Next.
If running with option for creating new users and wish to adopt V2.1 CSV, we have released a tool that will help you prepare to support V2.1 CSV format as part of your transition for back to school. See update anchor IDs before creating users.
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'll typically want to do this at the end of the school year or term. Once SDS stops syncing the profile, you'll have the option to clean up the classes associated with this profile, as appropriate.
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.
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.
- On the User options page, select the appropriate identity matching options, and then select Next.
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.
- On the Review page, ensure you've made the appropriate selections. If no additional changes are needed, select 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'll 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.
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.