BI & Analytics

---

Our drivers offer the fastest and easiest way to connect real-time Excel data with BI, analytics, reporting and data visualization technologies. They provide unmatched query performance, comprehensive access to Excel 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 Excel in Alteryx Designer Amazon QuickSight: Build Interactive Dashboards from Excel in Amazon QuickSight Aqua Data Studio: Connect to Excel in Aqua Data Studio Birst: Build Visualizations of Excel in Birst BIRT: Design BIRT Reports on Excel Clear Analytics: Build Charts with Excel in Clear Analytics Microsoft Excel: Excel Spreadsheet Automation with the QUERY Formula DBxtra: Build Dashboards with Excel in DBxtra Domo: Create Datasets from Excel in Domo Workbench Dundas BI: Build Dashboards with Excel in Dundas BI FineReport: Feed Excel into FineReport Google Data Studio: Create Reports from Excel in Google Data Studio IBM Cognos BI: Create Data Visualizations in Cognos BI with Excel JasperServer: Create Excel Reports on JasperReports Server Jaspersoft BI Suite: Connect to Excel in Jaspersoft Studio JReport Designer: Integrate with Excel in JReport Designer KNIME: Enable the Excel JDBC Driver in KNIME LINQPad: Working with Excel in LINQPad Power BI Desktop: Author Power BI Reports on Real-Time Excel Power BI Online: Visualize Live Excel in the Power BI Service Microsoft SSAS: Build an OLAP Cube in SSAS from Excel MicroStrategy: Use the CData JDBC Driver for Excel in MicroStrategy OBIEE: Excel Reporting in OBIEE with the Excel JDBC Driver Pentaho Report Designer: Integrate Excel in the Pentaho Report Designer QlikView: Connect to and Query Excel in QlikView over ODBC R: Analyze Excel in R RapidMiner : Connect to Excel in RapidMiner SAP Business Objects: Create an SAP BusinessObjects Universe on the CData JDBC Driver for Excel SAP Crystal Reports: Publish Reports with Excel in Crystal Reports SAP Lumira: Consume Excel OData Feeds in SAP Lumira SAS: Use the CData ODBC Driver for Excel in SAS for Real-Time Reporting and Analytics Sisense: Visualize Live Excel in Sisense Spago BI: Connect to Excel in SpagoBI Tableau: Visualize Excel in Tableau Tableau Online: Build Excel Visualizations in Tableau Online Tableau Server: Publish and Share Excel Dashboards with Tableau Server TIBCO Spotfire: Visualize Excel in TIBCO Spotfire through ADO.NET TIBCO Spotfire Server: Operational Reporting on Excel from Spotfire Server Visio: Link Visio Shapes to Excel

ETL, Replication, & Warehousing

---

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

Connect your RDBMS or data warehouse with Excel 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 Excel Replication to Amazon Redshift Amazon S3: Automated Continuous Excel Replication to Amazon S3 Apache Cassandra: Automated Continuous Excel Replication to Apache Cassandra AWS Glue: Connect to Excel in AWS Glue Jobs Using JDBC BIML: Use Biml to Build SSIS Tasks to Replicate Excel to SQL Server CloverDX: Connect to Excel in CloverDX (formerly CloverETL) CSV: Automated Continuous Excel Replication to Local Delimited Files IBM DB2: Automated Continuous Excel Replication to IBM DB2 FoxPro: Work with Excel in FoxPro Google BigQuery: Automated Continuous Excel Replication to Google BigQuery Google Cloud SQL: Automated Continuous Excel Replication to Google Cloud SQL Google Data Fusion: Pipe Excel in Google Data Fusion Heroku / Salesforce Connect: Replicate Excel for Use in Salesforce Connect Informatica Cloud: Integrate Excel in Your Informatica Cloud Instance Informatica PowerCenter: Create Informatica Mappings From/To a JDBC Data Source for Excel Jaspersoft ETL: Connect to Excel in Jaspersoft Studio Microsoft Access: Automated Continuous Excel Replication to Microsoft Access Microsoft Azure Tables: Automated Continuous Excel Replication to Azure SQL Microsoft Excel: Transfer Data from Excel to Excel MongoDB: Automated Continuous Excel Replication to MongoDB MySQL: Automated Continuous Excel Replication to MySQL Oracle Data Integrator: ETL Excel in Oracle Data Integrator Oracle Database: Automated Continuous Excel Replication to Oracle PostgreSQL: Automated Continuous Excel Replication to PostgreSQL Replicate to CSV: Replicate Excel to MySQL with PowerShell Snowflake: Automated Continuous Excel Replication to Snowflake SQL Server: Automated Continuous Excel Replication to SQL Server SQLite: Automated Continuous Excel Replication to SQLite Talend: Connect to Excel and Transfer Data in Talend UiPath Studio: Create an RPA Flow that Connects to Excel in UiPath Studio

