====== Tabli - Add a Connection ======

===== About =====
The ''connection add'' operations will add a connection to the [[docs:conf:vault|connection vault]].

<note tip>If the connection already exists, this operations will return an error whereas the [[upsert|upsert operation]] will not.</note>

===== Example =====
Adding a [[docs:system:sqlite:sqlite|Sqlite database]] with the name ''sqliteDbName'':
<unit display="none">
<code dos>
tabli connection delete --not-strict "sqliteDbName"
</code>
</unit>

<unit>
<code dos>
tabli connection add "sqliteDbName" "jdbc:sqlite://%TMP%/db.db"
</code>
<console>
The connection (sqliteDbName) was saved into the connection vault (C:\Users\gerardnico\.tabli\dns.ini)
</console>
</unit>
===== Syntax =====
<unit>
<code dos>
tabli connection add --help
</code>
<console>
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
</console>
</unit>