---json
{
    "page_id": "f6jo3u600585tlz50kqf8"
}
---
====== Connection - URI attribute ======


===== URL =====
''URI'' is a mandatory [[attribute|attribute]] of a [[connection|connection]] and is also known as the ''connection string''

It's a string that defines the most important connection properties such as:
  * the ''scheme'': the technology used to connect
  * the ''host'': the host where the system is located
  * the ''port'': the port where the system is reachable on the host
  * the ''database'': the database name

The ''URI'' is system dependent and therefore should be looked in the [[docs:system:system|documentation page of each system]].

This is the property that defines the connection to a [[docs:system:system|system]]

<note tip>
The ''URI'' is also known as:
  * [[wp>Data_source_name|Data Source Name (DSN)]]
  * or ''connection string''
</note>
===== Example =====

Example of URI with the [[docs:tabul:connection:list|tabul connection list]] command where you can see the [[howtos|howtos]] connection.

<unit display="none">
Init env
<code bash>
tabul data drop --no-strict-selection .tabul/.tabul.yml@home
</code>
</unit>
<unit>
<code bash>
tabul connection list
</code>
<console>
name            uri
-------------   ------------------------------------------------------------------------
cd              file:///home/tabulify/
data-home       file:///home/admin/.local/share/tabul/
desktop         file:///home/tabulify/Desktop
entity          file:///opt/tabulify/resources/entity/
home            file:///home/tabulify/
howto           file:///opt/tabulify/resources/howto/
log             file:///home/tabulify/.tabul/logs
memory          mem:/
mysql           jdbc:mysql://localhost:3306/howto
noop            noop
oracle          jdbc:oracle:thin:@localhost:1521/freepdb1
postgres        jdbc:postgresql://localhost:5432/postgres
smtp            smtp://localhost:1025
sqlite          jdbc:sqlite:////home/tabulify/.tabul/sqlite.sqlite3
sqlite_target   jdbc:sqlite:////home/tabulify/.tabul/sqlite_target.sqlite3
sqlserver       jdbc:sqlserver://localhost:1433;encrypt=true;trustServerCertificate=true
tmp             file:///mnt/wslg/runtime-dir/tabul
tpcds           tpcds
tpcds_query     file:///opt/tabulify/resources/tpcds_query/
</console>
</unit>