Data Synchronisation Studio

Copies data from one data source to another so that both are equal

DOWNLOAD NOW
[Windows 64-bit Installer]

Follow a simple uncomplicated Data Integration process

Connect Connect Map Map Compare Compare Synchronise Sync
Data Synchronisation Studio Screenshot

Import and Export your Data

Use Data Sync to Import your data from one data source and export it to another
Data Sync Designer

Use Data Sync to Import your data from one data source and export it to another. Data Sync compares the data between two data sources and identifies the differences. You then apply these differences to make the target the same as the source.

Data Sync can Update existing data as well as add new data. Simply choose a unique key column to identify each row and Data Sync takes care of the rest.

Even if you have a 10 million rows of data the Data Sync comparison engine is fast and efficient enabling you to quickly identify the differences between two data sets.

Mix and match our library of connectors as you need

Connect SQL Server to Salesforce, Salesforce to Dynamics 365 or SharePoint to Active Directory
Connector Logos

Preview your Data Before Syncing

Data Prep and Blend: Ensure you have full visibility of your Data
Preview Data

Preview your source and target data to ensure you are pulling the data you expect.

Not only can you preview your source and target data but you can preview how your data will look before any changes are made.

View the comparison results to quickly see where changes are being made and select only those that you wish to apply the changes to.

Saving you from all of those "oops" moments!

Transform your Data

Data Transformation via No-Code Expressions, C# Code and Lookups
Data Transformation

Use Calculated Columns, Dynamic Columns and Lookup features to make simple and complex data transformations.

Our powerful lookup capabilities mean you can lookup data in other sources, create mapping tables and more.

With Calculated Columns 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 in Dynamic Columns.

Customise your Integration Projects

Built in .NET C# code designer and compiler
Project Automation

For those that are feeling confident, you can use C# code to make your project work your way.

With Project Automation you can make use of the .NET Framework to execute your own code before and after the project runs, to hook into the process, meaning that your options are endless.

Use Project Automation to run your own code during the project execution to handle all those edge cases.

The Data Sync Run Tool

Schedule and Automate all of your Integration processes
Data Synchronisation Studio Run Tool Screenshot

Build out your Project

Build out your integration project with multiple step types and source control
Run Tool Designer

The Run Tool enables you to run multiple tasks in a sequence to form a full integration solution which you can then schedule using Simego Online, Ouvvi or Windows Task scheduler.

There are a number of powerful step types so you can fully build out your integration project. You can run Data Sync steps, external programs, send emails, write to the log and many more.

Make use of the report email step so that you are notified whether the project runs, succeeds or fails. Download, copy and delete files, execute SQL statements, execute your existing scripts, it is all possible with the Run Tool designer.

As the Run Tool is based off the file system it makes it easy to add your integration project to source control. This means you can follow a full DevOps path with your development, testing and production systems. Ensuring that everything is fully functional before deploying to production.

View Errors and Logs

Quickly diagnose errors, keeping any downtime to a minimum
Run Tool Logging

The Run Tool makes it quick and easy to see how your steps are running and if your project completed successfully.

The built in logging is accessible from the logs tab and will show you the full error exception so that you can understand what has gone wrong.

When designing and testing your steps you can quickly view the error in the Run Tool either by right clicking on the failed step or by going to the logs tab.

When you have built the project and it is running automatically on a schedule, you can view the log file for that run from the local log folder inside your project directory. However the sooner you can find the error the sooner you can fix the issue. Adding the Project Status Report step to your project enables you to be notified as soon as an error occurs.

Run from the command line

Start the Run Tool project or individual Data Sync files directly from the command line
Run from the Command Line

You can run your Run Tool and separate Data Sync Projects directly from the command line. This opens the possibility for you to use other programs to start your integration tasks for you. You can choose to either run a Run Tool Project or multiple Data Sync steps.

If you are running multiple environments you can manage your configurations directly from the command line. Either by passing a configuration file or overriding the registry settings. So you can quickly switch between Dev, Prod and UAT

When running from the command line you can also pass in variables so that they are dynamically added to your project at runtime. You can then use these in your project and steps as needed.

