Transform your SQL Data Integration with Data Synchronisation Studio

The complete package for high performance, easy to design data integration and automation for SQL.
DOWNLOAD NOW
[Windows 64-bit Installer]

Use Cases

Import

With Data Sync you can quickly and easily import your data into SQL tables from other sources. Whilst your importing new data you can also update any records you may have in your table already.

Make use of the full provider list to connect to all your business applications.

Got multiple jobs that need running again and again? Use the Run Tool or Ouvvi to automate the process whilst logging how your projects are running.

Export

Need to get data out of your SQL tables? With Data Sync you can have your data exported within a moments.

Export your data to another business application or simply export into a CSV, XML or Excel file.

You choose how you want it, we make it happen.

Enhance Your Data

Use Data Sync to enhance existing SQL Tables with data from other data sources.

Use lookups to pull in useful data within the same project from multiple sources, to expand your dataset in one go.

Make use of the calculated column functions to apply data transformation to make batch changes to existing data, so you don't have to edit rows one by one.

Calculated Column
Connector Logos

Benefits

Ease of Use

The performance of Data Sync at design time as well as at runtime make it incredibly easy to build out your integrated processes. Projects can be setup and configured in minutes rather than days or weeks. So anyone in your team can make and edit projects.

Reliability

Data Sync & Ouvvi make for an incredibly reliable Data Integration Platform. Data Sync’s Data Reconciliation Engine married with Ouvvi’s reliable Queue based schedular ensure a robust and reliable data integration.

Customer Service

Our customer support is here to ensure that you have success with your Data Integration. We can help you get answers to your questions very quickly not days later.

Features

Data Sync Designer SQL Connection

Fast Iterative Design Experience

Data Integration is an iterative process and in an ideal world you should be able to see the data changes before they happen.

With Data Sync you start with the basics and then build on that, updating more data as you go rather than trying and failing to get it right on the first run. With Data Sync you can just as easily update existing data as you can add new records.

SQL Query Tool

The SQL Query Tool built in to Data Sync enables you to run SQL queries on your MS SQL Server, MariaDB, MySQL and PostgreSQL Databases directly from Data Sync.

Make edits to your SQL table or database without having to hop between applications.

The tool also allows you to preview the data in your tables and directly edit it from Data Sync.

Quickly Create New Tables

Don't waste time creating a table from scratch, adding in all the columns you think you need.

With Data Sync's quick start function you can create a new SQL table based on your source data. So everything you want included is added straight away.

But don't worry if you need to make edits: Add any columns you need to the table and just refresh the connection.

Schedule & Automate

Any reasonable Data Integration project needs the ability to schedule and automate each project so that you don't need to be there.

Data Sync comes with the ability to schedule and run tasks built in. The Run Tool make use of windows task scheduler, and is great for small integration projects.

However, it's likely you want to run more complex integrations and for those we bring you Ouvvi. Ouvvi provides the ability to set triggers on each of your projects. These can be time based triggers, to run on your schedule, or event based so that your project runs every time there is an update to your system.

Ouvvi Reporting

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 Scheduler, 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.

Valued and Trusted Worldwide

Customer Logos