Ready to get started?

Learn more:

REST Connectivity Solutions

REST Integration Guides and Tutorials



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

CData Software's connectivity tools enable users to connect directly to live REST 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 REST 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 REST in Alteryx Designer (ODBC)
Amazon QuickSightConnect ServerBuild Interactive Dashboards from REST Data in Amazon QuickSight
Aqua Data StudioJDBCConnect to REST in Aqua Data Studio
AWS DatabricksJDBCProcess & Analyze REST Data in Databricks (AWS)
BirstJDBCBuild Visualizations of REST in Birst
BIRTJDBCDesign BIRT Reports on REST
Clear AnalyticsODBCBuild Charts with REST in Clear Analytics
DBxtraODBCBuild Dashboards with REST in DBxtra
DomoODBCCreate Datasets from REST in Domo Workbench
Dundas BIODBCBuild Dashboards with REST in Dundas BI
Excel (on Mac OS)ODBCWork with REST Data in MS Excel on Mac OS X
FineReportJDBCFeed REST into FineReport
IBM Cognos BIODBCCreate Data Visualizations in Cognos BI with REST
Infragistics RevealConnect ServerAnalyze REST Data in Infragistics Reval
JasperServerJDBCCreate REST Reports on JasperReports Server
Jaspersoft BI SuiteJDBCConnect to REST in Jaspersoft Studio
JReport DesignerJDBCIntegrate with REST in JReport Designer
KlipfolioConnect ServerCreate REST-Connected Visualizations in Klipfolio
KNIMEJDBCEnable the REST JDBC Driver in KNIME
LINQPadADO.NETWorking with REST in LINQPad
Microsoft SSASADO.NETBuild an OLAP Cube in SSAS from REST
MicroStrategyConnect ServerConnect to Live REST Data in MicroStrategy through Connect Server
MicroStrategyJDBCUse the CData JDBC Driver for REST in MicroStrategy
Microstrategy DesktopJDBCUse the CData JDBC Driver for REST in MicroStrategy Desktop
Microstrategy WebJDBCUse the CData JDBC Driver for REST in MicroStrategy Web
OBIEEJDBCREST Reporting in OBIEE with the REST JDBC Driver
pandasPythonUse pandas to Visualize REST in Python
Pentaho Report DesignerJDBCIntegrate REST in the Pentaho Report Designer
Power BI DesktopPower BIAuthor Power BI Reports on Real-Time REST
Power BI ServiceConnect ServerVisualize Live REST Data in the Power BI Service
Power PivotConnect ServerAccess REST Data in Microsoft Power Pivot
Power QueryConnect ServerAccess REST Data in Microsoft Power Query
Qlik CloudConnect ServerCreate Apps from REST Data in Qlik Sense Cloud
QlikViewODBCConnect to and Query REST in QlikView over ODBC
RJDBCAnalyze REST in R (JDBC)
RODBCAnalyze REST in R (ODBC)
RapidMinerJDBCConnect to REST in RapidMiner
RedashConnect ServerBuild REST-Connected Dashboards in Redash
SAP Analytics CloudConnect ServerAnalyze REST Data in SAP Analytics Cloud
SAP Business ObjectsJDBCCreate an SAP BusinessObjects Universe on the CData JDBC Driver for REST
SAP Crystal ReportsJDBCPublish Reports with REST in Crystal Reports
SASODBCUse the CData ODBC Driver for REST in SAS for Real-Time Reporting and Analytics
SAS JMPODBCUse the CData ODBC Driver for REST in SAS JMP
SisenseJDBCVisualize Live REST in Sisense
Spago BIJDBCConnect to REST in SpagoBI
TableauTableauVisualize REST in Tableau Desktop
Tableau CloudConnect ServerBuild REST Visualizations in Tableau Cloud
Tableau ServerTableauPublish REST-Connected Dashboards in Tableau Server
TIBCO SpotfireADO.NETVisualize REST in TIBCO Spotfire through ADO.NET
TIBCO SpotfireConnect ServerVisualize REST Data in TIBCO Spotfire
TIBCO Spotfire ServerJDBCOperational Reporting on REST from Spotfire Server
VisioODBCLink Visio Shapes to REST

Back to top

ETL & Replication


