Connect to Cirro with Tableau using these steps.

Before You Start

Before you set up any SQL client, you’ll need:

Download and install Cirro ODBC driver

First, download the Cirro ODBC driver for your system.

  • Open Cirro in a web browser.
  • Click Download Drivers, found at the bottom of the page.
  • Click the relevant 32 or 64 bit driver for your system.
  • Choose a download folder then click OK.
  • Run the downloaded installer then close when finished.

Next, we add the driver to the ODBC Data Source Administrator page.

  • Open Windows Settings and search on "ODBC"
  • Now choose the 32 or 64 bit driver version.
  • Click User DSN then Add.
  • Choose the Cirro Driver.
  • Click Finish.

When the driver is added, the system automatically displays the Cirro ODBC data source config tool.

There's two ways to setup the driver:

  1. Default - the driver defaults to "CIRRO" as the remote system. This gives access to all databases your user account has been granted.
  2. Passthrough - set up the driver with a database name and your Cirro account name and password. Click Resources then Datasources to find the database name.

You'll need to substitute your connection details for the example values below.

Field Description Example Values
Datasource Name Arbitrary title for the data source Cirro_ODBC
Cirro server hostname or ip address Hostname or IP address of the Cirro instance organization.cirro.com
Cirro server port The port the driver can access the server (defaults to 1521) 1521
Remote System Enter "CIRRO" to connect to Cirro Hub (and all the databases in the system), or use database name for passthrough connection. CIRRO
User name Cirro user name cirrouser
Password/Confirm Password Cirro user password cirropassword
Connection String Extra Properties Specific connection details. In this example, set tableNameQuery=true to use two-part object names in SQL queries (e.g., "database.schema.table" becomes "database-schema-table"). tableNameQuery=true
Extra JVM args Additional Java Virtual Machine arguments none
Log level 0-7 leave blank for default none

Download Application

Connect to Data Source

It’s a four step process to set up a Cirro database in Tableau.

  • First step, start Tableau, then under Connect, find To a server then Other Databases (ODBC).

  • Second step:

    • choose the Cirro ODBC driver (either Cirro which is 32bit or Cirro64),

    • now click Connect.

  • In the third step, you’ll fill in the ODBC connection details, including your Cirro URL or IP address, the database and your Cirro account name and password. Click Connect when you’re ready.

Field Description Example values
Cirro server hostname or IP address Your Cirro server URL or IP address. organization.cirro.com
Port Default port is 1527. This may differ on your Cirro server 1527
Remote System Find the database in your Cirro server, under Resources then Datasources. The first column is the database name. Oracle1
User name & Password Cirro username and password combination, with password confirmation. Cirrouser/mypassword

If the connection is successful, Tableau will populate the Connection attributes fields.

  • In the fourth step,

    • remove { } brackets from the Server and Port field if Tableau has inserted them,

    • click Sign In.

Troubleshooting

If you’re having difficulty connecting, try our Troubleshooting guide.

Additionally, Tableau may experience any of the following errors:

Issue Cause Solution
Incorrect Cirro ODBC driver You may have 64bit Tableau but a 32 bit driver installed Reinstall ODBC Driver.
Restart Tableau and go through the setup process. Make sure you choose “Cirro64” for 64bit Tableau.
Incorrect ODBC Remote System The default remote system is CIRRO. Alter this to a specific database name. Login to Cirro web, then click Resources and Datasources. The Database name is the first column. Copy this and enter into the ODBC Remote System field.
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified Tableau puts { } brackets around server and port values once the ODBC driver is set up. Remove the curly brackets then click Sign In.
Invalid Username / Password Tableau may populate an incorrect password in the Connection Details dialog. Enter the password again then click Sign In.