Overview of School Data Sync and Classroom

Note: 

Microsoft has several tools you can deploy to help you import and use Student Information System (SIS) data in Office 365 and Azure Active Directory:

  • School Data Sync helps you import Student Information System (SIS) data into Office 365.

  • Microsoft Classroom is a customized website that lets you organize effective use of Office 365 services in your classroom.

School Data Sync

School Data Sync helps to automate the process of importing and integrating school Student Information System (SIS) data to use with Office 365 education aids, like Microsoft Classroom and OneNote Class Notebooks.

The tool also gives application developers a single cloud API to use for creating applications that integrate with multiple SIS providers, along with single sign-on (SSO) capabilities. App developers can use the API to access section, student, teacher, school, or class roster information to personalize experiences for teachers and students who use their apps. To learn more about Microsoft Classroom please visit https://sds.microsoft.com.

Microsoft Classroom

Microsoft Classroom is a single experience for managing all classes and assignment workflow for teachers and students. Teachers can use the Office documents and class materials they already have, or create new ones using familiar Office applications like Word and PowerPoint. Classroom lets teachers create a Class Notebook for all the students in their class quickly. Assignments in Classroom can reference materials from the Class Notebook, Office documents, and links to Internet content. Teachers can create assignments for multiple classes at the same time, easily grade submissions, and give private feedback.

For more support documents about Microsoft Classroom, please visit https://aka.ms/classroomsupport. To learn more about Microsoft Classroom, please visit https://classroom.microsoft.com.

Choose a deployment method

There are several methods available for syncing SIS information with Office 365: Using comma separated value (CSV) files, using PowerSchool API, using Clever API, or using OneRoster CSV files. Regardless of the method you choose, the same requirements apply.

School Data Sync requirements

  1. An Office 365 Education tenant.

  2. Global Administrator Permissions

Classroom requirements

  1. An Office 365 Education tenant.

  2. Exchange Online License applied to each Classroom user

  3. SharePoint Online License applied to each Classroom user

  4. Classroom License applied to each Classroom user

Deployment methods

  • Deploy School Data Sync by using CSV files

    You can use CSV files with School Data Sync (SDS) to help import SIS data into Office 365. Using this method, you'll export or create six CSV files based on your SIS data, to set up the synchronization profile, and then upload them into SDS for processing.

    Follow these steps to deploy School Data Sync by using CSV files.

  • Deploy School Data Sync by using PowerSchool API

    Deploy School Data Sync by using PowerSchool API

    PowerSchool is a SIS provider that works with School Data Sync to help import SIS data into Office 365. SDS connects directly to the SIS and synchronizes data using the REST-based APIs provided by PowerSchool. Using this method, you can avoid exporting and managing CSV files from the SIS database. Instead, you create a synchronization profile to sync directly from your PowerSchool SIS.

    Follow these steps to deploy School Data Sync by using PowerSchool API.

  • Deploy School Data Sync by using Clever Sync

    Deploy School Data Sync by using Clever API

    Clever is an identity management and rostering solution that works with School Data Sync to help import SIS data into Office 365. SDS connects directly to the Clever instance and synchronizes data using the REST-based APIs provided by Clever. Using this method, you can avoid exporting and managing CSV files from the SIS database. Instead, you create a synchronization profile in SDS to sync directly from your Clever instance.

    Follow these steps to deploy School Data Sync by using Clever API.

  • Deploy School Data Sync by using OneRoster

    You can use OneRoster CSV files with School Data Sync (SDS) to help import SIS data into Office 365. Using this method, you'll export or create OneRoster CSV files based on your SDS data, run them through a conversion process, and then upload them into SDS for processing.

    Follow these steps to deploy School Data Sync by using OneRoster.

See Also

Overview of School Data Sync and Classroom

CSV files for School Data Sync

School Data Sync required attributes for PowerSchool Sync

School Data Sync errors and troubleshooting

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×