MS SQL Server Table

1. Overview
Microsoft SQL Server is one of the main relational database management systems on the market that serves a wide range of software applications for business intelligence and analysis in corporate environments.
Based on the Transact-SQL language, it incorporates a set of standard language programming extensions and its application is available for use both on premise and in the cloud.
Microsoft SQL Server is ideal for storing all the desired information in relational databases, as well as to manage such data without complications, thanks to its visual interface and the options and tools it has.
Prior to setting up your data sync destination, ensure that you've configured your Source.​
The MS SQL Server Table destination supports batch and real-time syncs.
2. Destination Tab
The following table outlines the mandatory and optional parameters you will find on the Destination tab (Image 1).
Destination Details
Column Mapping
Filter
The following parameters will help to define your data sync destination
Define your Sync Behaviour.
Add in your Post Sync Scripts, if required.
Define your Permissions.
If you are running a real-time sync, set up your Listener Config and enable it to begin your sync.
If you are running a batch sync, click Jobs > Start a Job to begin your sync.
 and how it functions.
Parameter
Description
Example
Destination
Mandatory. Select your destination from the drop down menu.
MS SQL Server Table
Connection String
Mandatory.  The encrypted Connection String used to connect to your MS SQL Server. The Connections UI will automatically encrypt this value for you.
You can find an example Connection String here.​
Table
Mandatory. The name of the MS SQL Server table that you want to sync your data to, including the schema
dbo.employees
ID Column
The name of the identity column that exists in the destination (or a single column that is guaranteed to be unique and automatically populated for every new record) 
​
ID Column Data Type
The data type of the above ID Column. 
​
The Column Mapping section is where you define which source columns you want to sync to which destination columns. You can repeat the values for multiple columns.
Parameter
Description
Example
Source Column
Mandatory. The name of your column as it appears in the source.
Name
Target Column
Mandatory. The name of your column as it appears in the destination.
Name
You have the option to add a destination filter to your data sync. Please review the documentation here for more information on destination filters.​
Image 2: Define your Destination
4. Next Steps
Define your Sync Behaviour.
Add in your Post Sync Scripts, if required.
Define your Permissions.
If you are running a real-time sync, set up your Listener Config and enable it to begin your sync.
If you are running a batch sync, click Jobs > Start a Job to begin your sync.

Parameter	Description	Example
Destination	Mandatory. Select your destination from the drop down menu.	MS SQL Server Table
Connection String	Mandatory. The encrypted Connection String used to connect to your MS SQL Server. The Connections UI will automatically encrypt this value for you.	You can find an example Connection String here.
Table	Mandatory. The name of the MS SQL Server table that you want to sync your data to, including the schema	dbo.employees
ID Column	The name of the identity column that exists in the destination (or a single column that is guaranteed to be unique and automatically populated for every new record)
ID Column Data Type	The data type of the above ID Column.

Parameter	Description	Example
Source Column	Mandatory. The name of your column as it appears in the source.	Name
Target Column	Mandatory. The name of your column as it appears in the destination.	Name

MongoDB Collection

Oracle Table

Last modified 3mo ago