Signals Inventa: How to create external database connections

Created
February 16, 2023 16:45

It's possible to source data into Inventa from external databases. This is done from the Administration menu, External Connections.

- Click on Add External Connection

Fill out the fields as follows:

Connection Name	A generic name for the connection
Connection Type	Only sql is supported
Connection String	A JDBC connection string (See examples below)
Username / Password	Credentials for the connection

JDBC connection strings

JDBC connection strings can be found on the driver provider's documentation, however below are a few examples of frequently used JDBC connection string formats

Microsoft SQL Server

jdbc:sqlserver://<server_hostname>:<port>;DatabaseName=<database name>

Oracle

jdbc:oracle:thin:@//<server_hostname>:<port>;<instance>

Postgres

jdbc:postgressql://<server_hostname>:<port>/<database name>

MySQL

jdbc:mysql://<server_hostname>:<port>/<database name>

Related articles