Share via


Connect data support for multiple SIS data sources

Important

By connecting and making institution data available with School Data Sync (SDS), you acknowledge that you are authorized to share this data with Microsoft and commit to adhere to your organization’s data governance standards.

Expectations and Limitations

  • The ability to configure multiple data sources is considered an advanced feature
    • This feature shouldn't be used create multiple connect data configurations to the same source system.
    • This feature shouldn't be used as an attempt to split data from the same source system to improve performance as the feature increases sync run timing to manage extra configurations.
  • Ability to have more than one active connected data source configuration is controlled by flighting the tenant.
    • For a tenant to be flighted, you must acknowledge reading and understood the expectations and limitations of this feature.
    • Send request to Microsoft Education Support for consideration.
    • There could be follow-up questions and determined that this feature isn't the proper approach based on the described scenarios.
  • School Data Sync is limited to 15 connected data source configurations / multi-sources.
    • Environments requiring over 15 independent sources need to implement preprocessing to combine the data into SDS v2.1 CSV formatted data before uploading to School Data Sync. Username values in the users.csv need to include the fully qualified domain value, for example, username@domain, for user targeted-domain identity mapping.
    • Each connected data source configuration is grouped as an independent section under Sync | Configuration | Connect data. List order based on Source name.
  • Each connected data source configuration allows for the ability to Edit source details independently.
  • Each connected data source configuration with CSV data format allows the independent ability to Upload CSV data to supply subsequent updates until Sync end date is reached.
  • For tenants using Power Automate to upload subsequent updates for CSV files, each Connect Data source configuration provides an independent ‘ID’ that is used to configure the corresponding Power Automate flow.
    • After the Sync end date is reached for the corresponding Connect data configuration, and after completing the Academic session transition, a new ‘ID’ is generated. The corresponding Power Automate flow configuration needs to be updated with the new ‘ID’.
  • This feature shouldn't be used to support the ability to split data from the same independent source and provide the data to separate connected data source configurations.
    • The new School Data Sync experience eliminates the (Classic) limitations based on csv data size and row counts.
    • Customers transitioning from (Classic), that needed to split data from the same source, no longer need to split the data and should provide it in a single data set.
  • Each connected data source configuration has an independent Sync end date.
  • After a connected data source configuration Sync end date is reached, and the Status is Expired, the ability to Edit source details is unavailable.
  • When a connected data source configuration’s Sync end date is reached, and the Status is Expired, between the last and next Sync run, School Data Sync will reset all Manage data configurations before starting the next Sync.
    • Reset reprocesses all the active source information for the remaining and active Connect Data sources in the subsequent sync run. The reset takes longer than a traditional sync run as it attempts to process everything line by line instead of looking at changes based on the prior delta file.
  • If a connected data source configuration is deleted, between the last and next Sync run, School Data Sync will reset all Manage data configurations before starting the next sync. (Currently deleted is only supported through the Industry Data Graph API.)
    • Reset reprocesses all the active source information for the remaining and active Connect Data sources in the subsequent sync run. The reset takes longer than a traditional sync run as it attempts to process everything line by line instead of looking at changes based on the prior delta file.
  • If there's a Sync run where data isn't able to be obtained from an active connected data source, the entire Sync run is marked with a Failure status and won't process any data changes for the other active connected data source configurations.
  • SDS v2.1 CSV & OneRoster API SourceId and SDS v1 CSV SIS ID values must be unique across Connected data sources in the same tenant.

Connect new source

  • To access the SDS Admin Portal launch your web browser, navigate to sds.microsoft.com, and then sign in using your Microsoft 365 Global Administrator account.

  • To connect data to a new source, navigate to Sync | Configuriaton | Connect data tab.

  • Select Connect new source

    Screenshot that shows keep API source format.

  • For the remainder of the steps, follow Connect data beginning with select the Source format.