Data Synchronisation Studio supports you and your business by providing a powerful designer for all of your data integration processes.
By reducing the number of unnecessary configuration steps, you can get going in a matter of clicks. Simply connect to your data sources, map your data in the schema map, compare and then sync.
To make this even quicker you can store your connections in the Connection Library, so then with a simple drag and drop you can be ready to go in a few seconds.
Data Sync is built for all data integration needs and skill levels, and can be used by those who want to keep it simple with a NO CODE option, and those that require a more technical integration.
Connect to Files, SQL, SharePoint, Dynamics, Office 365 and many other data sources
Import your data from various Data Sources quickly and easily. Apply Schema Mapping and Data Type conversion on the fly and Export your data to various formats.
Compare your Data with the target Dataset and create a difference Change set of ADD, UPDATE and DELETE actions to apply rather than drop all data and re-import.
Preview all your data before any changes are applied and select which data you wish to change. Prevent those Oops moments!
Simple and Complex transformations via Calculated Columns, Dynamic Columns and Lookup features.
Use powerful Lookups to lookup data in other Data Sources, Create Mapping Transformation tables and more.
Manage your connection configuration via the Connection Library and quickly and easily connect to data sources from the library.
Automate the execution of your Data Synchronisation Studio packages with Ouvvi, Task Scheduler, SQL Agent, Command Line or API.
Use the .NET Framework to create your own powerful Data Transformation Expressions. Execute your own code before and after the project runs and more.
Use Project Automation to hook into the process and run custom code.
Preview your Data before you execute against the target ensuring you do not make costly mistakes.
Manually choose which rows to apply, allows you to make selective decisions on what to update.
Use Excel like functions to apply custom Data Transformation on your row data.
Go beyond the limits of simple expressions and use the .NET Framework with C# to apply complex data transformations. Use Project Automation to run your own code during the project execution to handle all those edge cases.