MsSQL loader exports data to Microsoft SQL server database.
When connecting to an Azure database and using an SSH tunnel, the username must be in the format
<username>@<databasename> instead of just
<username> otherwise, it will throw errors.
Data In/ Data Out
|Data In||Upload all files in
Learn more: about the folder structure here.
|Host (required)||Name of server that hosts the database.|
|Port (required)||The port number you want to access.|
|Database (required)||Name of the database.|
|Password (required)||Account password.|
|Enabled (optional)||If you want a certain table to be pulled from the database.|
|Private (optional)||Private key.|
|Public (optional)||Public key.|
|SSH Host (optional)||Name of SSH Host.|
|SSH User (optional)||Username of SSH Host.|
Input Table (required)
|The name of the input table you want to load the database.|
|DB Table Name (required)||The name of the table that will be created in the database.|
|Export (optional)||True if you want this table to be loader or not. By default, it is true.|
Signifies if you want to load the data by overwriting whatever is in database or incrementally.
Defines primary key column. Can be used with incremental load.
Incremental load with primary key - just rows with unique primary key will be loaded.
Primary keys witnout incremental - all rows loaded, but columns set as primary key in loader will be also PKs in destination.
|Column Name (required)||Refers to the column in the input csv file.|
|DB Column Name (required)||Refers to how this column will be named in destination database.|
Data Type (required)
|The data type used in the column.|
|The maximum number of digits used by the data type of the column or parameter.|
|If you want the value in this column to be nullable.|
|Default Value (optional)||
The default value that is inserted for empty values in the column. For example,