OData Drivers & Connectors for Data Integration

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


Decorative Icon OData Logo


BI & Analytics



Our drivers offer the fastest and easiest way to connect real-time OData data with BI, analytics, reporting and data visualization technologies. They provide unmatched query performance, comprehensive access to OData 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 OData in Alteryx Designer (ODBC) Alteryx Designer: Work with Live OData Data in Alteryx Designer (Connect Cloud) Amazon QuickSight: Build Interactive Dashboards from OData Data in Amazon QuickSight Amazon SageMaker: Integrate Live OData data into Amazon SageMaker Canvas Aqua Data Studio: Connect to OData in Aqua Data Studio AWS Databricks: Process & Analyze OData Data in Databricks (AWS) Azure Analysis Services: Model OData Data Using Azure Analysis Services Birst: Build Visualizations of OData in Birst BIRT: Design BIRT Reports on OData Clear Analytics: Build Charts with OData in Clear Analytics Cognos Analytics (On-Prem): Analyze OData Data in Cognos Analytics DBxtra: Build Dashboards with OData in DBxtra Domo: Create Datasets from OData in Domo Workbench Dundas BI: Build Dashboards with OData in Dundas BI Excel (on Mac OS): Work with OData Data in MS Excel on Mac OS X FineReport: Feed OData into FineReport Google Sheets: Access Live OData Data in Google Sheets IBM Cognos BI: Create Data Visualizations in Cognos BI with OData Infragistics Reveal: Analyze OData Data in Infragistics Reval JasperServer: Create OData Reports on JasperReports Server Jaspersoft BI Suite: Connect to OData in Jaspersoft Studio JReport Designer: Integrate with OData in JReport Designer Klipfolio: Create OData-Connected Visualizations in Klipfolio KNIME: Enable the OData JDBC Driver in KNIME LINQPad: Working with OData in LINQPad Looker: Analyze OData Data in Looker Looker Studio: Create Reports from OData Data in Looker Studio Metabase: Create Interactive OData-Connected Metabase Dashboards Microsoft Excel: Access Live OData Data in Excel Desktop Microsoft Excel for the Web: Access Live OData Data in Excel for the Web Microsoft SSAS: Build an OLAP Cube in SSAS from OData MicroStrategy: Connect to Live OData Data in MicroStrategy through Connect Cloud MicroStrategy: Use the CData JDBC Driver for OData in MicroStrategy Microstrategy Desktop: Use the CData JDBC Driver for OData in MicroStrategy Desktop Microstrategy Web: Use the CData JDBC Driver for OData in MicroStrategy Web Mode Analytics: Create OData-Connected Visualizations in Mode OBIEE: OData Reporting in OBIEE with the OData JDBC Driver pandas: Use pandas to Visualize OData in Python Pentaho Report Designer: Integrate OData in the Pentaho Report Designer Power BI Desktop: Author Power BI Reports on Real-Time OData Power BI Service: Visualize Live OData Data in the Power BI Service Qlik Cloud: Create Apps from OData Data in Qlik Sense Cloud R: Analyze OData in R (JDBC) RapidMiner: Connect to OData in RapidMiner Redash: Query, Visualize, and Share live OData Data in Redash SAP Analytics Cloud: Analyze OData Data in SAP Analytics Cloud SAP Business Objects: Create an SAP BusinessObjects Universe on the CData JDBC Driver for OData SAP Crystal Reports: Publish Reports with OData in Crystal Reports (Connect Cloud) SAS: Use the CData ODBC Driver for OData in SAS for Real-Time Reporting and Analytics SAS JMP: Use the CData ODBC Driver for OData in SAS JMP SAS Viya: Analyze Live OData Data in SAS Viya Sisense: Visualize Live OData in Sisense Spago BI: Connect to OData in SpagoBI Tableau: Visualize OData in Tableau Desktop Tableau: Visualize OData in Tableau Desktop (Connect Cloud) Tableau Cloud: Build OData Visualizations in Tableau Cloud Tableau Server: Publish OData-Connected Dashboards in Tableau Server ThoughtSpot: Model, Search, and Visualize Live OData Data in ThoughtSpot TIBCO Spotfire: Visualize OData in TIBCO Spotfire through ADO.NET TIBCO Spotfire Server: Operational Reporting on OData from Spotfire Server Visio: Link Visio Shapes to OData Zoho Analytics: Create OData-Connected Dashboards in Zoho Analytics

ETL, Replication, & Warehousing



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

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


Popular Data Warehousing Integrations



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

Workflow & Automation Tools



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

