Loader MsSQL
MsSQL loader exports data to Microsoft SQL server database.
Prerequisite
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
Upload all files in /data/in/files.
Data Out
N/A
Learn more: about the folder structure here.
Parameters
| Host (required) | Name of server that hosts the database. |
| Port (required) | The port number you want to access. |
| Database (required) | Name of the database. |
|
Username (required) |
Account name. |
| Password (required) | Account password. |
| Enabled (optional) | If you want to SSH to be enabled. |
| 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) | If you want a certain table to be loader or not. By default, it is true. |
| Incremental (optional) | Signifies if you want to load the data by overwriting whatever is in database or incrementally. |
| Column (required) | Refers to the primary key that is used for incremental load. |
| Column Name (required) | Refers to the name of input csv file. |
| DB Column Name (required) | Refers to how it's going to be named in destination database. |
|
Data Type (required) |
The data type you want to use. |
|
Size (optional) |
The maximum number of digits used by the data type of the column or parameter. |
|
Nullable (optional) |
If you want the value to be nullable. |
| Default Value (optional) |
The default value is loaded in case of empty value, so if you use |