How to Build Tableau reports on Oracle Data using the DataDirect Oracle Driver for ODBC

Updated: 28 Oct 2022


Progress DataDirect’s Oracle ODBC Driver offers a high-performing, secure and reliable connectivity solution, for ODBC applications to access Oracle data. If you want to use our ODBC Oracle Driver with the Tableau Desktop application, Progress DataDirect has you covered. In this tutorial, you will learn how to configure the DataDirect Oracle driver within Tableau Desktop to create reports. These steps can also be used to configure any ODBC connection with Tableau.


This tutorial assumes that you have ODBC drivers installed and a data source configured. If you have not yet done these steps, please follow these instructions:

  1. Download and install the Progress DataDirect ODBC driver using the 15-day trial software. In this tutorial, we are connecting to Oracle Database.
  2. Configure a data source for your database. See the DataDirect documentation for assistance with setting up your data source. You will learn how to configure an Oracle Data source in the following steps.

Configure Connection to Oracle ODBC Driver Using the ODBC Administrator

  1. After the DataDirect Oracle ODBC driver has been installed, open ODBC Administrator to configure the connection and click on Add.
    odbc data source administratior window dbase files selected from the list of user data sources
  2. Choose the “DataDirect X.X Oracle Wire Protocol” and click on “Finish.”
    create new data source window; datadirect 8.0 oracle wire protocol highlighted in the list of drivers
  3. The ODBC Oracle Wire Protocol Driver Setup window will pop up.
    odbc oracle wire protocol driver setup window; empty description field focused, host set to hostname, port number set to 1521, SID set to ASC and edition name field empty

    Enter your credentials, click on “Apply” and then click on “Test Connect.”

  4. The Oracle Logon screen will pop up. Provide logon credentials and click on “OK.”
    logon to oracle wire protocol window; hostname set to hostname, port number set to 1521, sid set to asc, user name set to username, password field filled and ok button focused
  5. A dialog box will confirm that the connection is established.
    test connect dialog saying connection established

Connect to an ODBC Data Source

  1. Start Tableau and connect to the server. Select the “Other Databases (ODBC)” option.
    connect view; other databases (odbc) option highlighted in the to a server category
  2. In the pop-up window, select the “Driver” radial button and choose the data source previously configured to connect to Oracle in the dropdown.
    other databases odbc window; datadirect 8.0 oracle wire protocol selected from the driver dropdown
  3. Click on “Connect” and another Logon Dialog popup screen will appear.
    other databases odbc window; datadirect 8.0 oracle wire protocol selected from the driver dropdown and connect button highlighted
  4. Enter your credentials and click on “OK.”
    logon to oracle wire protocol dialog; host set to hostname, port number set to 1521, sid set to asc, username set to username, a filled password field and ok button highlighted
  5. Enter any additional parameters required to connect to your Oracle Data source, such as a username and password, and select “OK.” The original connection screen will now display the connection attributes
    other databases odbc window with a highlighted sign in button
  6. Select “Sign In” and the Tableau configuration screen should now appear.
    tableau configuration screen
  7. In the database dropdown menu choose the data source.
    select database dropdown with a sample database name
  8. You can use Tableau's schema and table drop-down list to browse and select your data. Or you can execute SQL statements by clicking on the "New Custom SQL" option.
    new custom sql button highlighted
  9. A popup dialogue box will appear to edit custom SQL.
    edit custom sql view

    For example, you can execute a statement such as "Select * from schema_name.table_name" and then click on the "Sheet 1" option at the bottom of the Tableau screen. This screen will allow you to select data and create tables or charts, such as the sample below:

    sample bar chart


Get started today with a free 15-day trial of Progress DataDirect Oracle ODBC drivers, and connect Tableau to all your data! Contact Us for assistance with any questions you may have, and we will be happy to help!

Connect any application to any data source anywhere

Explore all DataDirect Connectors

Need additional help with your product?

Get Customer Support