Metabase Integration
Metabase℠ is an open-source business intelligence tool designed to create charts and dashboards from various data sources. Metabase℠
To use Metabase with your Ocient® system, you must have these software prerequisites:
- Ocient database — Use version 22.0 or later.
- JDBC driver — Use latest version.
- Go to the Installing Metabase and follow the directions for installation, including all prerequisites.
- Download the latest ocient-metabase-driver.jar file and copy it to your Metabase plugins folder. This JAR file enables your Metabase installation to connect to Ocient.
To add a database connection, select the icon at the top right of the Metabase homepage. Select Admin settings > Databases > Add database in the menu.
This connection page appears. The displayed connection fields change after you select "Ocient" as the database type.
Enter these fields in your connection settings.
Field | Description |
---|---|
Database type | The type of database. Select "Ocient". |
Display name | The display name for your database in Metabase. |
Host | The host name or IP address of the SQL Node of your database. For example: databasehost-sql0 |
Port | The port number for your connection. Unless you have to alter this, the default Ocient port is 4050. |
Database name | The name of the database for connection. For example: my_db |
Schemas | The identifiers for any schemas you want to use or exclude. To use all available schemas, select All. |
Authentication method | Choose between Single Sign-On (Token) for single sign-on (SSO) or Password for password authentication. |
User | The username associated with your database. |
Password | The password associated with your username. |
Type of SSO token | Use access_token. |
SSO token | Specify your SSO access token string. |
To use SSO authentication, you must have SSO integration enabled for the specified database and group. For more information, see ALTER DATABASE SET SSO INTEGRATION.
When you successfully connect, you see your Ocient database added to Metabase. Your Ocient database appears as one of the active connections in Metabase.
You can add more connection settings as part of the JDBC connection string in Metabase. To add these, go to the Add database page and select Show advanced options.
You can specify options in the field Additional JDBC connection string options. In this image, the specified options include a maximum of 10,000,000 rows and a timeout of 0 milliseconds, using the maxRows and timeoutMillis parameters respectively.
For a list of supported JDBC options, see the JDBC Manual.