Our drivers and adapters provide straightforward access to OData 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 OData from anywhere. Our OData drivers offer a data-centric model for OData 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 OData Data in AWS Lambda Axios: Build OData-Connected Web Apps with Axios and CData Connect Cloud .NET Charts: DataBind Charts to OData .NET QueryBuilder: Rapidly Develop OData-Driven Apps with Active Query Builder Angular JS: Using AngularJS to Build Dynamic Web Pages with OData Apache Spark: Work with OData in Apache Spark Using SQL AppSheet: Create OData-Connected Business Apps in AppSheet Bubble.io: Build OData-Connected Apps in Bubble Choreo: Build Custom Apps on OData Data in Choreo Dash: Use Dash & Python to Build Web Apps on OData Delphi: DataBind Controls to OData Data in Delphi DevExpress: DataBind OData to the DevExpress Data Grid EF - Code First: Access OData with Entity Framework 6 EF - LINQ: LINQ to OData EF - MVC: Build MVC Applications with Connectivity to OData Filemaker Pro (on Mac): Bidirectional Access to OData from FileMaker Pro (on Mac) Google Apps Script: Connect to OData Data in Google Apps Script Hibernate: Object-Relational Mapping (ORM) with OData Entities in Java IntelliJ: Connect to OData in IntelliJ JBoss: Connect to OData from a Connection Pool in JBoss JDBI: Create a Data Access Object for OData using JDBI Jitterbit: Integrate with Live OData Data in Jitterbit JRuby: Connect to OData in JRuby Mendix: Build OData-Connected Apps in Mendix (Connect Cloud) Mendix: Build OData-Connected Apps in Mendix (JDBC) Microsoft Power Apps: Integrate Live OData Data into Custom Business Apps Built in Power Apps NodeJS: Query OData Data in Node.js (via Connect Cloud) NodeJS: Query OData through ODBC in Node.js OutSystems: Create OData-Connected Enterprise Applications in OutSystems PHP: Access OData in PHP through Connect Server PHP: Natively Connect to OData in PHP PowerBuilder: Connect to OData from PowerBuilder PowerShell: Pipe OData to CSV in PowerShell React: Build Dynamic React Apps with OData Data Ruby: Connect to OData in Ruby RunMyProcess: Connect to OData Data in RunMyProcess RunMyProcess DSEC: Connect to OData in DigitalSuite Studio through RunMyProcess DSEC Servoy: Build OData-Connected Apps in Servoy Spring Boot: Access Live OData Data in Spring Boot Apps SQLAlchemy: Use SQLAlchemy ORMs to Access OData in Python Tomcat: Configure the CData JDBC Driver for OData in a Connection Pool in Tomcat Unqork: Create OData-Connected Applications in Unqork VCL App (RAD Studio): Build a Simple VCL Application for OData WebLogic: Connect to OData from a Connection Pool in WebLogic


When Only the Best OData Drivers Will Do

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



Frequently Asked OData Driver Questions

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


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

Working with a OData Driver is different than connecting with OData through other means. OData 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 OData integration code moving forward.

By comparison, our OData Drivers offer codeless access to live OData data for both technical and non-technical users alike. Any user can install our drivers and begin working with live OData 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 OData data. We manage all of the complexities of OData integration within each driver and deploy updated drivers as systems evolve so your applications continue to run seamlessly.

If you need truly zero-maintenance integration, check out connectivity to OData via CData Connect Cloud. With Connect Cloud you can configure all of your data connectivity in one place and connect to OData from any of the available Cloud Drivers and Client Applications. Connectivity to OData is managed in the cloud, and you never have to worry about installing new drivers when OData is updated.

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 OData, 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 OData driver offers full-featured OData data connectivity. The CData OData drivers support extensive OData integration, providing access to all of the OData 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 OData 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 OData driver contains a full SQL-92 compliant engine that translates standard SQL queries into OData API calls dynamically. Queries are parsed and optimized for each data source, pushing down as much of the request to OData as possible. Any logic that can not be pushed to OData is handled transparently client-side by the driver/connector engine. Ultimately, this means that OData looks and acts exactly like a database to any client application or tool. Users can integrate live OData connectivity with ANY software solution that can talk to a standard database.

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

Using the CData OData drivers and connectors, OData 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 OData data connectivity. Explore some of the more popular OData data integrations online.

Additionally, since OData supported by CData Connect Cloud, we enable all kinds of new OData cloud integrations.

OData Analytics and OData Cloud BI integration 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 OData 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.

OData 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 OData data any database or data warehouse, and maintain parity between systems with automated incremental OData replication. In addition, our OData drivers and connectors can be easily embedded into a wide range of data integration tools to augment existing solutions.

Absolutely. The best way to integrate OData with Excel is by using the CData Connect Cloud Excel Add-In. The OData Excel Add-In provides easy OData integration directly from Microsoft Excel Desktop, Mac, or Web (Excel 365). Simply configure your connection to OData from the easy-to-use cloud interface, and access OData just like you would another native Excel data source.