> ## Documentation Index
> Fetch the complete documentation index at: https://docs.ocient.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Metabase Integration

export const Ocient = "Ocient®";

export const Metabase = "Metabase℠";

{Metabase} is an open-source business intelligence tool designed to create charts and dashboards from various data sources.

## Prerequisites

To use Metabase with your {Ocient} System, you must have these software prerequisites:

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

## Connect to Ocient

To add a database connection, select the <Icon icon="gear" iconType="solid" size={16} /> 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.

<Frame>
  <img src="https://mintcdn.com/ocient/z72iqRqJo7Ob2_zv/images/foarnomaibgayvdgf50zr-screenshot-2023-02-21-at-21437-pm-5b8c901b.png?fit=max&auto=format&n=z72iqRqJo7Ob2_zv&q=85&s=423be7dcb90d9e84a3318cf6918b4f24" alt="Add Database" width="1438" height="2094" data-path="images/foarnomaibgayvdgf50zr-screenshot-2023-02-21-at-21437-pm-5b8c901b.png" />
</Frame>

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

<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](/databases#alter-database-set-sso-integration).
</Info>

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

<Frame>
  <img src="https://mintcdn.com/ocient/z72iqRqJo7Ob2_zv/images/vyf4di0xhkpqv7vyhskov-screenshot-2023-02-22-at-91617-am-2428bc68.png?fit=max&auto=format&n=z72iqRqJo7Ob2_zv&q=85&s=43663c5f115626e1946d36d1840cd7a8" alt="List of Metabase Databases" width="2292" height="720" data-path="images/vyf4di0xhkpqv7vyhskov-screenshot-2023-02-22-at-91617-am-2428bc68.png" />
</Frame>

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

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.

<Frame>
  <img src="https://mintcdn.com/ocient/z72iqRqJo7Ob2_zv/images/tu0su7tv3symokqzay-t-screenshot-2023-02-22-at-12251-pm-4ad7c486.png?fit=max&auto=format&n=z72iqRqJo7Ob2_zv&q=85&s=6c0a3e1e118133fb9069ba3b3957e1dd" alt="Additional JDBC connection string options sets the maxRows and timeoutMillis parameters." width="1336" height="268" data-path="images/tu0su7tv3symokqzay-t-screenshot-2023-02-22-at-12251-pm-4ad7c486.png" />
</Frame>

For a list of supported JDBC options, see the [JDBC Manual](/jdbc-manual).

## Related Links

[Connect to Ocient](/connect-to-ocient)

[Ocient Integrations](/ocient-integrations)