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 QuickSightConnect ServerBuild 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 StudioConnect ServerCreate Reports from SingleStore in Google Data Studio
Google SheetsConnect ServerAccess Live SingleStore in Google Sheets
IBM Cognos BIODBCCreate Data Visualizations in Cognos BI with SingleStore
Infragistics RevealConnect ServerAnalyze SingleStore Data in Infragistics Reval
JasperServerJDBCCreate SingleStore Reports on JasperReports Server
Jaspersoft BI SuiteJDBCConnect to SingleStore in Jaspersoft Studio
JReport DesignerJDBCIntegrate with SingleStore in JReport Designer
KlipfolioConnect ServerCreate 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 OnlineConnect ServerVisualize Live SingleStore in the Power BI Service
MetabaseConnect ServerCreate Interactive SingleStore-Connected Metabase Dashboards
Microsoft SSASADO.NETBuild an OLAP Cube in SSAS from SingleStore
MicroStrategyJDBCUse the CData JDBC Driver for SingleStore in MicroStrategy
MicroStrategyConnect ServerConnect to Live SingleStore in MicroStrategy through Connect Server
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
SAP Analytics CloudConnect ServerAnalyze SingleStore in SAP Analytics Cloud
SAP Business ObjectsJDBCCreate an SAP BusinessObjects Universe on the CData JDBC Driver for SingleStore
SAP Crystal ReportsJDBCPublish Reports with SingleStore in Crystal Reports
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 OnlineConnect ServerBuild 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 NiFiJDBCBridge SingleStore Connectivity with Apache NiFi
BIMLSSISUse Biml to Build SSIS Tasks to Replicate SingleStore to SQL Server
CloverDXJDBCConnect to SingleStore in CloverDX (formerly CloverETL)
DatabricksCData SyncAutomated Continuous SingleStore Replication to Databricks
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
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 ExcelExcelTransfer Data from Excel to SingleStore
Oracle Data IntegratorJDBCETL SingleStore in Oracle Data Integrator
petlPythonExtract, Transform, and Load SingleStore in Python
SnapLogicJDBCIntegrate SingleStore with External Services using SnapLogic
Replicate to CSVPowerShellReplicate SingleStore to MySQL with PowerShell
SnowflakeCData SyncAutomated Continuous SingleStore Replication to Snowflake
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
Apache SparkJDBCWork with SingleStore in Apache Spark Using SQL
AppSheetConnect ServerCreate SingleStore-Connected Business Apps in AppSheet
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 ScriptConnect ServerConnect 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
NodeJSConnect ServerQuery SingleStore in Node.js (via Connect Server)
NodeJSJDBCQuery SingleStore through ODBC in Node.js
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
RunMyProcessConnect ServerConnect to SingleStore in RunMyProcess
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
UnqorkConnect ServerCreate 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