Data Synchronisation Studio - Import, Export, Migration and Integration

Data Sync simplifies the data integration process, making complex integrations a thing of the past

Reliable and quick Data Integrations are critical to your business, enabling you and your teams to work more efficiently and stay ahead of the competition

Data Synchronisation Studio supports you and your business by providing a simple yet 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 works for both types of users, those who want to keep it simple with a NO CODE option, and those that require a more technical integration.

Data Synchronisation Studio Features

Connect to Files, SQL, SharePoint, Dynamics, Office 365 and many other data sources

  • Import + Export

    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.

  • Data Reconciliation

    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.

  • Data Preview

    Preview all your data before any changes are applied and select which data you wish to change. Prevent those Oops moments!

  • Transformation

    Simple and Complex transformations via Calculated Columns, Dynamic Columns and Lookup features.

  • Lookups

    Use powerful Lookups to lookup data in other Data Sources, Create Mapping Transformation tables and more.

  • Connection Library

    Manage your connection configuration via the Connection Library and quickly and easily connect to data sources from the library.

  • Schedule

    Automate the execution of your Data Synchronisation Studio packages with Ouvvi, Task Schedular, SQL Agent, Command Line or API.

  • C# Code

    Use the .NET Framework to create your own powerful Data Transformation Expressions. Execute your own code before and after the project runs and more.

  • API

    Use Project Automation to hook into the process and run custom code.

Connect to your enterprise applications straight out of the box

Use the included Data Sync connectors to connect with common enterprise applications or create your own Data Sources with the connector SDK in Visual Studio.
S