REST Drivers & Connectors for Data Integration

Connect to REST Services through easy-to-use bi-directional data drivers. Easily integrate REST data with BI, Reporting, Analytics, ETL Tools, and Custom Solutions.


Decorative Icon REST Logo


BI & Analytics



Our drivers offer the fastest and easiest way to connect real-time REST data with BI, analytics, reporting and data visualization technologies. They provide unmatched query performance, comprehensive access to REST data and metadata, and seamlessly integrate with your favorite analytics tools.

LEARN MORE: Connectivity for BI & Analytics

Popular BI & Analytics Integrations



Alteryx Designer: Prepare, Blend, and Analyze REST in Alteryx Designer (ODBC) Amazon QuickSight: Build Interactive Dashboards from REST Data in Amazon QuickSight Aqua Data Studio: Connect to REST in Aqua Data Studio AWS Databricks: Process & Analyze REST Data in Databricks (AWS) Birst: Build Visualizations of REST in Birst BIRT: Design BIRT Reports on REST Clear Analytics: Build Charts with REST in Clear Analytics DBxtra: Build Dashboards with REST in DBxtra Domo: Create Datasets from REST in Domo Workbench Dundas BI: Build Dashboards with REST in Dundas BI Excel (on Mac OS): Work with REST Data in MS Excel on Mac OS X FineReport: Feed REST into FineReport IBM Cognos BI: Create Data Visualizations in Cognos BI with REST Infragistics Reveal: Analyze REST Data in Infragistics Reval JasperServer: Create REST Reports on JasperReports Server Jaspersoft BI Suite: Connect to REST in Jaspersoft Studio JReport Designer: Integrate with REST in JReport Designer Klipfolio: Create REST-Connected Visualizations in Klipfolio KNIME: Enable the REST JDBC Driver in KNIME LINQPad: Working with REST in LINQPad Microsoft SSAS: Build an OLAP Cube in SSAS from REST MicroStrategy: Connect to Live REST Data in MicroStrategy through Connect Server MicroStrategy: Use the CData JDBC Driver for REST in MicroStrategy Microstrategy Desktop: Use the CData JDBC Driver for REST in MicroStrategy Desktop Microstrategy Web: Use the CData JDBC Driver for REST in MicroStrategy Web OBIEE: REST Reporting in OBIEE with the REST JDBC Driver pandas: Use pandas to Visualize REST in Python Pentaho Report Designer: Integrate REST in the Pentaho Report Designer Power BI Desktop: Author Power BI Reports on Real-Time REST Power BI Service: Visualize Live REST Data in the Power BI Service Power Pivot: Access REST Data in Microsoft Power Pivot Power Query: Access REST Data in Microsoft Power Query Qlik Cloud: Create Apps from REST Data in Qlik Sense Cloud QlikView: Connect to and Query REST in QlikView over ODBC R: Analyze REST in R (JDBC) R: Analyze REST in R (ODBC) RapidMiner: Connect to REST in RapidMiner Redash: Query, Visualize, and Share live REST Data in Redash SAP Analytics Cloud: Analyze REST Data in SAP Analytics Cloud SAP Business Objects: Create an SAP BusinessObjects Universe on the CData JDBC Driver for REST SAP Crystal Reports: Publish Reports with REST in Crystal Reports (JDBC) SAS: Use the CData ODBC Driver for REST in SAS for Real-Time Reporting and Analytics SAS JMP: Use the CData ODBC Driver for REST in SAS JMP Sisense: Visualize Live REST in Sisense Spago BI: Connect to REST in SpagoBI Tableau: Visualize REST in Tableau Desktop Tableau: Visualize REST in Tableau Desktop (Connect Server) Tableau Cloud: Build REST Visualizations in Tableau Cloud Tableau Server: Publish REST-Connected Dashboards in Tableau Server TIBCO Spotfire: Visualize REST in TIBCO Spotfire through ADO.NET TIBCO Spotfire: Visualize REST Data in TIBCO Spotfire TIBCO Spotfire Server: Operational Reporting on REST from Spotfire Server Visio: Link Visio Shapes to REST

ETL, Replication, & Warehousing



From drivers and adapters that extend your favorite ETL tools with REST connectivity to ETL/ELT tools for REST data integration — our REST integration solutions provide robust, reliable, and secure data movement.

Connect your RDBMS or data warehouse with REST to facilitate operational reporting, offload queries and increase performance, support data governance initiatives, archive data for disaster recovery, and more.


Popular Data Warehousing Integrations



