Connecting to SQream Using Tableau
SQream’s Tableau connector, based on standard JDBC, enables storing and fast querying large volumes of data. This connector is useful for users who want 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.
For more information on SQream’s integration with Tableau, see Tableau Connectors.
It is essential that you have the following installed:
Tableau version 9.2 or newer
Download the SQream JDBC Connector .jar file.
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:
Tableau Desktop on Windows:
Tableau on Linux:
Download the Tableau Connector
Based on the installation method that you used for installing Tableau, place the Tableau Connector
SQreamDB.tacofile in the Tableau connector directory:
Product / Platform
Tableau Desktop for Windows
Tableau Desktop for Mac
Tableau Prep for Windows
Tableau Prep for Mac
Flow web authoring on Tableau Server
Tableau Prep Conductor on Tableau Server
Restart Tableau Desktop or Tableau server.
Start Tableau Desktop.
In the Connect menu, under the To a Server option , click More.
Additional connection options are displayed.
Select SQream DB by SQream Technologies.
The connection dialog box is displayed.
In the connection dialog box, fill in the following fields:
Defines the SQreamDB worker machine IP.
Avoid using the loopback address (127.0.0.1) or “localhost” as a server address since it typically refers to the local machine where Tableau is installed and may create issues and limitations
Defines the TCP port of the SQream worker
3108when using a load balancer, or
5100when connecting directly to a worker with SSL
Defines the database to establish a connection with
true) or disables (
false) the load balancer. After enabling or disabling the load balance, verify the connection
Specifies the username of a role to use when connecting
Specifies the password of the selected role
Sets SSL as a requirement for establishing this connection
Click Sign In.
The connection is established, and the data source page is displayed.