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)

Password (required)

Enabled (optional)

Private (optional)

Public (optional)

SSH Host

SSH User

Input Table (required)

DB Table Name (required)

Export

Incremental

Column (required)

Column Name (required)

DB Column Name (required)

Data Type (required)

Size (optional)

Nullable (optional)

Default Value (optional)