Introducing School Data Sync’s new Flow Connector for Automating CSV File Sync

Published 10-09-2018 09:00 AM 14.1K Views
Microsoft

The School Data Sync (SDS) team just announced the availability of a new, simpler, and more reliable way to automate and schedule your CSV file uploads to SDS and keep your SIS data in sync with Office 365. The new solution uses an SDS Microsoft Flow connector and template which makes implementing, managing, and monitoring file uploads easier. Because the solution is built on Flow, it includes a simple UI based setup, and more robust reporting and monitoring capabilities. The SDS Flow connector also provides rich visualizations of file upload success and sync history, providing real time results for each stage of the upload process.

 

SDS Flow.png

The new CSV sync and automation solution is more secure and reliable than the previous SDS toolkit, no longer requiring cached credentials subject to token expiry. The entire setup and configuration process is also managed entirely within the Office 365 user interface, and doesn’t require the use of complex PowerShell scripts and local system scheduled tasks.

 

The setup is simple. Just install an on-premise data gateway, create your connections and template in Microsoft Flow, and use the SDS Flow connection to enable sync automation for your file uploads into SDS. The full step-by-step instructions to guide you through the process can be found at http://aka.ms/sdsflow. For free 1 on 1 assistance with the SDS Flow setup, please contact the SDS Support Team at http://aka.ms/sdssupport.

3 Comments
Occasional Visitor

thanks

Occasional Contributor

Hi Bill,

 

We are just starting to explore setting up SDS for our school board now.  I came across your post above and checked out the link to the Flow connector.  I noticed that the step-by-step breakdown guide was no longer active so I just wanted to check if this connector was still supported and was the best route to automate keeping SDS up to date with our SIS data.

 

Thanks,

Stuart Gray

 

Education Technology Consultant

Western Quebec School Board

Regular Visitor

Great article! However the link http://aka.ms/sdsflow does not seem to work. Can you provide us with a working link? 

