is an open-source business intelligence tool designed to create charts and dashboards from various data sources.
To use Metabase with your system, you must have these software prerequisites:
- Ocient database — Use version 22.0 or later.
- JDBC driver — Use latest version.
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.
The type of database. Select "Ocient".
The display name for your database in Metabase.
The host name or IP address of the SQL node of your Ocient database. For example: databasehost-sql0
The port number for your connection. Unless you have to alter this, the default Ocient port is 4050.
The name of the database for connection. For example: my_db
The identifiers for any schemas you want to use or exclude. To use all available schemas, select All.
Choose between Single Sign-On (Token) for single sign-on (SSO) or Password for password authentication.
The username associated with your database.
The password associated with your username.
Type of SSO token
Specify your SSO access token string.
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.