SharePoint Excel Services Drivers & Connectors
for Data Integration

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


Decorative Icon SharePoint Excel Services Logo


Other Microsoft Excel Technologies



BI & Analytics



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

ETL, Replication, & Warehousing



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

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

Workflow & Automation Tools



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

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


When Only the Best SharePoint Excel Services Drivers Will Do

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



Frequently Asked SharePoint Excel Services Driver Questions

Learn more about SharePoint Excel Services drivers & connectors for data and analytics integration


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

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

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

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

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

SharePoint Excel Services 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 SharePoint Excel Services 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.

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