SingleStore Integration Guides and Tutorials

Jerod Johnson
Director, Technology Evangelism

A list of guides and tutorials for connecting to and working with live SingleStore data.

CData Software's connectivity tools enable users to connect directly to live SingleStore data data from widely-used BI, analytics, ETL, and custom applications, ensuring that our customers can access their data wherever they desire. Below, you'll find a collection of guides and tutorials on integrating with live SingleStore data.

Integration Use-Cases

Click below to jump to articles related to specific integration use-case.

Artificial Intelligence - agents, chatbots, and workflows (Claude, ChatGPT, n8n, crewAI, etc.)
Business Intelligence & Analytics - charting, reports, and more (Tableau, Power BI, Amazon QuickSight, etc.)
ETL & Replication - moving and replicating data (CData Sync, AWS Glue, Oracle Data Integrator, etc.)
Data Virtualization - retrieving and manipulating data (DbVisualizer, SQL Server PolyBase, etc.)
Software Development - developing custom applications (.NET, AngularJS, Ruby, Python, etc.)
Data Management - managing data (DBArtisan, RazorSQL, SQuirreL, etc.)
Workflow Automation - building automated workflows (SSIS, Power Automate, etc.)

Artificial Intelligence

Product	Technology	Article Title
Agentforce	Connect AI	Connecting Agentforce with SingleStore Data
Azure AI Foundry	Connect AI	Use Azure AI Foundry to Talk to Your SingleStore Data
Boomi AgentStudio	Connect AI	Integrating Boomi AgentStudio with SingleStore Data
ChatGPT	Connect AI	Connect SingleStore Data to ChatGPT
Claude Desktop	MCP Server	How to Query Live SingleStore Data in Claude Desktop
Claude Code	Connect AI	How to Query Live SingleStore in Claude Code
Claude.ai	Connect AI	Use Claude.ai to Talk to Your SingleStore Data
Cline (VS Code)	MCP Server	How to Access Live SingleStore Data in Visual Studio Code via Cline
crewAI	Connect AI	How to Connect to Live SingleStore Data from crewAI Agents
Cursor	Connect AI	Integrate Cursor with Live SingleStore Data
Databricks Agent Bricks	Connect AI	Use Databricks Agent Bricks to Talk to SingleStore Data
Dataiku	Connect AI	Integrating Dataiku with SingleStore Data
Flowise	Connect AI	How to Connect Flowise AI Agents to Live SingleStore Data
Gemini (CLI)	Connect AI	How to Connect to Live SingleStore Data from Gemini CLI
Gemini Enterprise	Connect AI	How to Connect to Live SingleStore Data from Gemini Enterprise
Google ADK	Connect AI	How to Connect to Live SingleStore Data from Google ADK Agents
Google Vertex AI	Connect AI	Integrate Google Vertex AI Agents with Live SingleStore Data
Gumloop	Connect AI	Integrating Gumloop with SingleStore Data
IBM watsonx Orchestrate	Connect AI	Build AI Agents with SingleStore Data in IBM watsonx Orchestrate
Langchain	Connect AI	Integrating LangChain with SingleStore Data
LangGraph	Connect AI	Integrating LangGraph with SingleStore Data
Mastra	Connect AI	Connecting Mastra with SingleStore Data
Mistral (Le Chat)	Connect AI	Connect SingleStore Data to Mistral
MS Copilot Studio	Connect AI	Connect SingleStore Data to Microsoft Copilot Studio
n8n	Connect AI	Build SingleStore-Connected Workflows and AI Agents in n8n
OpenAI SDK (Python)	Connect AI	How to Connect to Live SingleStore Data from OpenAI Python Applications
Python MCP Server	Python	Connect SingleStore to AI Assistants With the CData Python MCP Server
Relevance AI	Connect AI	Build Agents in Relevance AI with Access to Live SingleStore Data
Sourcegraph Amp	Connect AI	How to Connect to Live SingleStore Data from Sourcegraph Amp

Business Intelligence & Analytics

