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

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

SQL1.png

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.

 

SQL2.png

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. 

 

SQL3.png

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 primaryKey that is used for incremental load. 


SQL4.png

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  "default": "",  it will create NULLs in destination DB for empty strings in csv file. "default": "-" would create - a character for empty strings.