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) | Name of column in database. |
Data Type (required) |
The data type you want to use. |
Size (optional) |
The maximum number of digits used by the data type of the column or parameter. |
Nullable (optional) |
If you want the value to be nullable. |
Default Value (optional) | The default value you want it to be. |