Product	Technology	Article Title
Alteryx Designer	ODBC	Prepare, Blend, and Analyze SingleStore in Alteryx Designer (ODBC)
Alteryx Designer	Connect AI	Work with Live SingleStore Data in Alteryx Designer (Connect AI)
Amazon QuickSight	Connect AI	Build Interactive Dashboards from SingleStore Data in Amazon QuickSight
Amazon SageMaker	Connect AI	Integrate Live SingleStore data into Amazon SageMaker Canvas
Aqua Data Studio	JDBC	Connect to SingleStore in Aqua Data Studio
AWS Databricks	JDBC	Process & Analyze SingleStore Data in Databricks (AWS)
Azure Analysis Services	Connect AI	Model SingleStore Data Using Azure Analysis Services
Birst	JDBC	Build Visualizations of SingleStore in Birst
BIRT	JDBC	Design BIRT Reports on SingleStore
Clear Analytics	ODBC	Build Charts with SingleStore in Clear Analytics
Cognos Analytics (On-Prem)	Connect AI	Analyze SingleStore Data in Cognos Analytics
DBxtra	ODBC	Build Dashboards with SingleStore in DBxtra
Domo	ODBC	Create Datasets from SingleStore in Domo Workbench
Dundas BI	ODBC	Build Dashboards with SingleStore in Dundas BI
FineReport	JDBC	Feed SingleStore into FineReport
Gecokboard	Connect AI	Create Dashboards and Visualize Live SingleStore Data in Geckoboard
Google Sheets	Connect Spreadsheets	Access Live SingleStore Data in Google Sheets
Grafana	Connect AI	Create SingleStore-Connected Dashboards in Grafana
IBM Cognos BI	ODBC	Create Data Visualizations in Cognos BI with SingleStore
Infragistics Reveal	Connect AI	Analyze SingleStore Data in Infragistics Reval
JasperServer	JDBC	Create SingleStore Reports on JasperReports Server
Jaspersoft BI Suite	JDBC	Connect to SingleStore in Jaspersoft Studio
JReport Designer	JDBC	Integrate with SingleStore in JReport Designer
Klipfolio	Connect AI	Create SingleStore-Connected Visualizations in Klipfolio
KNIME	JDBC	Enable the SingleStore JDBC Driver in KNIME
LINQPad	ADO.NET	Working with SingleStore in LINQPad
Looker	Connect AI	Analyze SingleStore Data in Looker
Looker Studio	Connect AI	Create Reports from SingleStore Data in Looker Studio
Metabase	Connect AI	Create Interactive SingleStore-Connected Metabase Dashboards
Microsoft Excel	Connect Spreadsheets	Access Live SingleStore Data in Excel Desktop
Microsoft Excel for the Web	Connect Spreadsheets	Access Live SingleStore Data in Excel for the Web
Microsoft SSAS	ADO.NET	Build an OLAP Cube in SSAS from SingleStore
MicroStrategy	Connect AI	Connect to Live SingleStore Data in MicroStrategy through Connect AI
MicroStrategy	JDBC	Use the CData JDBC Driver for SingleStore in MicroStrategy
Microstrategy Desktop	JDBC	Use the CData JDBC Driver for SingleStore in MicroStrategy Desktop
Microstrategy Web	JDBC	Use the CData JDBC Driver for SingleStore in MicroStrategy Web
Mode Analytics	Connect AI	Create SingleStore-Connected Visualizations in Mode
OBIEE	JDBC	SingleStore Reporting in OBIEE with the SingleStore JDBC Driver
pandas	Python	Use pandas to Visualize SingleStore in Python
Pentaho Report Designer	JDBC	Integrate SingleStore in the Pentaho Report Designer
Power BI Desktop	Power BI	Author Power BI Reports on Real-Time SingleStore
Power BI Service	Connect AI	Visualize Live SingleStore Data in the Power BI Service
Power Pivot	Connect AI	Access SingleStore Data in Microsoft Power Pivot
Power Query	Connect AI	Access SingleStore Data in Microsoft Power Query
Qlik Cloud	Connect AI	Create Apps from SingleStore Data in Qlik Sense Cloud
QlikView	ODBC	Connect to and Query SingleStore in QlikView over ODBC
R	JDBC	Analyze SingleStore in R (JDBC)
R	ODBC	Analyze SingleStore in R (ODBC)
RapidMiner	JDBC	Connect to SingleStore in RapidMiner
Redash	Connect AI	Query, Visualize, and Share live SingleStore Data in Redash
SAP Analytics Cloud	Connect AI	Analyze SingleStore Data in SAP Analytics Cloud
SAP Business Objects	JDBC	Create an SAP BusinessObjects Universe on the CData JDBC Driver for SingleStore
SAP Crystal Reports	JDBC	Publish Reports with SingleStore in Crystal Reports (JDBC)
SAP Crystal Reports	Connect AI	Publish Reports with SingleStore in Crystal Reports (Connect AI)
SAS	ODBC	Use the CData ODBC Driver for SingleStore in SAS for Real-Time Reporting and Analytics
SAS JMP	ODBC	Use the CData ODBC Driver for SingleStore in SAS JMP
SAS Viya	Connect AI	Analyze Live SingleStore Data in SAS Viya
Sisense	JDBC	Visualize Live SingleStore in Sisense
Spago BI	JDBC	Connect to SingleStore in SpagoBI
Tableau	Tableau	Visualize SingleStore in Tableau Desktop
Tableau	Connect AI	Visualize SingleStore in Tableau Desktop (Connect AI)
Tableau Cloud	Connect AI	Build SingleStore Visualizations in Tableau Cloud
Tableau Server	Tableau	Publish SingleStore-Connected Dashboards in Tableau Server
ThoughtSpot	Connect AI	Model, Search, and Visualize Live SingleStore Data in ThoughtSpot
TIBCO Spotfire	ADO.NET	Visualize SingleStore in TIBCO Spotfire through ADO.NET
TIBCO Spotfire Server	JDBC	Operational Reporting on SingleStore from Spotfire Server
Visio	ODBC	Link Visio Shapes to SingleStore
Zoho Analytics	Connect AI	Create SingleStore-Connected Dashboards in Zoho Analytics