%3CLINGO-SUB%20id%3D%22lingo-sub-268594%22%20slang%3D%22en-US%22%3EIntroducing%20School%20Data%20Sync%E2%80%99s%20new%20Flow%20Connector%20for%20Automating%20CSV%20File%20Sync%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-268594%22%20slang%3D%22en-US%22%3E%3CP%3EThe%20School%20Data%20Sync%20(SDS)%20team%20just%20announced%20the%20availability%20of%20a%20new%2C%20simpler%2C%20and%20more%20reliable%20way%20to%20automate%20and%20schedule%20your%20CSV%20file%20uploads%20to%20SDS%20and%20keep%20your%20SIS%20data%20in%20sync%20with%20Office%20365.%20The%20new%20solution%20uses%20an%20%3CA%20href%3D%22https%3A%2F%2Fus.flow.microsoft.com%2Fen-us%2Fconnectors%2Fshared_microsoftschooldatasync%2Fmicrosoft-school-data-sync%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3ESDS%20Microsoft%20Flow%20connector%3C%2FA%3E%20and%20template%20which%20makes%20implementing%2C%20managing%2C%20and%20monitoring%20file%20uploads%20easier.%20Because%20the%20solution%20is%20built%20on%20Flow%2C%20it%20includes%20a%20simple%20UI%20based%20setup%2C%20and%20more%20robust%20reporting%20and%20monitoring%20capabilities.%20The%20SDS%20Flow%20connector%20also%20provides%20rich%20visualizations%20of%20file%20upload%20success%20and%20sync%20history%2C%20providing%20real%20time%20results%20for%20each%20stage%20of%20the%20upload%20process.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F55833i3D6BA9E466B966B1%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22SDS%20Flow.png%22%20title%3D%22SDS%20Flow.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EThe%20new%20CSV%20sync%20and%20automation%20solution%20is%20more%20secure%20and%20reliable%20than%20the%20previous%20SDS%20toolkit%2C%20no%20longer%20requiring%20cached%20credentials%20subject%20to%20token%20expiry.%20The%20entire%20setup%20and%20configuration%20process%20is%20also%20managed%20entirely%20within%20the%20Office%20365%20user%20interface%2C%20and%20doesn%E2%80%99t%20require%20the%20use%20of%20complex%20PowerShell%20scripts%20and%20local%20system%20scheduled%20tasks.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20setup%20is%20simple.%20Just%20install%20an%20on-premise%20data%20gateway%2C%20create%20your%20connections%20and%20template%20in%20Microsoft%20Flow%2C%20and%20use%20the%20SDS%20Flow%20connection%20to%20enable%20sync%20automation%20for%20your%20file%20uploads%20into%20SDS.%20The%20full%20step-by-step%20instructions%20to%20guide%20you%20through%20the%20process%20can%20be%20found%20at%20%3CA%20href%3D%22http%3A%2F%2Faka.ms%2Fsdsflow%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttp%3A%2F%2Faka.ms%2Fsdsflow%3C%2FA%3E.%20For%20free%201%20on%201%20assistance%20with%20the%20SDS%20Flow%20setup%2C%20please%20contact%20the%20SDS%20Support%20Team%20at%20%3CA%20href%3D%22http%3A%2F%2Faka.ms%2Fsdssupport%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttp%3A%2F%2Faka.ms%2Fsdssupport%3C%2FA%3E.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-268594%22%20slang%3D%22en-US%22%3E%3CP%3ECheck%20out%20the%20new%20SDS%20Microsoft%20Flow%20Connector%20for%20Automating%20CSV%20Sync%20between%20your%20SIS%20and%20Office%20365!%26nbsp%3B%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F55835i8B23487A5383669B%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22SDS%20Flow.png%22%20title%3D%22SDS%20Flow.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-268594%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EEducation%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Flow%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESchool%20Data%20Sync%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-841561%22%20slang%3D%22en-US%22%3ERe%3A%20Introducing%20School%20Data%20Sync%E2%80%99s%20new%20Flow%20Connector%20for%20Automating%20CSV%20File%20Sync%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-841561%22%20slang%3D%22en-US%22%3E%3CP%3Ethanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1376594%22%20slang%3D%22en-US%22%3ERe%3A%20Introducing%20School%20Data%20Sync%E2%80%99s%20new%20Flow%20Connector%20for%20Automating%20CSV%20File%20Sync%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1376594%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Bill%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20are%20just%20starting%20to%20explore%20setting%20up%20SDS%20for%20our%20school%20board%20now.%26nbsp%3B%20I%20came%20across%20your%20post%20above%20and%20checked%20out%20the%20link%20to%20the%20Flow%20connector.%26nbsp%3B%20I%20noticed%20that%20the%20%3CA%20href%3D%22http%3A%2F%2Faka.ms%2Fsdsflow%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3Estep-by-step%20breakdown%20guide%3C%2FA%3E%20was%20no%20longer%20active%20so%20I%20just%20wanted%20to%20check%20if%20this%20connector%20was%20still%20supported%20and%20was%20the%20best%20route%20to%20automate%20keeping%20SDS%20up%20to%20date%20with%20our%20SIS%20data.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3CP%3EStuart%20Gray%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EEducation%20Technology%20Consultant%3C%2FP%3E%3CP%3EWestern%20Quebec%20School%20Board%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1485881%22%20slang%3D%22en-US%22%3ERe%3A%20Introducing%20School%20Data%20Sync%E2%80%99s%20new%20Flow%20Connector%20for%20Automating%20CSV%20File%20Sync%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1485881%22%20slang%3D%22en-US%22%3E%3CP%3EGreat%20article!%20However%20the%20link%26nbsp%3B%3CA%20href%3D%22http%3A%2F%2Faka.ms%2Fsdsflow%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttp%3A%2F%2Faka.ms%2Fsdsflow%3C%2FA%3E%26nbsp%3Bdoes%20not%20seem%20to%20work.%20Can%20you%20provide%20us%20with%20a%20working%20link%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Version history
Last update:
‎Oct 08 2018 10:51 PM
Updated by: