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)

 
Password (required)  

 

 

SQL2.png

Enabled (optional)

Private (optional)

Public (optional)

SSH Host

SSH User

SQL3.png

Input Table (required)

DB Table Name (required)

Export

Incremental

Column (required)

SQL4.png

Column Name (required)

DB Column Name (required)

Data Type (required)

Size (optional)

Nullable (optional)

Default Value (optional)