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

ReadLearn more: about the folder structure here.

Parameters

SQL1.png

Host (required)

Port (required)

Database (required)

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

Default Value (optional)

SQL5.png

Column Name (required)

DB Column Name (required)

Data Type (required)

Size (optional)

 

 

 

Back to top