Amazon Redshift: Automated Continuous REST Replication to Amazon Redshift Amazon S3: Automated Continuous REST Replication to Amazon S3 Apache Airflow: Bridge REST Connectivity with Apache Airflow Apache Camel: Integrate with REST using Apache Camel Apache Cassandra: Automated Continuous REST Replication to Apache Cassandra Apache Kafka: Automated Continuous REST Replication to Apache Kafka Apache NiFi: Bridge REST Connectivity with Apache NiFi Apache NiFi Batch Operations: Perform Batch Operations with REST Data in Apache NiFi Azure Data Lake: Automated Continuous REST Replication to Azure Data Lake Azure Synapse: Automated Continuous REST Replication to Azure Synapse BIML: Use Biml to Build SSIS Tasks to Replicate REST to SQL Server CloverDX: Connect to REST in CloverDX (formerly CloverETL) Couchbase: Automated Continuous REST Replication to Couchbase CSV: Automated Continuous REST Replication to Local Delimited Files Databricks: Automated Continuous REST Replication to Databricks ETL Validator: How to Work with REST in ETL Validator FoxPro: Work with REST in FoxPro Google AlloyDB: Automated Continuous REST Replication to Google AlloyDB Google BigQuery: Automated Continuous REST Replication to Google BigQuery Google Cloud SQL: Automated Continuous REST Replication to Google Cloud SQL Google Data Fusion: Build REST-Connected ETL Processes in Google Data Fusion Heroku / Salesforce Connect: Replicate REST for Use in Salesforce Connect HULFT Integrate: Connect to REST in HULFT Integrate IBM DB2: Automated Continuous REST Replication to IBM DB2 Informatica Cloud: Integrate REST in Your Informatica Cloud Instance Informatica PowerCenter: Create Informatica Mappings From/To a JDBC Data Source for REST Jaspersoft ETL: Connect to REST in Jaspersoft Studio Microsoft Access: Automated Continuous REST Replication to Microsoft Access Microsoft Azure Tables: Automated Continuous REST Replication to Azure SQL Microsoft Excel: Transfer Data from Excel to REST Microsoft Power Automate: Build REST-Connected Automated Tasks with Power Automate (Desktop) MongoDB: Automated Continuous REST Replication to MongoDB MySQL: Automated Continuous REST Replication to MySQL Oracle Data Integrator: ETL REST in Oracle Data Integrator Oracle Database: Automated Continuous REST Replication to Oracle petl: Extract, Transform, and Load REST in Python PostgreSQL: Automated Continuous REST Replication to PostgreSQL SAP HANA: Automated Continuous REST Replication to SAP HANA SingleStore: Automated Continuous REST Replication to SingleStore SnapLogic: Integrate REST with External Services using SnapLogic (JDBC) Snowflake: Automated Continuous REST Replication to Snowflake SQL Server: Automated Continuous REST Replication to SQL Server SQL Server Linked Server: Connect to REST Data as a SQL Server Linked Server SQLite: Automated Continuous REST Replication to SQLite Talend: Connect to REST and Transfer Data in Talend UiPath Studio: Create an RPA Flow that Connects to REST in UiPath Studio Vertica: Automated Continuous REST Replication to a Vertica Database

Workflow & Automation Tools



Connect to REST from popular data migration, ESB, iPaaS, and BPM tools.

Our drivers and adapters provide straightforward access to REST data from popular applications like BizTalk, MuleSoft, SQL SSIS, Microsoft Flow, Power Apps, Talend, and many more.

Popular Workflow & Automation Tool Integrations



Developer Tools & Technologies



The easiest way to integrate with REST from anywhere. Our REST drivers offer a data-centric model for REST that dramatically simplifies integration — allowing developers to build higher quality applications, faster than ever before. Learn more about the benefits for developers:



Popular Developer Integrations



AWS Lambda: Access Live REST Data in AWS Lambda .NET Charts: DataBind Charts to REST .NET QueryBuilder: Rapidly Develop REST-Driven Apps with Active Query Builder Angular JS: Using AngularJS to Build Dynamic Web Pages with REST Apache Spark: Work with REST in Apache Spark Using SQL AppSheet: Create REST-Connected Business Apps in AppSheet C++Builder: DataBind Controls to REST Data in C++Builder ColdFusion: Query REST in ColdFusion Using JDBC ColdFusion: Query REST in ColdFusion Using ODBC Dash: Use Dash & Python to Build Web Apps on REST Delphi: DataBind Controls to REST Data in Delphi DevExpress: DataBind REST to the DevExpress Data Grid EF - Code First: Access REST with Entity Framework 6 EF - LINQ: LINQ to REST EF - MVC: Build MVC Applications with Connectivity to REST Filemaker Pro: Bidirectional Access to REST from FileMaker Pro Filemaker Pro (on Mac): Bidirectional Access to REST from FileMaker Pro (on Mac) Go: Write a Simple Go Application to work with REST on Linux Google Apps Script: Connect to REST Data in Google Apps Script Hibernate: Object-Relational Mapping (ORM) with REST Entities in Java IntelliJ: Connect to REST in IntelliJ JBoss: Connect to REST from a Connection Pool in JBoss JDBI: Create a Data Access Object for REST using JDBI JRuby: Connect to REST in JRuby Mendix: Build REST-Connected Apps in Mendix (JDBC) Microsoft Power Apps: Integrate Live REST Data into Custom Business Apps Built in Power Apps NodeJS: Query REST Data in Node.js (via Connect Server) NodeJS: Query REST through ODBC in Node.js PHP: Access REST in PHP through Connect Server PHP: Natively Connect to REST in PHP PowerBuilder: Connect to REST from PowerBuilder PyCharm: Using the CData ODBC Driver for REST in PyCharm Python: Connect to REST in Python on Linux/UNIX React: Build Dynamic React Apps with REST Data Ruby: Connect to REST in Ruby RunMyProcess: Connect to REST Data in RunMyProcess RunMyProcess DSEC: Connect to REST in DigitalSuite Studio through RunMyProcess DSEC SAP UI5: Integrate Real-Time Access to REST in SAPUI5 MVC Apps Servoy: Build REST-Connected Apps in Servoy Spring Boot: Access Live REST Data in Spring Boot Apps SQLAlchemy: Use SQLAlchemy ORMs to Access REST in Python Tomcat: Configure the CData JDBC Driver for REST in a Connection Pool in Tomcat Unqork: Create REST-Connected Applications in Unqork VCL App (RAD Studio): Build a Simple VCL Application for REST WebLogic: Connect to REST from a Connection Pool in WebLogic


