JDBC Connection

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:

jdbc:pantheon:host:port[/path]?option=value;option=value;...
  • 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:

Name

Required

Description

catalogId

yes

Catalog ID to access schema in

schemaName

yes

The name of the schema to access

token

yes

Authentication token

secure

no

true or false. Whether to use secure (https) connection or non-secure one (http). Default is true.

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

Example

JDBC URL to connect to downloadable Contiamo DataHub:

jdbc:pantheon://localhost:4300/pantheon/jdbc/?catalogId=989a9567-5de1-4eee-ac9f-fad7019829a8;schemaName=Foodmart;secure=false;token=aaaaaaaaaaaaaaaaaaaaaaaaaaaaaa