Prerequisites
To use Tableau with the Ocient System, you must have these software prerequisites:- Ocient System — Use the latest version.
- JDBC driver — Download the latest version with dependencies from the Maven repository.
Installation
- Download the latest version of Tableau Desktop for your respective operating system from the Download Tableau Desktop website.
- 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:- Ocient JDBC driver (
.jar) — Use the latest version with dependencies from the Maven repository. - Ocient Tableau connector file (
.taco) — Download the latest version from Tableau Exchange.
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:- 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:
- Windows —
C:\Program Files\Tableau\Drivers - macOS —
/Users/[user]/Library/Tableau/Drivers
Connect to Ocient
Connect to your database by following these steps:- 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.
- 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.