ePrivacy and GPDR Cookie Consent by Cookie Consent Skip to main content

Connector MsSQL

Microsoft SQL Server (MsSQL) is a relational database management system (RDBMS) developed by Microsoft. It is designed to store and retrieve data as requested by other software applications, making it a powerful and scalable solution for managing large volumes of structured data. MsSQL is a robust connector, facilitating the seamless transfer of structured customer-related data to the CDP. 

Data In/Data Out

Data In N/A
Data Out CSV files in the out/tables folder.

Learn more: about the folder structure please go to this article. 




Host (required)

Name of the server that hosts the database.

Port (required)

The port number you want to access. 

Database (required)

Name of database.

Username (required)

Account name. 

Password (required)

Account password.



Enabled (optional)

Checked if SSH required to connect to the database. 

Private (optional)

Private key. 

Public (optional)

Public key.

SSH Host (optional)

Name of SSH Host.

SSH User (optional)

Username of SSH Host. 



Name (required)

Name of the table.

Query (required) 

A query is a request to access data from a database to manipulate it or retrieve it.

Output Table (required) 

The name of the output table you want to load the query. 


Enabled for this table to be pulled from the database.