ProductTechnologyArticle Title
Amazon RedshiftCData SyncAutomated Continuous REST Replication to Amazon Redshift
Amazon S3CData SyncAutomated Continuous REST Replication to Amazon S3
Apache AirflowJDBCBridge REST Connectivity with Apache Airflow
Apache CamelJDBCIntegrate with REST using Apache Camel
Apache CassandraCData SyncAutomated Continuous REST Replication to Apache Cassandra
Apache KafkaCData SyncAutomated Continuous REST Replication to Apache Kafka
Apache NiFiJDBCBridge REST Connectivity with Apache NiFi
Apache NiFi Batch OperationsJDBCPerform Batch Operations with REST Data in Apache NiFi
Azure Data LakeCData SyncAutomated Continuous REST Replication to Azure Data Lake
Azure SynapseCData SyncAutomated Continuous REST Replication to Azure Synapse
BIMLSSISUse Biml to Build SSIS Tasks to Replicate REST to SQL Server
CloverDXJDBCConnect to REST in CloverDX (formerly CloverETL)
CouchbaseCData SyncAutomated Continuous REST Replication to Couchbase
CSVCData SyncAutomated Continuous REST Replication to Local Delimited Files
DatabricksCData SyncAutomated Continuous REST Replication to Databricks
FoxProODBCWork with REST in FoxPro
Google AlloyDBCData SyncAutomated Continuous REST Replication to Google AlloyDB
Google BigQueryCData SyncAutomated Continuous REST Replication to Google BigQuery
Google Cloud SQLCData SyncAutomated Continuous REST Replication to Google Cloud SQL
Google Data FusionJDBCBuild REST-Connected ETL Processes in Google Data Fusion
Heroku / Salesforce ConnectCData SyncReplicate REST for Use in Salesforce Connect
HULFT IntegrateJDBCConnect to REST in HULFT Integrate
IBM DB2CData SyncAutomated Continuous REST Replication to IBM DB2
Informatica CloudJDBCIntegrate REST in Your Informatica Cloud Instance
Informatica PowerCenterJDBCCreate Informatica Mappings From/To a JDBC Data Source for REST
Jaspersoft ETLJDBCConnect to REST in Jaspersoft Studio
Microsoft AccessCData SyncAutomated Continuous REST Replication to Microsoft Access
Microsoft Azure TablesCData SyncAutomated Continuous REST Replication to Azure SQL
Microsoft ExcelExcelTransfer Data from Excel to REST
Microsoft Power AutomateConnect ServerBuild REST-Connected Automated Tasks with Power Automate (Desktop)
MongoDBCData SyncAutomated Continuous REST Replication to MongoDB
MySQLCData SyncAutomated Continuous REST Replication to MySQL
Oracle Data IntegratorJDBCETL REST in Oracle Data Integrator
Oracle DatabaseCData SyncAutomated Continuous REST Replication to Oracle
petlPythonExtract, Transform, and Load REST in Python
PostgreSQLCData SyncAutomated Continuous REST Replication to PostgreSQL
SAP HANACData SyncAutomated Continuous REST Replication to SAP HANA
SingleStoreCData SyncAutomated Continuous REST Replication to SingleStore
SnapLogicJDBCIntegrate REST with External Services using SnapLogic
SnowflakeCData SyncAutomated Continuous REST Replication to Snowflake
SQL ServerCData SyncAutomated Continuous REST Replication to SQL Server
SQL Server Linked ServerConnect ServerConnect to REST Data as a SQL Server Linked Server
SQLiteCData SyncAutomated Continuous REST Replication to SQLite
TalendJDBCConnect to REST and Transfer Data in Talend
UiPath StudioODBCCreate an RPA Flow that Connects to REST in UiPath Studio
VerticaCData SyncAutomated Continuous REST Replication to a Vertica Database

Back to top

Data Virtualization



Back to top

Software Development


ProductTechnologyArticle Title
.NET ChartsADO.NETDataBind Charts to REST
.NET QueryBuilderODBCRapidly Develop REST-Driven Apps with Active Query Builder
Angular JSConnect ServerUsing AngularJS to Build Dynamic Web Pages with REST
Apache SparkJDBCWork with REST in Apache Spark Using SQL
AppSheetConnect ServerCreate REST-Connected Business Apps in AppSheet
C++BuilderODBCDataBind Controls to REST Data in C++Builder
ColdFusionJDBCQuery REST in ColdFusion Using JDBC
ColdFusionODBCQuery REST in ColdFusion Using ODBC
DashPythonUse Dash & Python to Build Web Apps on REST
DelphiODBCDataBind Controls to REST Data in Delphi
DevExpressADO.NETDataBind REST to the DevExpress Data Grid
EF - Code FirstADO.NETAccess REST with Entity Framework 6
EF - LINQADO.NETLINQ to REST
EF - MVCADO.NETBuild MVC Applications with Connectivity to REST
Filemaker ProODBCBidirectional Access to REST from FileMaker Pro
Filemaker Pro (on Mac)JDBCBidirectional Access to REST from FileMaker Pro (on Mac)
GoODBCWrite a Simple Go Application to work with REST on Linux
Google Apps ScriptConnect ServerConnect to REST Data in Google Apps Script
HibernateJDBCObject-Relational Mapping (ORM) with REST Entities in Java
IntelliJJDBCConnect to REST in IntelliJ
JBossJDBCConnect to REST from a Connection Pool in JBoss
JDBIJDBCCreate a Data Access Object for REST using JDBI
JRubyJDBCConnect to REST in JRuby
Microsoft Power AppsConnect ServerIntegrate Live REST Data into Custom Business Apps Built in Power Apps
NodeJSConnect ServerQuery REST Data in Node.js (via Connect Server)
NodeJSODBCQuery REST through ODBC in Node.js
PHPConnect ServerAccess REST in PHP through Connect Server
PHPODBCNatively Connect to REST in PHP
PowerBuilderADO.NETConnect to REST from PowerBuilder
PyCharmODBCUsing the CData ODBC Driver for REST in PyCharm
PythonODBCConnect to REST in Python on Linux/UNIX
ReactConnect ServerBuild Dynamic React Apps with REST Data
RubyODBCConnect to REST in Ruby
RunMyProcessConnect ServerConnect to REST Data in RunMyProcess
RunMyProcess DSECJDBCConnect to REST in DigitalSuite Studio through RunMyProcess DSEC
SAP UI5Connect ServerIntegrate Real-Time Access to REST in SAPUI5 MVC Apps
ServoyJDBCBuild REST-Connected Apps in Servoy
Spring BootJDBCAccess Live REST Data in Spring Boot Apps
SQLAlchemyPythonUse SQLAlchemy ORMs to Access REST in Python
TomcatJDBCConfigure the CData JDBC Driver for REST in a Connection Pool in Tomcat
UnqorkConnect ServerCreate REST-Connected Applications in Unqork
VCL App (RAD Studio)ODBCBuild a Simple VCL Application for REST
WebLogicJDBCConnect to REST from a Connection Pool in WebLogic

Back to top

Data Management



Back to top

Workflow Automation



Back to top