:orphan:

.. _tableau:

*******
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
----------------

#. Download the SQream Blue JDBC Connector :ref:`JDBC<java_jdbc>`.
#. 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
--------------------------------

#. Download the `Tableau Connector <https://sq-ftp-public.s3.amazonaws.com/sqream_blue_jdbc-v1.2.taco>`_  ``sqream_blue_jdbc-v1.2.taco`` file. 
   
#. 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:

.. list-table::
   :widths: auto
   :header-rows: 1
   
   * - 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``

3. Restart Tableau Desktop or Tableau server.

Connecting to SQream Blue
-------------------------


#. Start Tableau Desktop.
	
#. In the **Connect** menu, under the **To a Server** option , click **More**.

   Additional connection options are displayed.
	
#. Select **SQream Blue by SQream Technologies**.

   A connection dialog box is displayed.
	
#. In the connection dialog box, fill in the following fields:

.. list-table:: 
      :widths: 6 31
      :header-rows: 1
   
      * - 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 :ref:`access token<access_tokens>` to SQream Blue.


5. Click **Sign In**.

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