Manage all aspects of connections
Available Sub Commands
add
Add a new connection. You can use the following arguments.
general arguments
Argument | Description |
|---|---|
-h [ --help ] | Display this message |
--name arg | The name of the connection |
--con-type arg | The type of the connection. Either database, hadoop, msas, odbc, unix or windows |
--odbc-source arg | The system DSN to use from the OS's ODBC settings |
--odbc-source-arch arg | The architecture of the system DSN. Valid values are 32 and 64. Defaults to 32 if not specified. |
--method arg | The login method to use |
--host-id arg | The host ID of remote machine |
--db-link-id arg | The database link ID that identifies a database this connection will use |
--db-id arg | Source database ID or database name (Oracle SID, TNS Name, Teradata TDPID) |
--db-type arg | The type of database this connection represents, Either local, other, sqlserver, db2, teradata, oracle, netezza, greenplum, hive, msasmultidim, pdw, msastabular, postgresql, or custom |
--db-home arg | The database home directory if it is different than the standard home directory |
--extract-user-id arg | The user ID this connection will use when logging in as a non-admin |
--extract-pwd arg | The password this connection will use when logging in as a non-admin |
--admin-user-id arg | The user ID this connection will use when logging in as an admin |
--admin-pwd arg | The password this connection will use when logging in as an admin |
--work-dir arg | A path to a local writeable directory to store temporary files |
--pre-login-act arg | The action to run before logging into the remote host |
--post-login-act arg | The action to run after logging into the remote host |
--login-prompt arg | The login prompt to look for on the remote unix host |
--pwd-prompt arg | The password prompt to look for on the remote unix host |
--command-prompt arg | Unix command prompt or the tail-end of that prompt (typically $) |
--server arg | The name of the server to use |
--doc-1 arg | Documentation field 1 |
--doc-2 arg | Documentation field 2 |
--doc-3 arg | Documentation field 3 |
--doc-4 arg | Documentation field 4 |
--doc-5 arg | Documentation field 5 |
--doc-6 arg | Documentation field 6 |
--doc-7 arg | Documentation field 7 |
--doc-8 arg | Documentation field 8 |
--doc-9 arg | Documentation field 9 |
--doc-10 arg | Documentation field 10 |
--doc-11 arg | Documentation field 11 |
--doc-12 arg | Documentation field 12 |
--doc-13 arg | Documentation field 13 |
--doc-14 arg | Documentation field 14 |
--doc-15 arg | Documentation field 15 |
--doc-16 arg | Documentation field 16 |
--dtm-set-name arg | The data type mapping set this connection will use |
Batch Arguments
Table of arguments
Common Arguments
| Argument | Description |
|---|---|
-c [ --config-file ] <arg> | A configuration file that contains program options (format is INI file) |
| -o [ --output-mode ] <arg> | Either human, json or xml. |
| -l [ --log-level ] <arg> | Log level, 0-5 inclusive. 0=only fatal errors, 5=all logging messages. |