SingleStoreDB JDBC

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 optimisation 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 visualisation 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

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.