ETL & Replication

Product	Technology	Article Title
Airbyte	Connect AI	Connect to SingleStore Data in Airbyte ELT Pipelines
Amazon Redshift	CData Sync	Automated Continuous SingleStore Replication to Amazon Redshift
Amazon S3	CData Sync	Automated Continuous SingleStore Replication to Amazon S3
Apache Airflow	JDBC	Bridge SingleStore Connectivity with Apache Airflow
Apache Camel	JDBC	Integrate with SingleStore using Apache Camel
Apache Cassandra	CData Sync	Automated Continuous SingleStore Replication to Apache Cassandra
Apache Kafka	CData Sync	Automated Continuous SingleStore Replication to Apache Kafka
Apache NiFi	JDBC	Bridge SingleStore Connectivity with Apache NiFi
Apache NiFi Batch Operations	JDBC	Perform Batch Operations with SingleStore Data in Apache NiFi
AWS Glue	Connect AI	Build ETL Jobs with SingleStore Data in AWS Glue Jobs
Azure Data Factory	Connect AI	Import SingleStore Data Using Azure Data Factory
Azure Data Lake	CData Sync	Automated Continuous SingleStore Replication to Azure Data Lake
Azure Synapse	CData Sync	Automated Continuous SingleStore Replication to Azure Synapse
BIML	SSIS	Use Biml to Build SSIS Tasks to Replicate SingleStore to SQL Server
CloverDX	JDBC	Connect to SingleStore in CloverDX (formerly CloverETL)
Couchbase	CData Sync	Automated Continuous SingleStore Replication to Couchbase
CSV	CData Sync	Automated Continuous SingleStore Replication to Local Delimited Files
Databricks	CData Sync	Automated Continuous SingleStore Replication to Databricks
ETL Validator	JDBC	How to Work with SingleStore in ETL Validator
FoxPro	ODBC	Work with SingleStore in FoxPro
Google AlloyDB	CData Sync	Automated Continuous SingleStore Replication to Google AlloyDB
Google BigQuery	CData Sync	Automated Continuous SingleStore Replication to Google BigQuery
Google Cloud SQL	CData Sync	Automated Continuous SingleStore Replication to Google Cloud SQL
Google Data Fusion	JDBC	Build SingleStore-Connected ETL Processes in Google Data Fusion
Google Data Fusion	Connect AI	Build Pipelines with Live SingleStore Data in Google Cloud Data Fusion (CData Connect AI)
Heroku / Salesforce Connect	CData Sync	Replicate SingleStore for Use in Salesforce Connect
HULFT Integrate	JDBC	Connect to SingleStore in HULFT Integrate
IBM DB2	CData Sync	Automated Continuous SingleStore Replication to IBM DB2
Informatica Cloud	JDBC	Integrate SingleStore in Your Informatica Cloud Instance
Informatica PowerCenter	JDBC	Create Informatica Mappings From/To a JDBC Data Source for SingleStore
Jaspersoft ETL	JDBC	Connect to SingleStore in Jaspersoft Studio
Microsoft Access	CData Sync	Automated Continuous SingleStore Replication to Microsoft Access
Microsoft Azure Tables	CData Sync	Automated Continuous SingleStore Replication to Azure SQL
Microsoft Excel	Excel	Transfer Data from Excel to SingleStore
Microsoft Power Automate	Connect AI	Build SingleStore-Connected Automated Tasks with Power Automate (Desktop)
Microsoft OneLake	CData Sync	Automated Continuous SingleStore Replication to Microsoft OneLake (Fabric}
MongoDB	CData Sync	Automated Continuous SingleStore Replication to MongoDB
MySQL	CData Sync	Automated Continuous SingleStore Replication to MySQL
Oracle Data Integrator	JDBC	ETL SingleStore in Oracle Data Integrator
Oracle Database	CData Sync	Automated Continuous SingleStore Replication to Oracle
Pentaho Data Integration	JDBC	Integrate SingleStore in Pentaho Data Integration
petl	Python	Extract, Transform, and Load SingleStore in Python
PostgreSQL	CData Sync	Automated Continuous SingleStore Replication to PostgreSQL
Replicate to MySQL	PowerShell	Replicate SingleStore to MySQL with PowerShell
SAP HANA	CData Sync	Automated Continuous SingleStore Replication to SAP HANA
SnapLogic	JDBC	Integrate SingleStore with External Services using SnapLogic (JDBC)
SnapLogic	Connect AI	Integration with SingleStore Data in SnapLogic (Connect AI)
Snowflake	CData Sync	Automated Continuous SingleStore Replication to Snowflake
SQL Server	CData Sync	Automated Continuous SingleStore Replication to SQL Server
SQL Server Linked Server	Connect AI	Connect to SingleStore Data as a SQL Server Linked Server
SQLite	CData Sync	Automated Continuous SingleStore Replication to SQLite
Talend	JDBC	Connect to SingleStore and Transfer Data in Talend
UiPath Studio	ODBC	Create an RPA Flow that Connects to SingleStore in UiPath Studio
Vertica	CData Sync	Automated Continuous SingleStore Replication to a Vertica Database
Workato	Connect AI	Build Automated Workflows with Live SingleStore Data in Workato
Zapier	Connect AI	Build Automated SingleStore-Connected Workflows in Zapier

