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