- Tour of Data Sync
- Data Sources
- Installing Data Sync
- Install Encryption Key
- Connecting to a Source
- Connecting to a Target
- Connection Properties
- Schema Mapping
- Compare
- Synchronise
- Incremental Sync
- Create a Connection Library
- Using the Connection Library
- Edit the Connection Library
- Lookups
- Calculated Columns
- Filters
- Dynamic Columns
- Project Automation
- Project Properties
Before you Begin - Creating your First Project
Use this follow through tutorial to create your first Data Sync project, syncing a CSV file to a new and existing SQL table. Please use the following page to ensure you are ready to create your first project and follow along with the tutorial.
We will first see how we can create a new SQL table in Data Sync and then we will show how to connect to an existing SQL table and update the data it holds.
Download Data Sync
Before beginning this tutorial please ensure that you have downloaded and installed Data Sync.
Project Data
Please download the following two CSV files in order to follow along with the tutorial. The first is a CSV of 400 Dummy Customers (New Customer Data) which will be added to the new SQL table. The second is a CSV of 100 Dummy Customers (Update Customer Data) to update the existing SQL table with.