When Only the Best REST Drivers Will Do

See what customers have to say about our products and support.



Frequently Asked REST Driver Questions

Learn more about REST drivers & connectors for data and analytics integration


The REST driver acts like a bridge that facilitates communication between various applications and REST, allowing the application to read data as if it were a relational database. The REST driver abstracts the complexities of REST APIs, authentication methods, and data types, making it simple for any application to connect to REST data in real-time via standard SQL queries.

Working with a REST Driver is different than connecting with REST through other means. REST API integrations require technical experience from a software developer or IT resources. Additionally, due to the constant evolution of APIs and services, once you build your integration you have to constantly maintain REST integration code moving forward.

By comparison, our REST Drivers offer codeless access to live REST data for both technical and non-technical users alike. Any user can install our drivers and begin working with live REST data from any client application. Because our drivers conform to standard data interfaces like ODBC, JDBC, ADO.NET etc. they offer a consistent, maintenance-free interface to REST data. We manage all of the complexities of REST integration within each driver and deploy updated drivers as systems evolve so your applications continue to run seamlessly.

Many organizations draw attention to their library of connectors. After all, data connectivity is a core capability needed for applications to maximize their business value. However, it is essential to understand exactly what you are getting when evaluating connectivity. Some vendors are happy to offer connectors that implement basic proof-of-concept level connectivity. These connectors may highlight the possibilities of working with REST, but often only provide a fraction of capability. Finding real value from these connectors usually requires additional IT or development resources.

Unlike these POC-quality connectors, every CData REST driver offers full-featured REST data connectivity. The CData REST drivers support extensive REST integration, providing access to all of the REST data and meta-data needed by enterprise integration or analytics projects. Each driver contains a powerful embedded SQL engine that offers applications easy and high-performance access to all REST data. In addition, our drivers offer robust authentication and security capabilities, allowing users to connect securely across a wide range of enterprise configurations. Compare drivers and connectors to read more about some of the benefits of CData's driver connectivity.

With our drivers and connectors, every data source is essentially SQL-based. The CData REST driver contains a full SQL-92 compliant engine that translates standard SQL queries into REST API calls dynamically. Queries are parsed and optimized for each data source, pushing down as much of the request to REST as possible. Any logic that can not be pushed to REST is handled transparently client-side by the driver/connector engine. Ultimately, this means that REST looks and acts exactly like a database to any client application or tool. Users can integrate live REST connectivity with ANY software solution that can talk to a standard database.

The REST drivers and connectors offer comprehensive access to REST data. Our REST driver exposes static and dynamic data and metadata, providing universal access to REST data for any enterprise analytics or data mangement use. To explore the REST driver data model, please review the edition-specific REST driver documentation.

Using the CData REST drivers and connectors, REST can be easily integrated with almost any application. Any software or technology that can integrate with a database or connect with standards-based drivers like ODBC, JDBC, ADO.NET, etc., can use our drivers for live REST data connectivity. Explore some of the more popular REST data integrations online.

REST Analytics is universally supported for BI and data science. In addition, CData provides native client connectors for popular analytics applications like Power BI, Tableau, and Excel that simplify REST data integration. Additionally, native Python connectors are widely available for data science and data engineering projects that integrate seamlessly with popular tools like Pandas, SQLAlchemy, Dash, and Petl.

REST data integration is typically enabled with CData Sync, a robust any-to-any data pipeline solution that is easy to set up, runs everywhere, and offers comprehensive enterprise-class features for data engineering. CData Sync makes it easy to replicate REST data any database or data warehouse, and maintain parity between systems with automated incremental REST replication. In addition, our REST drivers and connectors can be easily embedded into a wide range of data integration tools to augment existing solutions.

Absolutely. CData offers native Excel Add-Ins for REST integration. These Add-Ins provide live access to REST data directly from Microsoft Excel.