Ready to get started?

Learn more about REST Connectivity Solutions

Learn More

REST Integration Guides and Tutorials

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

CData Software connectivity tools provide access to live REST 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 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
Amazon QuickSightCloud HubBuild Interactive Dashboards from REST in Amazon QuickSight
Aqua Data StudioJDBCConnect to REST in Aqua Data Studio
BirstJDBCBuild Visualizations of REST in Birst
BIRTJDBCDesign BIRT Reports on REST
Clear AnalyticsODBCBuild Charts with REST in Clear Analytics
Microsoft ExcelExcelExcel Spreadsheet Automation with the QUERY Formula
DBxtraODBCBuild Dashboards with REST in DBxtra
DomoODBCCreate Datasets from REST in Domo Workbench
Dundas BIODBCBuild Dashboards with REST in Dundas BI
FineReportJDBCFeed REST into FineReport
Google Data StudioCloud HubCreate Reports from REST in Google Data Studio
IBM Cognos BIODBCCreate Data Visualizations in Cognos BI with REST
JasperServerJDBCCreate REST Reports on JasperReports Server
Jaspersoft BI SuiteJDBCConnect to REST in Jaspersoft Studio
JReport DesignerJDBCIntegrate with REST in JReport Designer
KlipfolioCloud HubCreate REST-Connected Visualizations in Klipfolio
KNIMEJDBCEnable the REST JDBC Driver in KNIME
LINQPadADO.NETWorking with REST in LINQPad
Power BI DesktopPower BIAuthor Power BI Reports on Real-Time REST
Power BI OnlineCloud HubVisualize Live REST in the Power BI Service
Microsoft SSASADO.NETBuild an OLAP Cube in SSAS from REST
MicroStrategyJDBCUse the CData JDBC Driver for REST in MicroStrategy
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
QlikViewODBCConnect to and Query REST in QlikView over ODBC
RJDBCAnalyze REST in R
RapidMiner JDBCConnect to REST in RapidMiner
SAP Business ObjectsJDBCCreate an SAP BusinessObjects Universe on the CData JDBC Driver for REST
SAP Crystal ReportsJDBCPublish Reports with REST in Crystal Reports
SAP LumiraAPI ServerConsume REST OData Feeds in SAP Lumira
SASODBCUse the CData ODBC Driver for REST in SAS for Real-Time Reporting and Analytics
SisenseJDBCVisualize Live REST in Sisense
Spago BIJDBCConnect to REST in SpagoBI
TableauODBCVisualize REST in Tableau
Tableau OnlineCloud HubBuild REST Visualizations in Tableau Online
Tableau ServerODBCPublish and Share REST Dashboards with Tableau Server
TIBCO SpotfireADO.NETVisualize REST in TIBCO Spotfire through ADO.NET
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 CamelJDBCIntegrate with REST using Apache Camel
Apache CassandraCData SyncAutomated Continuous REST Replication to Apache Cassandra
Apache NiFiJDBCBridge REST Connectivity with Apache NiFi
AWS GlueJDBCConnect to REST in AWS Glue Jobs Using JDBC
BIMLSSISUse Biml to Build SSIS Tasks to Replicate REST to SQL Server
CloverDXJDBCConnect to REST in CloverDX (formerly CloverETL)
CSVCData SyncAutomated Continuous REST Replication to Local Delimited Files
IBM DB2CData SyncAutomated Continuous REST Replication to IBM DB2
FoxProODBCWork with REST in FoxPro
Google BigQueryCData SyncAutomated Continuous REST Replication to Google BigQuery
Google Cloud SQLCData SyncAutomated Continuous REST Replication to Google Cloud SQL
Google Data FusionJDBCPipe REST in Google Data Fusion
Heroku / Salesforce ConnectCData SyncReplicate REST for Use in Salesforce Connect
HULFT IntegrateJDBCConnect to REST in HULFT Integrate
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
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, Tranform, and Load REST in Python
PostgreSQLCData SyncAutomated Continuous REST Replication to PostgreSQL
Replicate to CSVPowerShellReplicate REST to MySQL with PowerShell
SnowflakeCData SyncAutomated Continuous REST Replication to Snowflake
SQL ServerCData SyncAutomated Continuous REST Replication to SQL 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

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 JSAPI ServerUsing AngularJS to Build Dynamic Web Pages with REST
Apache SparkJDBCWork with REST in Apache Spark Using SQL
Microsoft Azure Logic AppsAPI ServerTrigger REST IFTTT Flows in Azure App Service
ColdFusionJDBCQuery REST in ColdFusion
DashPythonUse Dash & Python to Build Web Apps on REST
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 ProJDBCBidirectional Access to REST from FileMaker Pro
GoODBCWrite a Simple Go Application to work with REST on Linux
Google Apps ScriptCloud HubConnect to REST 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
NodeJSAPI ServerQuery REST from Node.js
NodeJSCloud HubQuery REST as a MySQL Database in Node.js
NodeJSJDBCQuery REST through ODBC in Node.js
PHPCloud HubAccess REST in PHP through the Cloud Hub
PHPODBCNatively Connect to REST in PHP
PowerShellPowerShellPipe REST to CSV in PowerShell
PowerBuilderADO.NETConnect to REST from PowerBuilder
PyCharmODBCUsing the CData ODBC Driver for REST in PyCharm
PythonODBCConnect to REST in Python on Linux/UNIX
RubyODBCConnect to REST in Ruby
SAP UI5API ServerIntegrate Real-Time Access to REST in SAPUI5 MVC Apps
ServoyJDBCBuild REST-Connected Apps in Servoy
SQLAlchemyPythonUse SQLAlchemy ORMs to Access REST in Python
TomcatJDBCConfigure the CData JDBC Driver for REST in a Connection Pool in Tomcat
VCL App (RAD Studio)FireDACBuild 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