SingleStore Integration Guides and Tutorials

Ready to get started?

Learn more:

SingleStore Connectivity Solutions


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

CData Software connectivity tools provide access to live SingleStore data from popular BI, analytics, ETL, and custom applications, offering our customers access to their data wherever they want. Below you will find a list of guides and tutorials for integrating with live SingleStore data.

Integration Use-Cases

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

Business Intelligence & Analytics


ProductTechnologyArticle Title
Alteryx DesignerODBCPrepare, Blend, and Analyze SingleStore in Alteryx Designer
Amazon QuickSightCData ConnectBuild Interactive Dashboards from SingleStore in Amazon QuickSight
Aqua Data StudioJDBCConnect to SingleStore in Aqua Data Studio
BirstJDBCBuild Visualizations of SingleStore in Birst
BIRTJDBCDesign BIRT Reports on SingleStore
Clear AnalyticsODBCBuild Charts with SingleStore in Clear Analytics
Microsoft ExcelExcelExcel Spreadsheet Automation with the QUERY Formula
DBxtraODBCBuild Dashboards with SingleStore in DBxtra
DomoODBCCreate Datasets from SingleStore in Domo Workbench
Dundas BIODBCBuild Dashboards with SingleStore in Dundas BI
FineReportJDBCFeed SingleStore into FineReport
Google Data StudioCData ConnectCreate Reports from SingleStore in Google Data Studio
IBM Cognos BIODBCCreate Data Visualizations in Cognos BI with SingleStore
JasperServerJDBCCreate SingleStore Reports on JasperReports Server
Jaspersoft BI SuiteJDBCConnect to SingleStore in Jaspersoft Studio
JReport DesignerJDBCIntegrate with SingleStore in JReport Designer
KlipfolioCData ConnectCreate SingleStore-Connected Visualizations in Klipfolio
KNIMEJDBCEnable the SingleStore JDBC Driver in KNIME
LINQPadADO.NETWorking with SingleStore in LINQPad
Power BI DesktopPower BIAuthor Power BI Reports on Real-Time SingleStore
Power BI OnlineCData ConnectVisualize Live SingleStore in the Power BI Service
MetabaseCData ConnectCreate Interactive SingleStore-Connected Metabase Dashboards
Microsoft SSASADO.NETBuild an OLAP Cube in SSAS from SingleStore
MicroStrategyJDBCUse the CData JDBC Driver for SingleStore in MicroStrategy
OBIEEJDBCSingleStore Reporting in OBIEE with the SingleStore JDBC Driver
pandasPythonUse pandas to Visualize SingleStore in Python
Pentaho Report DesignerJDBCIntegrate SingleStore in the Pentaho Report Designer
QlikViewODBCConnect to and Query SingleStore in QlikView over ODBC
RJDBCAnalyze SingleStore in R
RapidMinerJDBCConnect to SingleStore in RapidMiner
RedashCData ConnectBuild SingleStore-Connected Dashboards in Redash
SAP Business ObjectsJDBCCreate an SAP BusinessObjects Universe on the CData JDBC Driver for SingleStore
SAP Crystal ReportsJDBCPublish Reports with SingleStore in Crystal Reports
SAP LumiraAPI ServerConsume SingleStore OData Feeds in SAP Lumira
SASODBCUse the CData ODBC Driver for SingleStore in SAS for Real-Time Reporting and Analytics
SisenseJDBCVisualize Live SingleStore in Sisense
Spago BIJDBCConnect to SingleStore in SpagoBI
TableauTableauVisualize SingleStore in Tableau Desktop
Tableau OnlineCData ConnectBuild SingleStore Visualizations in Tableau Online
Tableau ServerTableauPublish SingleStore-Connected Dashboards in Tableau Server
TIBCO SpotfireADO.NETVisualize SingleStore in TIBCO Spotfire through ADO.NET
TIBCO Spotfire ServerJDBCOperational Reporting on SingleStore from Spotfire Server
VisioODBCLink Visio Shapes to SingleStore

Back to top

ETL & Replication


