Overview of School Data Sync and Classroom

Overview of School Data Sync and Classroom

Applies To: Office 365 Admin

Note: This topic is pre-release documentation and is subject to change in future releases.

Microsoft has several tools you can deploy to help you import and use Student Information System (SIS) data in classrooms:

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

  • 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. For example, app developers can use the API to access class roster information to personalize experiences for teachers and students who use their apps.

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 http://classroom.microsoft.com.

Choose a deployment method

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

Requirements:  

  • Your Office 365 tenant must be an Office 365 Education tenant.

  • Synced identities must be licensed for SharePoint Online and Exchange Online. Skype for Business licenses aren't required. Note that OneDrive for Business is provided through the SharePoint Online license.

    If a student or teacher doesn't have the required licenses in Office 365, School Data Sync will still create their profile, but Classroom will not finish provisioning properly for them for any apps they aren't licensed to use.

  • If you're not setting up an Office 365 tenant that will use synced identities, you can just create new cloud identities for teachers and students and license them for services when you set up their profiles.

Deployment methods:  

  • Deploy School Data Sync by using CSV files

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

    You can use CSV (comma separated value) files with School Data Sync (SDS) to synchronize your School Information System (SIS) users with Office 365. If you use this method, you'll need six separate CSV files based on your SIS data, to set up the synchronization profile. You'll create the files, and then upload them into School Data Sync for processing.

  • Deploy School Data Sync by using PowerSchool Sync

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

    PowerSchool Sync is an SIS provider that works with School Data Sync to help import student and teacher information into Office 365. SDS connects by using the REST-based APIs provided by the PowerSchool SIS system, and then creates the Office 365 profiles. There's a set of required attributes that you must map to Office 365. With this method, you can avoid creating CSV files and manually extracting data from the SIS databases.

  • Deploy School Data Sync by using Clever Sync

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

    Clever Sync is an identity management and rostering solution that works with School Data Sync to help import student and teacher information into Office 365. SDS connects by using the REST-based APIs provided by the Clever system, and then creates the Office 365 sync profiles. With this method, you can avoid creating CSV files and manually extracting data from the SIS database or Clever system.




School Data Sync Deployment Guidance

  1. Overview of School Data Sync and Classroom
  2. CSV Files for School Data Sync
  3. School Data Sync required attributes for PowerSchool Sync
  4. How to deploy School Data Sync by using CSV files
  5. How to deploy School Data Sync by using PowerSchool Sync
  6. How to deploy School Data Sync using Clever Sync
  7. School Data Sync errors and troubleshooting
  8. School Data Sync - One Roster
  9. School Data Sync Toolkit
  10. My Power School Connection Fails
  11. What SISes and MISes does School Data Sync support?
  12. What is School Data Sync?
  13. What is the rostering schema?
  14. How do I deploy School Data Sync?
  15. What apps work with School Data sync?
  16. Where is School Data Sync available?
  17. How does School Data Sync protect student information?
  18. Why doesn't my Customer Preview promo code link work?
  19. I received a 403 error when uploading CSV file using the Sync tool. How do I fix this?
  20. I received error 404 when running the School Data Sync Toolkit cmds. How do I fix this?
  21. Can I store and/or upload my CSV files if they are in a ZIP file format?
  22. Are the header names within the CSV files case sensitive?
  23. What are the requirements for accessing the SDS portal, and managing Sync?
  24. What happens with sync when my data changes in my SIS, or within my CSV files?
  25. Adding a Secondary Teacher
  26. Is there a character limitation for the SIS ID in the Section CSV file?
  27. Do I need to create more than 1 sync profile if my teachers and students are associated with different domains?
  28. Can I use both alpha and numeric characters for the School SIS ID?
  29. Why are Teachers or Students missing in the Organization tab?
  30. What attributes are synced with SDS?
  31. How can we export data from the SIS to Microsoft’s required CSV format?
  32. Can the SIS ID field for Sections contain spaces?
  33. What is the proper format for the Term StartDate and Term EndDate?
  34. Can I include optional attributes for sync if only some objects have a value populated for that attribute?
  35. Can I include empty columns in my CSV files?
  36. Do I need to remove the FirstName, LastName, and Password column if I’m not creating users through SDS?
  37. Does Microsoft provide extractor tools for my SIS data?
  38. Can a teacher sync if they are assigned to multiple schools?
  39. Can we export the sync issues/errors?
  40. Can we hide Sections from the GAL? If so, how?
  41. Will the standard welcome email be generated when users are synced/added to each sections/groups through SDS?
  42. If a class is set to inactive status manually through Classroom, will SDS change that status on the next sync if the CSV or SIS is different?
  43. Will SDS automatically sync student changes or do we have to restart sync on a regular basis?
  44. If we remove a user or section from Classroom will they reappear when we sync again?
  45. Why is there a character limitation on email addresses in SDS?
  46. How to sync objects with a sis id or attribute value less than 3 characters, or are less than 3 characters and start with a 0.
  47. Object limitations when synchronizing with SDS
  48. Migrate from Classroom Preview to Teams

Feedback and Knowledge Base