Tableau

This section explains how to connect Tableau to an Exasol database.

Exasol is easily integrated with Tableau and provides Tableau customers the power to visualize and analyze very large live data. Tableau has a native connector to Exasol which makes it easy for you to establish a connection.

For more information on creating content on Tableau, refer to the training videos on Tableau.

Exasol takes no responsibility for any changes in functionality or terms of use for the third-party software described in this section. For more information, refer to the respective software vendor’s website.

Prerequisites

  • A running Exasol database
  • Exasol ODBC driver must be installed. You can download drivers from the Exasol Downloads portal. For more information, see Drivers.
  • Tableau installed
  • Both the Exasol database and the host with Tableau must be able to communicate with each other through a network.

Quick Start

This quick start video shows how to connect an Exasol database to Tableau.

Connect Tableau to Exasol

  1. Start Tableau, in the left side menu on the Tableau Desktop, under To a Server select More.

  2. From the list select Exasol.

  3. In the dialog box, enter the connection information : 
    • Server: Enter the Connection string .
    • Port: The default port is 8563.
    • Username: Enter the user name.
    • Password: Enter the password.

      • Note: If this is a new Exasol instance, then the default user name is Sys and default password is exasol.

    • Click Sign In.

  4. On the Data Source screen, select your Schema from the drop-down list.
  5. Under Table, drag and drop the desired table to the right side of the screen. Once you have all the required tables, you can create worksheets and dashboards.

    6. Note: We recommend you to keep a live connection to the database and avoid creating any extracts.

  6. To create a new worksheet and start your analysis, click Sheet 2.