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 Serverjdbc:sqlserver://<server_hostname>:<port>;DatabaseName=<database name>
Oraclejdbc:oracle:thin:@//<server_hostname>:<port>;<instance>
Postgresjdbc:postgressql://<server_hostname>:<port>/<database name>
MySQLjdbc:mysql://<server_hostname>:<port>/<database name>
Comments
0 comments
Article is closed for comments.