Data Management

---

By supporting popular database protocols like ODBC, JDBC, and ADO.NET, as well as wire-protocol interfaces for SQL Server and MySQL, it is easy to connect to and manage Excel data from a wide range of database management applications.

Popular Data Management Tool Integrations

---

DBeaver: Connect to Excel in DBeaver DbVisualizer: Connect to Excel in DBVisualizer DB Artisan: Manage Excel in DBArtisan as a JDBC Source DB Artisan: Connect to Excel in DBArtisan Informatica Enterprise Data Catalog: Add Excel to Informatica Enterprise Data Catalog MySQL Workbench: Query Excel in MySQL Workbench RazorSQL: Connect to Excel in RazorSQL SQuirreL: Connect to Excel in Squirrel SQL Client

Workflow & Automation Tools

---

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

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

Popular Workflow & Automation Tool Integrations

---

BizTalk: How to Generate SQL Command Schemas for the CData BizTalk Adapter for Excel BizTalk: Configure a One-Way Send Port for the CData BizTalk Adapter for Excel BizTalk: Configure a CData Excel Adapter Receive Location BizTalk: Configure a Solicit-Response Send Port for Excel Microsoft Flow: Automate Tasks in Microsoft Flow Using API Server Microsoft Flow: Integrate Excel into MS Flow Automated Tasks Microsoft PowerApps: Design Excel Power Apps Microsoft PowerApps: Integrate Live Excel into Custom Business Apps Built in PowerApps MuleSoft Anypoint: Access Excel in Anypoint Using SQL SSIS Export: Export Data from SQL Server to Excel through SSIS SSIS Import: Import Excel Data into SQL Server using SSIS SSIS Lookup: Insert New or Update Existing Excel Records from SQL Server MuleSoft Anypoint: Deploy CData Mule Connectors (On-Premise or Cloud)

Developer Tools & Technologies

---

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

• Pragmatic API Integration: from SDKs to Data Drivers
• Data APIs: Gateway to Data Driven Operation & Digital Transformation

Popular Developer Integrations

---

.NET Charts: DataBind Charts to Excel .NET QueryBuilder: Rapidly Develop Excel-Driven Apps with Active Query Builder Angular JS: Using AngularJS to Build Dynamic Web Pages with Excel Apache Spark: Work with Excel in Apache Spark Using SQL Microsoft Azure Logic Apps: Trigger Excel IFTTT Flows in Azure App Service ColdFusion: Query Excel in ColdFusion DevExpress: DataBind Excel to the DevExpress Data Grid EF - Code First: Access Excel with Entity Framework 6 EF - LINQ: LINQ to Excel EF - MVC: Build MVC Applications with Connectivity to Excel Filemaker Pro: Bidirectional Access to Excel from FileMaker Pro Go: Write a Simple Go Application to work with Excel on Linux Google Apps Script: Connect to Excel in Google Apps Script Hibernate: Object-Relational Mapping (ORM) with Excel Entities in Java IntelliJ: Connect to Excel in IntelliJ JBoss: Connect to Excel from a Connection Pool in JBoss JDBI: Create a Data Access Object for Excel using JDBI JRuby: Connect to Excel in JRuby NodeJS: Query Excel from Node.js NodeJS: Query Excel as a MySQL Database in Node.js PHP: Access Excel in PHP through the Cloud Hub PHP: Natively Connect to Excel in PHP PowerShell: Pipe Excel to CSV in PowerShell PowerBuilder: Connect to Excel from PowerBuilder PyCharm: Using the CData ODBC Driver for Excel in PyCharm Python: Connect to Excel in Python on Linux/UNIX Ruby: Connect to Excel in Ruby SAP UI5: Integrate Real-Time Access to Excel in SAPUI5 MVC Apps Tomcat: Configure the CData JDBC Driver for Excel in a Connection Pool in Tomcat VCL App (RAD Studio): Build a Simple VCL Application for Excel WebLogic: Connect to Excel from a Connection Pool in WebLogic

Data Virtualization

---

Our drivers provide a virtual database abstraction on top of Excel data and support popular data virtualization features like query federation through advanced capabilities for query delegation / predicate pushdown.

Learn more about how our tools can be used in popular data virtualization scenarios below:

Popular Data Virtualization Tool Integrations

---

Access Linked Tables: Update Excel with a Microsoft Access Linked Table MySQL Federated Tables: Connect to Excel as Federated Tables in MySQL MySQL Federated Tables: Connect to Excel as Federated Tables in MySQL Oracle Database: Access Excel as a Remote Oracle Database PostgreSQL FDW: A PostgreSQL Interface for Excel Salesforce Connect: Edit and Search Excel External Objects SharePoint External List: Access Excel in SharePoint External Lists SQL Server Linked Servers: Connect to Excel as a Linked Server SQL Server PolyBase: Connect to Excel as an External Data Source using PolyBase