The SQL Server connector enables to connect to Microsoft SQL Server data sources.
Data In/Data Out
|Data Out||CSV files in the
Learn more: about the folder structure please go to this article.
|Host (required)||Name of 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.|
Checked if SSH required to connect to database.
|Private (optional)||Private key.|
|Public (optional)||Public key.|
|SSH Host (optional)||Name of SSH Host.|
|Table ID (required)||ID of the table. The ID of the table should be an integer.|
|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.|