SingleStoreDB JDBC | Tableau Exchange

SingleStoreDB JDBC

by Singlestore

Description

SingleStoreDB unifies transactions and analytics in a single engine to drive low-latency access to large datasets, simplifying the development of fast, modern enterprise applications. SingleStore's advanced indexing and query optimization capabilities allow businesses to quickly and efficiently access their data, making it possible to perform real-time analytics

Together, Tableau and SingleStoreDB provide a powerful solution for businesses looking to gain insights from their data in real-time. SingleStore's high-performance relational database makes it possible to perform real-time analytics, while Tableau's data visualization capabilities make it easy to understand and act on the insights generated by the data. The two products are easily integrated, allowing businesses to quickly start using the solution, and improve their performance and decision-making capabilities


Installation

Install Connector

  1. Click the "Download" button at the top of the page to download the connector file.
  2. Move the connector file (.taco) to the Tableau Connectors directory, which by default can be found at the following paths:
Product/Platform Path
Tableau Desktop (Windows) C:\Users[user]\Documents\My Tableau Repository\Connectors
Tableau Prep (Windows) C:\Users[user]\Documents\My Tableau Prep Repository\Connectors
Tableau Desktop (Mac) /Users/[user]/Documents/My Tableau Repository/Connectors
Tableau Prep (Mac) /Users/[user]/Documents/My Tableau Prep Repository/Connectors
Tableau Server C:\ProgramData\Tableau\Tableau Server\data\tabsvc\vizqlserver\Connectors

Install Driver 3. Download the SingleStore JDBC Driver here: https://github.com/memsql/S2-JDBC-Connector/releases/latest. The file is named singlestore-jdbc-client-<version>.jar 4. Move the driver (.jar) to the Tableau Drivers directory, which by default can be found at the following paths:

Platform Path
Windows C:\Program Files\Tableau\Drivers
MacOS ~/Library/Tableau/Drivers or ~/Library/JDBC
Linux /opt/tableau/tableau_driver/jdbc

Relaunch Tableau (for desktop products) or restart the server (for Tableau Server). SingleStore JDBC will now appear in the list of connectors in Tableau under Connect.

Tech Specifications

Version
1.0.0
Works with
Tableau 2022.1 and later

Resources