Schedule your Projects

Use Windows Task Scheduler to execute your Run Tool Projects
Schedule from Task Scheduler

Windows Task Scheduler or any other Scheduling program such as SQL Agent can be used to execute your Run Tool projects by simply using the command line options.

Just add your Run Tool project or Data Sync project to the scheduler of your choice and configure the schedule you need.

Schedule and Manage your Integration Projects

Use Ouvvi to schedule and organise all of your Integration Projects
Ouvvi Dashboard

For more complex integration scenarios use Ouvvi our all-in-one Management Platform for Data Sync Projects with Time and Event based Scheduling capabilities.

Ouvvi enables central management and documentation of your integration processes and can be used to execute Data Sync tasks as well as many other processes such as running Powershell and Console based programs.

For more information on Ouvvi check out our Ouvvi product page.

Why Simego DataSync?

Reasons why you should consider Simego Data Synchronisation Studio for your next Data Integration Project

no-code Data Integration

The Majority of Data Sync integration projects are no-code projects created with the Data Sync graphical IDE. Simple mapping of data source columns from source to target.

low-code Data Integration

When your requirements are more complex don't get stuck you can use C# to extend the capabilities.

Data Synchronisation Engine

Data Sync is powered by our Data Compare Engine where your source data is compared with the target data. This creates a change set of records to ADD, UPDATE and DELETE to make the target the same as the source.

Data Reconciliation

Use Data Sync to compare your Datasets for data reconciliation purposes as well as synchronisation. The Data Compare engine can easily work with millions of records.

Data Type conversion

Built in Data Type conversion by simply selecting a Data Type in the data source column mapping. Provides a simple way to convert Strings to Numbers etc.

Complete Connectors

Data Connectors that are more than just a simple wrapper over an API. Connectors handle server paging so you do not have those 5000 item limits. Connectors also work behind the scenes to handle those little quirks in the API.

Preview Data Changes

View the compare results before execution in the IDE to verify changes before they are applied.

Lookups

Advanced Lookup functions which use Caching and can be used across multiple Data sources so you can mix Lookups between data sources such as SQL Server and SharePoint.

Calculated Columns

Create new virtual columns from simple Excel like Expressions. Map these to the target to provide row level data transformation.

Dynamic Columns

Data Transformation via C# with the Full .NET Framework available.

Project Automation

Use C# to intercept the execution pipeline and implement custom logic. Configure parameters on Start to adjust the behaviour of the data load.

Repeatability

No-State know that each time a Data Sync task is run its the same as before.

Extensibility via Custom Connectors

You can build your own Data Sync connectors with C# & Visual Studio and benefit from the Data Sync solution.

Connection Library

Use a Connection Library to reuse Connection configuration and credentials across projects. When credentials are updated in the library all referenced connections are also updated automatically.

Configuration Management

Use User Settings to apply configuration changes across Projects, switch Connection Libraries and User settings via Environment configurations.

Credential Encryption

Use custom Encryption Keys protected by Windows Certificate Store to Encrypt your connection Credentials with AES-256 bit keys.

Source Control Friendly

Data Sync projects and RunTool projects are simple XML documents which can be added to a source control system.

Run Books

Use the RunTool or Ouvvi to build your run books or sequence of projects to execute to complete your integration.

Run from Command line

Run Data Sync projects from the command line. Pass parameters to change the Environment such as DEV, UAT, PROD.

Schedule

Use Windows Task Scheduler, Ouvvi Server or Simego Online to schedule your projects.

Error Logging

Detailed Error Logging referenced back to each execution run with full stack trace of errors.

Battle Tested

Used by customers for the past 10 years for all kinds of use-cases and proven to be up to the job and reliable.

No SSIS

No dependencies on other software applications complete Data Integration Platform.

Local Deployment

Deployed on your hardware to ensure Security and Data Privacy on your network no requirement to send your data to the Cloud.

No Runtime Limits

Being Locally deployed, there are no RunTime limits your integration tasks can run for hours.

Easy Backup

Backup your integration by simply copying your project files.

Valued and Trusted Worldwide

Customer Logos