Tableau

SQream Blue’s Tableau connector, based on JDBC, enables storing and fast querying large volumes of data. This connector is useful for users who wish to integrate and analyze data from various sources within the Tableau platform. With the Tableau connector, users can easily connect to databases and cloud applications and perform high-speed queries on large datasets. Additionally, the connector allows for seamless integration with Tableau, enabling users to visualize their data.

SQream supports both Tableau Desktop and Tableau Server on Windows, MacOS, and Linux distributions.

Prerequisites

It is essential that you have the following installed:

  • Tableau version 9.2 or newer

Setting Up JDBC

  1. Download the SQream Blue JDBC Connector JDBC.

  2. Place the JDBC .jar file in the Tableau driver directory.

    Based on your operating system, you may find the Tableau driver directory in one of the following locations:

    • Tableau Desktop on MacOS: ~/Library/Tableau/Drivers

    • Tableau Desktop on Windows: C:\Program Files\Tableau\Drivers

    • Tableau on Linux: /opt/tableau/tableau_driver/jdbc

Installing the Tableau Connector

  1. Download the Tableau Connector sqream_blue_jdbc-v1.2.taco file.

  2. Based on the installation method that you used for installing Tableau, place the Tableau Connector sqream_blue_jdbc-v1.2.taco file in the Tableau connector directory:

Product / Platform

Path

Tableau Desktop for Windows

C:\Users[user]\Documents\My Tableau Repository\Connectors

Tableau Desktop for Mac

/Users/[user]/Documents/My Tableau Repository/Connectors

Tableau Prep for Windows

C:\Users[user]\Documents\My Tableau Prep Repository\Connectors

Tableau Prep for Mac

/Users/[user]/Documents/My Tableau Prep Repository/Connectors

Flow web authoring on Tableau Server

/data/tabsvc/flowqueryservice/Connectors

Tableau Prep Conductor on Tableau Server

/data/tabsvc/flowprocessor/Connectors

Tableau Server

C:\<directory_name>\Tableau\Tableau Server\<directory_name>\Connectors

  1. Restart Tableau Desktop or Tableau server.

Connecting to SQream Blue

  1. Start Tableau Desktop.

  2. In the Connect menu, under the To a Server option , click More.

    Additional connection options are displayed.

  3. Select SQream Blue by SQream Technologies.

    A connection dialog box is displayed.

  4. In the connection dialog box, fill in the following fields:

Element Name

Description

Server

Provide the network address to your database server. Use the SQream Blue cluster URL

Port

Provide the port that the database is responding to at the network address.

Database

Provide the name of your database or the schema on your database server.

Access Token

Provide an access token to SQream Blue.

  1. Click Sign In.

    The connection is established, and the data source page is displayed.