Tabli - Add a Connection

Undraw Windows

About

The connection add operations 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

Adding a Sqlite database with the name sqliteDbName:

tabli connection add "sqliteDbName" "jdbc:sqlite://%TMP%/db.db"
The connection (sqliteDbName) was saved into the connection vault (C:\Users\gerardnico\.tabli\dns.ini)

Syntax

tabli connection add --help
Tabli connection add
====================

Add a connection



Example
-------

 1 - To add the connection `name` with the URL `url`:


    tabli connection add name url




Syntax
------


    tabli connection add [options|flags] <name> <url>


where:


  Arguments:

    <name>                                                  the connection name

    <url>                                                   The system connection string (a JDBC Url for a database or a file system URL)


  Data Definition Options:

    -a,--attribute <key=value>                              A attribute (known also as connection properties)


  Options:

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

    -p,--password <password>                                The user password (A passphrase is then mandatory because password should be encrypted)

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


  Global Options:

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

    -cv,--connection-vault <path>                           The path where the connection vault is located

    -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 values

Task Runner