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

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.

 

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.

 

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.

Column Name (required)	Name of Column
DB Column Name (required)
Data Type (required)
Size (optional)
Nullable (optional)
Default Value (optional)