Data Virtualization

Product	Technology	Article Title
Access Linked Tables	ODBC	Update SingleStore with a Microsoft Access Linked Table
APOS Live Data Gateway	JDBC	Build Semantic Layer Views for SingleStore (JDBC)
APOS Live Data Gateway	Connect AI	Build Semantic Layer Views for SingleStore Data (Connect AI)
Denodo	JDBC	Create A Data Source for SingleStore in Denodo Platform
Dremio	JDBC	Connect to SingleStore as an External Source in Dremio
MySQL Federated Tables	ODBC	Connect to SingleStore as Federated Tables in MySQL
Oracle Database	ODBC	Access SingleStore as a Remote Oracle Database
PostgreSQL FDW	JDBC	A PostgreSQL Interface for SingleStore
Salesforce Connect	Connect AI	Edit and Search SingleStore External Objects in Salesforce Connect
Salesforce External Services	Connect AI	Connect to SingleStore through External Services in Salesforce
SQL Server Linked Servers	ODBC	Connect to SingleStore as a Linked Server
SQL Server PolyBase	Connect AI	Connect to SingleStore Data using PolyBase with Connect AI
SQL Server PolyBase	ODBC	Connect to SingleStore as an External Data Source using PolyBase
TIBCO Data Virtualization	TIBCO DV	Access Live SingleStore Data in TIBCO Data Virtualization

