Contiamo Data Hub enables JDBC access to schemas. Schema tables are exposed as normal database tables. Logical definitions (dimensions and measures) are not exposed.
JDBC driver can be downloaded from the Contiamo website or retrieved from Maven Central repository.
JDBC URL format is the following:
host (required) is a DNS name or IP address of host
port (required) is the port
path (optional) is the path of endpoint
Options can either be specified within the JDBC URL or as a connection properties. The following options are supported:
Catalog ID to access schema in
The name of the schema to access
In addition to connection properties an authentication token can be provided as JDBC user/password:
user property contains "$token" string
password property contains authentication token
JDBC URL to connect to downloadable Contiamo DataHub: