Tabul - Add a Connection

Undraw Windows

About

The connection add operation will add a connection to the connection vault.

If the connection already exists, this operations will return an error whereas the upsert operation will not.

Example

Syntax

tabul connection add --help
Tabul connection add
====================

Add a connection



Example
-------

 1 - To add the connection `name` with the URI `uri`:


    tabul connection add name uri




Syntax
------


    tabul connection add [options|flags] <name> <uri>


where:


  Arguments:

    <name>                                                  the connection name

    <uri>                                                   The system connection string (a JDBC Uri for a database or a file system URI).


  Data Definition Options:

    -a,--attribute <key=value>                              A tabulify connection attribute


  Connection Properties:

    -a,--attribute <key=value>                              A tabulify connection attribute

    -d,--driver <tld.package.driverClass>                   The jdbc driver (JDBC URL only)

    --native-attribute <key=value>                          A native connection attribute (Example: JDBC driver property

    -p,--password <password>                                The user password (Clear password is encrypted only if a passphrase is provided)

    -u,--user <user>                                        The user name (ie the login name)


  Global Options:

    -ah,--app-home <path>                                   The app home directory (default to the .tabul.yml file directory)

    -vf,--conf <path>                                       The path to a configuration file

    -ee,--exec-env <name>                                   The execution environment (prod or dev)

    -h,--help                                               Print this help

    -l,--log-level <error|warning|tip|info|fine>            Set the log level

    -ns,--not-strict                                        A minor error will not stop the process.

    -odu,--output-data-uri <outputDataUri>                  defines the output data uri for the feedback data (default: console)

    -oo,--output-operation <dataOperation>                  defines the data operations (replace, truncate) on an existing output resource before transfer.

    -oop,--output-transfer-operation <transferOperation>    defines the output transfer operation (insert, update, merge, copy). Default to `copy` for a file system and `insert` for a database.

    -pp,--passphrase <passphrase>                           A passphrase (master password) to decrypt the encrypted vault values (Env: TABUL_PASSPHRASE)

    --pipe-mode                                             Use pipe mode if you want to pipe the output in a shell. Pipe mode will not print the headers (ie column name) and will not make the control character visible

    -v,--version                                            Print version information




Related HowTo
Undraw Windows
How to create a SMTP connection?

This howto shows you how to create a smtp connection to a SMTP system An oracle connection supports : all common connection attributes Uri, user, password ... and all Smtp connection...
Undraw Windows
How to create a SQLite connection?

This howto shows you how to add a Sqlite connection. An sqlite connection supports : all common connection attributes Uri, user, password ... and all relational connection attributes ...
Undraw Windows
How to create an Microsoft SqlServer connection?

This howto shows you how to create a connection to an sqlserver database. An sqlserver connection supports : all common connection attributes Uri, user, password ... and all relational...
Undraw Windows
How to create an MySQL connection?

This howto shows you how to create a connection to an mysql database. An mysql connection supports : all common connection attributes Uri, user, password ... and all database connection...
Undraw Windows
How to create an Oracle connection?

This howto shows you how to create a connection to an oracle database. An oracle connection supports : all common connection attributes Uri, user, password ... and all relational connection...

Task Runner