---
title: Metabase Integration
slug: 3gTWZ2IaizpXjh93SN0hQ
description: Set up and integrate Ocient with Metabase to create visual data insights and dashboards, optimizing your data analysis workflow.
docTags: 
createdAt: Mon Feb 13 2023 17:36:27 GMT+0000 (Coordinated Universal Time)
updatedAt: Mon Mar 30 2026 18:52:29 GMT+0000 (Coordinated Universal Time)
---

Metabase℠ is an open-source business intelligence tool designed to create charts and dashboards from various data sources.&#x20;

## Prerequisites&#x20;

To use Metabase with your Ocient® System, you must have these software prerequisites:&#x20;

- Ocient System — Use version 22.0 or later.
- JDBC driver — Use the latest version.

## Install Metabase

1. Go to the [Installing Metabase](https://www.metabase.com/docs/latest/installation-and-operation/installing-metabase) and follow the directions for installation, including all prerequisites. &#x20;
2. Download the latest [ocient-metabase-driver.jar](https://github.com/Xeograph/metabase-ocient-driver/releases) file and copy it to your Metabase plugins folder. This JAR file enables your Metabase installation to connect to Ocient.&#x20;

## 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&#x20;**&#x69;n the menu.

This connection page appears. The displayed connection fields change after you select **Ocient** as the database type.

::Image[]{alt="Add Database" src="https://api.archbee.com/api/optimize/zLEvgH2ISPR6In81OlyIL/FoArNomAibgAYVDGf50zR_screenshot-2023-02-21-at-21437-pm.png" size="50" width="1438" height="2094" position="center" darkWidth="1438" darkHeight="2094"}

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.                                                                       |

:::hint{type="info"}
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](<./././SQL Reference/Data Definition Language _DDL_ Statement Reference/Databases.md>).
:::

When you successfully connect, you see your database added to Metabase. Your database appears as one of the active connections in Metabase.&#x20;

![List of Metabase Databases](https://api.archbee.com/api/optimize/zLEvgH2ISPR6In81OlyIL/vYf4Di0XhKpqV7vyhsKoV_screenshot-2023-02-22-at-91617-am.png "Your Ocient database appears as one of the active connections in Metabase.")

Your database appears as one of the active connections in Metabase.

## Advanced Connection Options

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**.&#x20;

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.

::Image[]{alt="Additional JDBC connection string options sets the maxRows and timeoutMillis parameters." src="https://api.archbee.com/api/optimize/zLEvgH2ISPR6In81OlyIL/tU0sU7TV3SymOkQZaY_T-_screenshot-2023-02-22-at-12251-pm.png" size="72" width="1336" height="268" position="center" darkWidth="1336" darkHeight="268"}

For a list of supported JDBC options, see the [JDBC Manual](<./././Connection Driver Reference/JDBC Manual.md>).&#x20;

## Related Links

[Connect to Ocient](<./././Connect to Ocient.md>)

[Ocient Integrations](<././Ocient Integrations.md>)
