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 (optional) | |
| SSH User (optional) |
|
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)