---
title: Tableau Integration
slug: 0A9X-0kaZPPxc47fXqjfa
description: Connect Ocient with Tableau to unlock advanced data visualization and reporting, driving actionable insights from massive datasets.
docTags: 
createdAt: Fri Jun 02 2023 18:13:15 GMT+0000 (Coordinated Universal Time)
updatedAt: Mon Mar 30 2026 18:52:29 GMT+0000 (Coordinated Universal Time)
---

Tableau® is an interactive data visualization application designed to create charts and dashboards from various data sources.&#x20;

## Prerequisites

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

- Ocient System — Use the latest version.
- JDBC driver — Download the latest version with dependencies from the Apache® Maven™ [repository](https://mvnrepository.com/artifact/com.ocient/ocient-jdbc4).&#x20;

## Installation&#x20;

1. Download the latest version of Tableau Desktop for your respective operating system from the [Download Tableau Desktop](https://www.tableau.com/products/desktop/download) website.&#x20;
2. Register and sign in to Tableau Desktop. Then, follow steps to complete the installation.

## Add Necessary Packages

To connect to Ocient, you must add these files to your Tableau installation:&#x20;

- Ocient JDBC driver (`.jar`) — Use the latest version with dependencies from the [Maven repository](https://mvnrepository.com/artifact/com.ocient/ocient-jdbc4).&#x20;
- Ocient Tableau connector file (`.taco`) — Download the latest version from [Tableau Exchange](https://exchange.tableau.com/products/178).&#x20;

:::hint{type="info"}
The `.taco` connector file supports Tableau Desktop and Tableau Server. Contact Tableau for support regarding Tableau Cloud.
:::

### **Add the Ocient JDBC Driver JAR File**

Move the downloaded JDBC driver JAR file to the corresponding folder based on your operating system:&#x20;

- Windows® — `C:\Users[Windows User]\Documents\My Tableau Repository\Connectors`
- macOS® — `/Users/[user]/Documents/My Tableau Repository/Connectors`

### **Add the Tableau Connector File (**`.taco`**)**

Move the downloaded `.taco` connector file to the corresponding folder based on your operating system:&#x20;

- Windows — `C:\Program Files\Tableau\Drivers`
- macOS — `/Users/[user]/Library/Tableau/Drivers`

## Connect to Ocient&#x20;

Connect to your database by following these steps: &#x20;

- Open Tableau and find the **Connect to a Server** menu. Select **Ocient JDBC** from the list of installed connectors. If **Ocient JDBC** does not appear as an option in Tableau, ensure that the Ocient Tableau connector file (`.taco`) is located in the correct folder.&#x20;

::Image[]{src="https://api.archbee.com/api/optimize/zLEvgH2ISPR6In81OlyIL/5L5e6YgOcm-4j4P9G7lQi_screenshot-2023-06-02-at-120516-pm.png" size="70" width="1984" height="1452" position="center" alt="Ocient connector on the Tableau Desktop home page" darkWidth="1984" darkHeight="1452"}

- In the connection window, enter your database parameters with this information.

| **Field** | **Description**                                                                                     |
| --------- | --------------------------------------------------------------------------------------------------- |
| Host      | The hostname or IP address of the SQL Node of your Ocient System. For example: `databasehost-sql0`  |
| Port      | The port number for your connection. The default Ocient port is `4050`.                             |
| Database  | The name of the database for connection. For example: `my_db`                                       |
| User      | The username associated with your database.                                                         |
| Password  | The password associated with your username.                                                         |

- Select **Sign In** after you enter all the information.&#x20;

## Related Links

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

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