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).

The following parameters will help to define your data sync destination

and how it functions.

ParameterDescriptionExample

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.

4. Next Steps

Last updated