ProductTechnologyArticle Title
Amazon RedshiftCData SyncAutomated Continuous SingleStore Replication to Amazon Redshift
Amazon S3CData SyncAutomated Continuous SingleStore Replication to Amazon S3
Apache CamelJDBCIntegrate with SingleStore using Apache Camel
Apache CassandraCData SyncAutomated Continuous SingleStore Replication to Apache Cassandra
Apache NiFiJDBCBridge SingleStore Connectivity with Apache NiFi
AWS GlueJDBCConnect to SingleStore in AWS Glue Jobs Using JDBC
BIMLSSISUse Biml to Build SSIS Tasks to Replicate SingleStore to SQL Server
CloverDXJDBCConnect to SingleStore in CloverDX (formerly CloverETL)
CSVCData SyncAutomated Continuous SingleStore Replication to Local Delimited Files
DatabricksCData SyncAutomated Continuous SingleStore Replication to Databricks
IBM DB2CData SyncAutomated Continuous SingleStore Replication to IBM DB2
FoxProODBCWork with SingleStore in FoxPro
Google BigQueryCData SyncAutomated Continuous SingleStore Replication to Google BigQuery
Google Cloud SQLCData SyncAutomated Continuous SingleStore Replication to Google Cloud SQL
Google Data FusionJDBCBuild SingleStore-Connected ETL Processes in Google Data Fusion
Heroku / Salesforce ConnectCData SyncReplicate SingleStore for Use in Salesforce Connect
HULFT IntegrateJDBCConnect to SingleStore in HULFT Integrate
Informatica CloudJDBCIntegrate SingleStore in Your Informatica Cloud Instance
Informatica PowerCenterJDBCCreate Informatica Mappings From/To a JDBC Data Source for SingleStore
Jaspersoft ETLJDBCConnect to SingleStore in Jaspersoft Studio
Microsoft AccessCData SyncAutomated Continuous SingleStore Replication to Microsoft Access
Microsoft Azure TablesCData SyncAutomated Continuous SingleStore Replication to Azure SQL
Microsoft ExcelExcelTransfer Data from Excel to SingleStore
MongoDBCData SyncAutomated Continuous SingleStore Replication to MongoDB
MySQLCData SyncAutomated Continuous SingleStore Replication to MySQL
Oracle Data IntegratorJDBCETL SingleStore in Oracle Data Integrator
Oracle DatabaseCData SyncAutomated Continuous SingleStore Replication to Oracle
petlPythonExtract, Transform, and Load SingleStore in Python
PostgreSQLCData SyncAutomated Continuous SingleStore Replication to PostgreSQL
Replicate to CSVPowerShellReplicate SingleStore to MySQL with PowerShell
SnowflakeCData SyncAutomated Continuous SingleStore Replication to Snowflake
SQL ServerCData SyncAutomated Continuous SingleStore Replication to SQL Server
SQLiteCData SyncAutomated Continuous SingleStore Replication to SQLite
TalendJDBCConnect to SingleStore and Transfer Data in Talend
UiPath StudioODBCCreate an RPA Flow that Connects to SingleStore in UiPath Studio
VerticaCData SyncAutomated Continuous SingleStore Replication to a Vertica Database

Back to top

Data Virtualization



Back to top

Software Development


ProductTechnologyArticle Title
.NET ChartsADO.NETDataBind Charts to SingleStore
.NET QueryBuilderODBCRapidly Develop SingleStore-Driven Apps with Active Query Builder
Angular JSAPI ServerUsing AngularJS to Build Dynamic Web Pages with SingleStore
Apache SparkJDBCWork with SingleStore in Apache Spark Using SQL
AppSheetCData ConnectCreate SingleStore-Connected Business Apps in AppSheet
Microsoft Azure Logic AppsAPI ServerTrigger SingleStore IFTTT Flows in Azure App Service
ColdFusionJDBCQuery SingleStore in ColdFusion
DashPythonUse Dash & Python to Build Web Apps on SingleStore
DevExpressADO.NETDataBind SingleStore to the DevExpress Data Grid
EF - Code FirstADO.NETAccess SingleStore with Entity Framework 6
EF - LINQADO.NETLINQ to SingleStore
EF - MVCADO.NETBuild MVC Applications with Connectivity to SingleStore
Filemaker ProJDBCBidirectional Access to SingleStore from FileMaker Pro
GoODBCWrite a Simple Go Application to work with SingleStore on Linux
Google Apps ScriptCData ConnectConnect to SingleStore in Google Apps Script
HibernateJDBCObject-Relational Mapping (ORM) with SingleStore Entities in Java
IntelliJJDBCConnect to SingleStore in IntelliJ
JBossJDBCConnect to SingleStore from a Connection Pool in JBoss
JDBIJDBCCreate a Data Access Object for SingleStore using JDBI
JRubyJDBCConnect to SingleStore in JRuby
NodeJSAPI ServerQuery SingleStore from Node.js
NodeJSCData ConnectQuery SingleStore as a MySQL Database in Node.js
NodeJSJDBCQuery SingleStore through ODBC in Node.js
PHPCData ConnectAccess SingleStore in PHP through the Cloud Hub
PHPODBCNatively Connect to SingleStore in PHP
PowerShellPowerShellPipe SingleStore to CSV in PowerShell
PowerBuilderADO.NETConnect to SingleStore from PowerBuilder
PyCharmODBCUsing the CData ODBC Driver for SingleStore in PyCharm
PythonODBCConnect to SingleStore in Python on Linux/UNIX
RubyODBCConnect to SingleStore in Ruby
SAP UI5API ServerIntegrate Real-Time Access to SingleStore in SAPUI5 MVC Apps
ServoyJDBCBuild SingleStore-Connected Apps in Servoy
SQLAlchemyPythonUse SQLAlchemy ORMs to Access SingleStore in Python
TomcatJDBCConfigure the CData JDBC Driver for SingleStore in a Connection Pool in Tomcat
UnqorkCData ConnectCreate SingleStore-Connected Applications in Unqork
WebLogicJDBCConnect to SingleStore from a Connection Pool in WebLogic

Back to top

Data Management



Back to top

Workflow Automation



Back to top