Software Development

Product	Technology	Article Title
AWS Lambda	JDBC	Access Live SingleStore Data in AWS Lambda
Axios	Connect AI	Build SingleStore-Connected Web Apps with Axios and CData Connect AI
.NET Charts	ADO.NET	DataBind Charts to SingleStore
.NET QueryBuilder	ODBC	Rapidly Develop SingleStore-Driven Apps with Active Query Builder
Apache Spark	JDBC	Work with SingleStore in Apache Spark Using SQL
AppSheet	Connect AI	Create SingleStore-Connected Business Apps in AppSheet
Bubble.io	Connect AI	Build SingleStore-Connected Apps in Bubble
C++Builder	ODBC	DataBind Controls to SingleStore Data in C++Builder
Choreo	Connect AI	Build Custom Apps on SingleStore Data in Choreo
Claude Code	MCP Server	Build SingleStore-Powered Applications in Claude Code with CData Code Assist MCP
ColdFusion	JDBC	Query SingleStore in ColdFusion Using JDBC
ColdFusion	ODBC	Query SingleStore in ColdFusion Using ODBC
Cursor	MCP Server	Build SingleStore-Powered Applications in Cursor with CData Code Assist MCP
Dash	Python	Use Dash & Python to Build Web Apps on SingleStore
Delphi	ODBC	DataBind Controls to SingleStore Data in Delphi
DevExpress	ADO.NET	DataBind SingleStore to the DevExpress Data Grid
EF - Code First	ADO.NET	Access SingleStore with Entity Framework 6
EF - LINQ	ADO.NET	LINQ to SingleStore
EF - MVC	ADO.NET	Build MVC Applications with Connectivity to SingleStore
Filemaker Pro	ODBC	Bidirectional Access to SingleStore from FileMaker Pro
Filemaker Pro (on Mac)	JDBC	Bidirectional Access to SingleStore from FileMaker Pro (on Mac)
Gemini Code Assist	MCP Server	Build SingleStore-Powered Applications in Gemini Code Assist with CData Code Assist MCP
GitHub Copilot	MCP Server	Build SingleStore-Powered Applications in GitHub Copilot with CData Code Assist MCP
Go	ODBC	Write a Simple Go Application to work with SingleStore on Linux
Google Apps Script	Connect AI	Connect to SingleStore Data in Google Apps Script
Hibernate	JDBC	Object-Relational Mapping (ORM) with SingleStore Entities in Java
IntelliJ	JDBC	Connect to SingleStore in IntelliJ
JBoss	JDBC	Connect to SingleStore from a Connection Pool in JBoss
JDBI	JDBC	Create a Data Access Object for SingleStore using JDBI
JetBrains RubyMine	JDBC	Integrate SingleStore with JetBrains RubyMine
Jitterbit	Connect AI	Integrate with Live SingleStore Data in Jitterbit
JRuby	JDBC	Connect to SingleStore in JRuby
Lazarus IDE	ODBC	Easily Integrate SingleStore Data in Lazarus Pascal IDE
Mendix	Connect AI	Build SingleStore-Connected Apps in Mendix (Connect AI)
Mendix	JDBC	Build SingleStore-Connected Apps in Mendix (JDBC)
Microsoft Power Apps	Connect AI	Integrate Live SingleStore Data into Custom Business Apps Built in Power Apps
NodeJS	Connect AI	Query SingleStore Data in Node.js (via Connect AI)
NodeJS	ODBC	Query SingleStore through ODBC in Node.js
OutSystems	Connect AI	Create SingleStore-Connected Enterprise Applications in OutSystems
Perplexity Desktop	MCP Server	How to Query Live SingleStore Data in Perplexity Desktop
PHP	ODBC	Natively Connect to SingleStore in PHP
PowerBuilder	ADO.NET	Connect to SingleStore from PowerBuilder
PowerShell	PowerShell	Pipe SingleStore to CSV in PowerShell
PyCharm	ODBC	Using the CData ODBC Driver for SingleStore in PyCharm
Python	ODBC	Connect to SingleStore in Python on Linux/UNIX
Retool	Connect AI	Build SingleStore-Connected Apps in Retool
Ruby	ODBC	Connect to SingleStore in Ruby
RunMyProcess	Connect AI	Connect to SingleStore Data in RunMyProcess
RunMyProcess DSEC	JDBC	Connect to SingleStore in DigitalSuite Studio through RunMyProcess DSEC
Servoy	JDBC	Build SingleStore-Connected Apps in Servoy
Spring Boot	JDBC	Access Live SingleStore Data in Spring Boot Apps
SQLAlchemy	Python	Use SQLAlchemy ORMs to Access SingleStore in Python
Tomcat	JDBC	Configure the CData JDBC Driver for SingleStore in a Connection Pool in Tomcat
Unqork	Connect AI	Create SingleStore-Connected Applications in Unqork
VCL App (RAD Studio)	ODBC	Build a Simple VCL Application for SingleStore
WebLogic	JDBC	Connect to SingleStore from a Connection Pool in WebLogic

