REST Integration Guides and Tutorials

Ready to get started?

Learn more:

REST Connectivity Solutions

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 QuickSightFireDACBuild Interactive Dashboards from REST in Amazon QuickSight
Aqua Data StudioJDBCConnect to REST in Aqua Data Studio
BirstJDBCBuild Visualizations of REST in Birst
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 StudioFireDACCreate 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
KlipfolioFireDACCreate REST-Connected Visualizations in Klipfolio
LINQPadADO.NETWorking with REST in LINQPad
Power BI DesktopPower BIAuthor Power BI Reports on Real-Time REST
Power BI OnlineFireDACVisualize 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
TableauTableauVisualize REST in Tableau Desktop
Tableau OnlineFireDACBuild REST Visualizations in Tableau Online
Tableau ServerTableauPublish REST-Connected Dashboards in 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
EmbulkJDBCLoad REST to a Database Using Embulk
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 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
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, Transform, 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
AppSheetFireDACCreate REST-Connected Business Apps in AppSheet
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 - 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 ScriptFireDACConnect 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
NodeJSFireDACQuery REST as a MySQL Database in Node.js
NodeJSJDBCQuery REST through ODBC in Node.js
PHPFireDACAccess 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