Why Choose Data Synchronisation Studio
Data Synchronisation Studio (Data Sync) is a powerful and versatile data integration solution that helps you manage and synchronise your data across different systems with ease.
Concept
Data Sync is based on the concept of a Data Comparison Engine, where you compare data in a source data source to a target data source. Data Sync takes care of the operations required to make the target data set identical to the source.
Data Sync reads the data from the source and target systems, then reconciles the data by joining the data sets via the Key Column(s) defined in the schema map. This produces a Change Set of ADD/UPDATE/DELETE actions to apply to the target, making it the same as the source.
The Data Sync Designer is where you design your data projects. The Designer allows you to quickly and easily build and test your data projects.
Key Benefits
Control over data flow
With Data Sync, you have the ability to install the software on your own hardware, giving you complete control over your data flow. This ensures maximum security and allows you to comply with your organization's data policies.
Extensibility
Data Sync offers a range of features that enable you to extend its base functionality according to your specific requirements. Dynamic columns and project automation allow you to customize your data synchronisation process to meet your unique needs.
Custom connectors
Data Sync allows you to create your own connectors, enabling you to integrate with virtually any data source, giving you the flexibility to adapt to your ever-changing data landscape.
Data transformation
With calculated columns, Data Sync provides you the ability to transform your data using C# functions. This feature allows you to decorate and manipulate your data as needed, ensuring that it is in the desired format for your target data source.
Efficient data comparison engine
Data Sync utilizes a powerful Data Comparison Engine that compares data in a source data source to a target data source, intelligently taking care of the operations required to make the target data set identical to the source.
Intuitive design and simple concept
The Data Sync Designer provides an easy-to-use interface for designing your data projects, allowing you to quickly build and test your data synchronisation processes. The core concept behind Data Sync is straightforward � simply connect your data sources, map your schema, compare the data sets, and sync the changes. This simplified workflow ensures that you can efficiently synchronise your data without getting bogged down in complexities.
Flexible schema mapping
Data Sync offers the ability to adjust schema mapping and define key columns, enabling you to join records and determine the necessary ADD/UPDATE/DELETE operations to synchronise your data.
Compare and Sync functionality
Data Sync's Compare and Sync feature allows you to analyze the differences between your source and target data sets, giving you the option to selectively choose which rows you want to synchronise.