Data Management

Product	Technology	Article Title
Apache Solr	JDBC	Import SingleStore Data into Apache Solr
Coginiti Pro	JDBC	Access Live SingleStore Data in Coginiti Pro
DataGrip	JDBC	Qeury SingleStore Data in DataGrip
DB Artisan	JDBC	Manage SingleStore in DBArtisan as a JDBC Source
DB Artisan	ODBC	Connect to SingleStore in DBArtisan
DBeaver	JDBC	Connect to SingleStore in DBeaver
DbVisualizer	JDBC	Connect to SingleStore in DBVisualizer
HeidiSQL	Connect AI	Connect to SingleStore Data in HeidiSQL
Informatica Enterprise Data Catalog	JDBC	Add SingleStore to Informatica Enterprise Data Catalog
MySQL Workbench	ODBC	Query SingleStore in MySQL Workbench (ODBC)
QuerySurge	JDBC	Validate SingleStore Data with QuerySurge
RazorSQL	JDBC	Connect to SingleStore in RazorSQL
SQuirreL	JDBC	Connect to SingleStore in Squirrel SQL Client

Workflow Automation

Product	Technology	Article Title
Blue Prism	ODBC	Integrate Live SingleStore Data for Intelligent Robotic Process Automation
MuleSoft Anypoint	JDBC	Access SingleStore in Anypoint Using SQL
Nintex Workflow Cloud	Connect AI	Build SingleStore-Connected Workflows in Nintex
Power Automate	Connect AI	Integrate SingleStore Data into Power Automate Automated Tasks
SSIS Export	SSIS	Export Data from SQL Server to SingleStore through SSIS
SSIS Import	SSIS	Import SingleStore Data into SQL Server using SSIS
SSIS Lookup	SSIS	Insert New or Update Existing SingleStore Records from SQL Server

Ready to get started?

Learn more:

SingleStore Connectivity Solutions

URL: https://www.cdata.com/kb/tech/singlestore-article-list.rst