Import and Export your Data

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

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.

Preview your Data Before Syncing

Data Prep and Blend: Ensure you have full visibility of your 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

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

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.