Connector MsSQL
The SQL Server connector enables connections to Microsoft SQL Server (MsSQL) is a relational database management system (RDBMS) developed by Microsoft. It is designed to store and retrieve data sources.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 |
Learn more: about the folder structure please go to this article.
Parameters
DB
| 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. |
SSH
| 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. |
Table
| 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(optional) |
Enabled for this table to be pulled from the database. |