OData
 

Connect to OData Services through easy-to-use bi-directional data drivers.


Integrate with BI, Reporting, Analytics, ETL Tools, and Custom Solutions.


"Excellent stuff. I am finally getting the hang of this and it is brilliant may I add!"

- Mark Couvaras, General Manager, Databarracks



Connect to OData Data from Anywhere!

Easily access live OData data from BI, Analytics, Reporting, ETL, & Custom Apps.







OData Integration Guides and Tutorials

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 Amazon QuickSight: Build Interactive Dashboards from OData in Amazon QuickSight 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 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 in Looker Looker Studio: Create Reports from OData in Looker Studio Metabase: Create Interactive OData-Connected Metabase Dashboards Microsoft Excel: Excel Spreadsheet Automation with the QUERY Formula Microsoft Excel 365: Access Live OData Data in Excel 365 Microsoft SSAS: Build an OLAP Cube in SSAS from OData MicroStrategy: Connect to Live OData 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 in the Power BI Service Qlik Cloud: Create Apps from OData in Qlik Sense Cloud QlikView: Connect to and Query OData in QlikView over ODBC R: Analyze OData in R (JDBC) R: Analyze OData in R (ODBC) RapidMiner: Connect to OData in RapidMiner SAP Analytics Cloud: Analyze OData 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 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 Sisense: Visualize Live OData in Sisense Spago BI: Connect to OData in SpagoBI Tableau: Visualize OData in Tableau Desktop Tableau Cloud: Build OData Visualizations in Tableau Cloud Tableau Server: Publish OData-Connected Dashboards in Tableau Server 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-Connect 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 replication — 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


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 NiFi: Bridge OData Connectivity with Apache NiFi Apache NiFi Batch Operations: Perform Batch Operations with OData Data in Apache NiFi AWS Glue: Connect to OData 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) Databricks: Automated Continuous OData Replication to Databricks 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 HULFT Integrate: Connect to OData in HULFT Integrate 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 Excel: Transfer Data from Excel to OData Microsoft Power Automate: Build OData-Connected Automated Tasks with Power Automate (Desktop) Oracle Data Integrator: ETL OData in Oracle Data Integrator petl: Extract, Transform, and Load OData in Python Replicate to CSV: 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 Snowflake: Automated Continuous OData Replication to Snowflake SQL Server Linked Server: Connect to OData as a SQL Server Linked Server 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

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


MuleSoft Anypoint: Access OData in Anypoint Using SQL Nintex Workflow Cloud: Build OData-Connected Workflows in Nintex Power Automate: Integrate OData into Power Automate Automated Tasks SSIS Export: Export Data from SQL Server to OData through SSIS SSIS Import: Import OData Data into SQL Server using SSIS SSIS Lookup: Insert New or Update Existing OData Records from SQL Server

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


.NET Charts: DataBind Charts to OData .NET QueryBuilder: Rapidly Develop OData-Driven Apps with Active Query Builder 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 ColdFusion: Query OData in ColdFusion Using JDBC ColdFusion: Query OData in ColdFusion Using ODBC Dash: Use Dash & Python to Build Web Apps on OData 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: Bidirectional Access to OData from FileMaker Pro Filemaker Pro (on Mac): Bidirectional Access to OData from FileMaker Pro (on Mac) Go: Write a Simple Go Application to work with OData on Linux Google Apps Script: Connect to OData 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 JRuby: Connect to OData in JRuby Mendix: Build OData-Connected Apps in Mendix Microsoft Power Apps: Integrate Live OData into Custom Business Apps Built in Power Apps NodeJS: Query OData in Node.js (via Connect Cloud) NodeJS: Query OData through ODBC in Node.js OutSystems: Create OData-Connected Enterprise Applications in OutSystems PHP: Natively Connect to OData in PHP PowerBuilder: Connect to OData from PowerBuilder PowerShell: Pipe OData to CSV in PowerShell PyCharm: Using the CData ODBC Driver for OData in PyCharm Python: Connect to OData in Python on Linux/UNIX Ruby: Connect to OData in Ruby RunMyProcess: Connect to OData 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.





Industry-Leading Support

Support is not just a part of our business, support is our business. Whenever you need help, please consult the resources below:

Using the OData Drivers