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

Loader MsSQL

Loader MsSQ writes data to Microsoft SQL Server Database.

When connecting to an Azure database and using SSH tunnel, the username must be in format <username>@<databasename> instead of just <username> otherwise it will throw errors.

Data In

Upload all files in /data/in/files to the specified bucket and prefix. Existing files are overwritten.

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 database.

Username (required)

Account name.
Password (required) Account password.

 

SQL2.png

Enabled (optional)  If you want 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  If you want the database to be exported.
Incremental  Signifies if you want to load the data by overwriting whatever is in DB or incrementally.
Column (required)  Name of column in input table you want to load to the database.

SQL4.png

Column Name (required)  Name of Column
DB Column Name (required)  

Data Type (required)

 

Size (optional)

 

Nullable (optional)

 
Default Value (optional)