Learn more
 

Ready to get started?

Learn more:

SharePoint Excel Services Connectivity Solutions

In this article

Related articles

SharePoint Excel Services Integration Guides and Tutorials


A list of guides and tutorials for connecting to and working with live SharePoint Excel Services data.

CData Software's connectivity tools enable users to connect directly to live SharePoint Excel Services data data from widely-used BI, analytics, ETL, and custom applications, ensuring that our customers can access their data wherever they desire. Below, you'll find a collection of guides and tutorials on integrating with live SharePoint Excel Services data.

Integration Use-Cases

Click below to jump to articles related to specific integration use-case.

Business Intelligence & Analytics


ProductTechnologyArticle Title
Alteryx DesignerODBCPrepare, Blend, and Analyze SharePoint Excel Services in Alteryx Designer (ODBC)
Amazon QuickSightConnect ServerBuild Interactive Dashboards from SharePoint Excel Services Data in Amazon QuickSight
Aqua Data StudioJDBCConnect to SharePoint Excel Services in Aqua Data Studio
AWS DatabricksJDBCProcess & Analyze SharePoint Excel Services Data in Databricks (AWS)
BirstJDBCBuild Visualizations of SharePoint Excel Services in Birst
BIRTJDBCDesign BIRT Reports on SharePoint Excel Services
Clear AnalyticsODBCBuild Charts with SharePoint Excel Services in Clear Analytics
DBxtraODBCBuild Dashboards with SharePoint Excel Services in DBxtra
DomoODBCCreate Datasets from SharePoint Excel Services in Domo Workbench
Dundas BIODBCBuild Dashboards with SharePoint Excel Services in Dundas BI
Excel (on Mac OS)ODBCWork with SharePoint Excel Services Data in MS Excel on Mac OS X
FineReportJDBCFeed SharePoint Excel Services into FineReport
IBM Cognos BIODBCCreate Data Visualizations in Cognos BI with SharePoint Excel Services
Infragistics RevealConnect ServerAnalyze SharePoint Excel Services Data in Infragistics Reval
JasperServerJDBCCreate SharePoint Excel Services Reports on JasperReports Server
Jaspersoft BI SuiteJDBCConnect to SharePoint Excel Services in Jaspersoft Studio
JReport DesignerJDBCIntegrate with SharePoint Excel Services in JReport Designer
KlipfolioConnect ServerCreate SharePoint Excel Services-Connected Visualizations in Klipfolio
KNIMEJDBCEnable the SharePoint Excel Services JDBC Driver in KNIME
LINQPadADO.NETWorking with SharePoint Excel Services in LINQPad
Microsoft SSASADO.NETBuild an OLAP Cube in SSAS from SharePoint Excel Services
MicroStrategyConnect ServerConnect to Live SharePoint Excel Services Data in MicroStrategy through Connect Server
MicroStrategyJDBCUse the CData JDBC Driver for SharePoint Excel Services in MicroStrategy
Microstrategy DesktopJDBCUse the CData JDBC Driver for SharePoint Excel Services in MicroStrategy Desktop
Microstrategy WebJDBCUse the CData JDBC Driver for SharePoint Excel Services in MicroStrategy Web
OBIEEJDBCSharePoint Excel Services Reporting in OBIEE with the SharePoint Excel Services JDBC Driver
pandasPythonUse pandas to Visualize SharePoint Excel Services in Python
Pentaho Report DesignerJDBCIntegrate SharePoint Excel Services in the Pentaho Report Designer
Power BI DesktopPower BIAuthor Power BI Reports on Real-Time SharePoint Excel Services
Power BI ServiceConnect ServerVisualize Live SharePoint Excel Services Data in the Power BI Service
Power PivotConnect ServerAccess SharePoint Excel Services Data in Microsoft Power Pivot
Power QueryConnect ServerAccess SharePoint Excel Services Data in Microsoft Power Query
Qlik CloudConnect ServerCreate Apps from SharePoint Excel Services Data in Qlik Sense Cloud
QlikViewODBCConnect to and Query SharePoint Excel Services in QlikView over ODBC
RJDBCAnalyze SharePoint Excel Services in R (JDBC)
RODBCAnalyze SharePoint Excel Services in R (ODBC)
RapidMinerJDBCConnect to SharePoint Excel Services in RapidMiner
RedashConnect ServerBuild SharePoint Excel Services-Connected Dashboards in Redash
SAP Analytics CloudConnect ServerAnalyze SharePoint Excel Services Data in SAP Analytics Cloud
SAP Business ObjectsJDBCCreate an SAP BusinessObjects Universe on the CData JDBC Driver for SharePoint Excel Services
SAP Crystal ReportsJDBCPublish Reports with SharePoint Excel Services in Crystal Reports
SASODBCUse the CData ODBC Driver for SharePoint Excel Services in SAS for Real-Time Reporting and Analytics
SAS JMPODBCUse the CData ODBC Driver for SharePoint Excel Services in SAS JMP
SisenseJDBCVisualize Live SharePoint Excel Services in Sisense
Spago BIJDBCConnect to SharePoint Excel Services in SpagoBI
TableauTableauVisualize SharePoint Excel Services in Tableau Desktop
Tableau CloudConnect ServerBuild SharePoint Excel Services Visualizations in Tableau Cloud
Tableau ServerTableauPublish SharePoint Excel Services-Connected Dashboards in Tableau Server
TIBCO SpotfireADO.NETVisualize SharePoint Excel Services in TIBCO Spotfire through ADO.NET
TIBCO SpotfireConnect ServerVisualize SharePoint Excel Services Data in TIBCO Spotfire
TIBCO Spotfire ServerJDBCOperational Reporting on SharePoint Excel Services from Spotfire Server
VisioODBCLink Visio Shapes to SharePoint Excel Services

Back to top

ETL & Replication


ProductTechnologyArticle Title
Amazon RedshiftCData SyncAutomated Continuous SharePoint Excel Services Replication to Amazon Redshift
Amazon S3CData SyncAutomated Continuous SharePoint Excel Services Replication to Amazon S3
Apache AirflowJDBCBridge SharePoint Excel Services Connectivity with Apache Airflow
Apache CamelJDBCIntegrate with SharePoint Excel Services using Apache Camel
Apache CassandraCData SyncAutomated Continuous SharePoint Excel Services Replication to Apache Cassandra
Apache KafkaCData SyncAutomated Continuous SharePoint Excel Services Replication to Apache Kafka
Apache NiFiJDBCBridge SharePoint Excel Services Connectivity with Apache NiFi
Apache NiFi Batch OperationsJDBCPerform Batch Operations with SharePoint Excel Services Data in Apache NiFi
Azure Data LakeCData SyncAutomated Continuous SharePoint Excel Services Replication to Azure Data Lake
Azure SynapseCData SyncAutomated Continuous SharePoint Excel Services Replication to Azure Synapse
BIMLSSISUse Biml to Build SSIS Tasks to Replicate SharePoint Excel Services to SQL Server
CloverDXJDBCConnect to SharePoint Excel Services in CloverDX (formerly CloverETL)
CouchbaseCData SyncAutomated Continuous SharePoint Excel Services Replication to Couchbase
CSVCData SyncAutomated Continuous SharePoint Excel Services Replication to Local Delimited Files
DatabricksCData SyncAutomated Continuous SharePoint Excel Services Replication to Databricks
FoxProODBCWork with SharePoint Excel Services in FoxPro
Google AlloyDBCData SyncAutomated Continuous SharePoint Excel Services Replication to Google AlloyDB
Google BigQueryCData SyncAutomated Continuous SharePoint Excel Services Replication to Google BigQuery
Google Cloud SQLCData SyncAutomated Continuous SharePoint Excel Services Replication to Google Cloud SQL
Google Data FusionJDBCBuild SharePoint Excel Services-Connected ETL Processes in Google Data Fusion
Heroku / Salesforce ConnectCData SyncReplicate SharePoint Excel Services for Use in Salesforce Connect
HULFT IntegrateJDBCConnect to SharePoint Excel Services in HULFT Integrate
IBM DB2CData SyncAutomated Continuous SharePoint Excel Services Replication to IBM DB2
Informatica CloudJDBCIntegrate SharePoint Excel Services in Your Informatica Cloud Instance
Informatica PowerCenterJDBCCreate Informatica Mappings From/To a JDBC Data Source for SharePoint Excel Services
Jaspersoft ETLJDBCConnect to SharePoint Excel Services in Jaspersoft Studio
Microsoft AccessCData SyncAutomated Continuous SharePoint Excel Services Replication to Microsoft Access
Microsoft Azure TablesCData SyncAutomated Continuous SharePoint Excel Services Replication to Azure SQL
Microsoft Power AutomateConnect ServerBuild SharePoint Excel Services-Connected Automated Tasks with Power Automate (Desktop)
MongoDBCData SyncAutomated Continuous SharePoint Excel Services Replication to MongoDB
MySQLCData SyncAutomated Continuous SharePoint Excel Services Replication to MySQL
Oracle Data IntegratorJDBCETL SharePoint Excel Services in Oracle Data Integrator
Oracle DatabaseCData SyncAutomated Continuous SharePoint Excel Services Replication to Oracle
petlPythonExtract, Transform, and Load SharePoint Excel Services in Python
PostgreSQLCData SyncAutomated Continuous SharePoint Excel Services Replication to PostgreSQL
Replicate to MySQLPowerShellReplicate SharePoint Excel Services to MySQL with PowerShell
SAP HANACData SyncAutomated Continuous SharePoint Excel Services Replication to SAP HANA
SingleStoreCData SyncAutomated Continuous SharePoint Excel Services Replication to SingleStore
SnapLogicJDBCIntegrate SharePoint Excel Services with External Services using SnapLogic
SnowflakeCData SyncAutomated Continuous SharePoint Excel Services Replication to Snowflake
SQL ServerCData SyncAutomated Continuous SharePoint Excel Services Replication to SQL Server
SQL Server Linked ServerConnect ServerConnect to SharePoint Excel Services Data as a SQL Server Linked Server
SQLiteCData SyncAutomated Continuous SharePoint Excel Services Replication to SQLite
TalendJDBCConnect to SharePoint Excel Services and Transfer Data in Talend
UiPath StudioODBCCreate an RPA Flow that Connects to SharePoint Excel Services in UiPath Studio
VerticaCData SyncAutomated Continuous SharePoint Excel Services Replication to a Vertica Database

Back to top

Data Virtualization


ProductTechnologyArticle Title
Access Linked TablesODBCUpdate SharePoint Excel Services with a Microsoft Access Linked Table
APOS Live Data GatewayJDBCBuild Semantic Layer Views for SharePoint Excel Services (JDBC)
DenodoJDBCCreate A Data Source for SharePoint Excel Services in Denodo Platform
DremioJDBCConnect to SharePoint Excel Services as an External Source in Dremio
MySQL Federated TablesODBCConnect to SharePoint Excel Services as Federated Tables in MySQL
Oracle DatabaseODBCAccess SharePoint Excel Services as a Remote Oracle Database
PostgreSQL FDWJDBCA PostgreSQL Interface for SharePoint Excel Services
Salesforce ConnectConnect ServerEdit and Search SharePoint Excel Services External Objects in Salesforce Connect
SQL Server Linked ServersODBCConnect to SharePoint Excel Services as a Linked Server
SQL Server PolyBaseODBCConnect to SharePoint Excel Services as an External Data Source using PolyBase
TIBCO Data VirtualizationTIBCO DVAccess Live SharePoint Excel Services Data in TIBCO Data Virtualization

Back to top

Software Development


ProductTechnologyArticle Title
.NET ChartsADO.NETDataBind Charts to SharePoint Excel Services
.NET QueryBuilderODBCRapidly Develop SharePoint Excel Services-Driven Apps with Active Query Builder
Angular JSConnect ServerUsing AngularJS to Build Dynamic Web Pages with SharePoint Excel Services
Apache SparkJDBCWork with SharePoint Excel Services in Apache Spark Using SQL
AppSheetConnect ServerCreate SharePoint Excel Services-Connected Business Apps in AppSheet
C++BuilderODBCDataBind Controls to SharePoint Excel Services Data in C++Builder
ColdFusionJDBCQuery SharePoint Excel Services in ColdFusion Using JDBC
ColdFusionODBCQuery SharePoint Excel Services in ColdFusion Using ODBC
DashPythonUse Dash & Python to Build Web Apps on SharePoint Excel Services
DelphiODBCDataBind Controls to SharePoint Excel Services Data in Delphi
DevExpressADO.NETDataBind SharePoint Excel Services to the DevExpress Data Grid
EF - Code FirstADO.NETAccess SharePoint Excel Services with Entity Framework 6
EF - LINQADO.NETLINQ to SharePoint Excel Services
EF - MVCADO.NETBuild MVC Applications with Connectivity to SharePoint Excel Services
Filemaker Pro (on Mac)JDBCBidirectional Access to SharePoint Excel Services from FileMaker Pro (on Mac)
Google Apps ScriptConnect ServerConnect to SharePoint Excel Services Data in Google Apps Script
HibernateJDBCObject-Relational Mapping (ORM) with SharePoint Excel Services Entities in Java
IntelliJJDBCConnect to SharePoint Excel Services in IntelliJ
JBossJDBCConnect to SharePoint Excel Services from a Connection Pool in JBoss
JDBIJDBCCreate a Data Access Object for SharePoint Excel Services using JDBI
JRubyJDBCConnect to SharePoint Excel Services in JRuby
Microsoft Power AppsConnect ServerIntegrate Live SharePoint Excel Services Data into Custom Business Apps Built in Power Apps
NodeJSConnect ServerQuery SharePoint Excel Services Data in Node.js (via Connect Server)
NodeJSODBCQuery SharePoint Excel Services through ODBC in Node.js
PHPConnect ServerAccess SharePoint Excel Services in PHP through Connect Server
PHPODBCNatively Connect to SharePoint Excel Services in PHP
PowerBuilderADO.NETConnect to SharePoint Excel Services from PowerBuilder
PyCharmODBCUsing the CData ODBC Driver for SharePoint Excel Services in PyCharm
PythonODBCConnect to SharePoint Excel Services in Python on Linux/UNIX
ReactConnect ServerBuild Dynamic React Apps with SharePoint Excel Services Data
RubyODBCConnect to SharePoint Excel Services in Ruby
RunMyProcessConnect ServerConnect to SharePoint Excel Services Data in RunMyProcess
RunMyProcess DSECJDBCConnect to SharePoint Excel Services in DigitalSuite Studio through RunMyProcess DSEC
SAP UI5Connect ServerIntegrate Real-Time Access to SharePoint Excel Services in SAPUI5 MVC Apps
ServoyJDBCBuild SharePoint Excel Services-Connected Apps in Servoy
Spring BootJDBCAccess Live SharePoint Excel Services Data in Spring Boot Apps
SQLAlchemyPythonUse SQLAlchemy ORMs to Access SharePoint Excel Services in Python
TomcatJDBCConfigure the CData JDBC Driver for SharePoint Excel Services in a Connection Pool in Tomcat
UnqorkConnect ServerCreate SharePoint Excel Services-Connected Applications in Unqork
VCL App (RAD Studio)ODBCBuild a Simple VCL Application for SharePoint Excel Services
WebLogicJDBCConnect to SharePoint Excel Services from a Connection Pool in WebLogic

Back to top

Data Management


ProductTechnologyArticle Title
Apache SolrJDBCImport SharePoint Excel Services Data into Apache Solr
DB ArtisanJDBCManage SharePoint Excel Services in DBArtisan as a JDBC Source
DB ArtisanODBCConnect to SharePoint Excel Services in DBArtisan
DBeaverJDBCConnect to SharePoint Excel Services in DBeaver
DbVisualizerJDBCConnect to SharePoint Excel Services in DBVisualizer
Informatica Enterprise Data CatalogJDBCAdd SharePoint Excel Services to Informatica Enterprise Data Catalog
MySQL WorkbenchConnect ServerQuery SharePoint Excel Services Data in MySQL Workbench (Connect Server)
MySQL WorkbenchODBCQuery SharePoint Excel Services in MySQL Workbench (ODBC)
QuerySurgeJDBCValidate SharePoint Excel Services Data with QuerySurge
RazorSQLJDBCConnect to SharePoint Excel Services in RazorSQL
SQuirreLJDBCConnect to SharePoint Excel Services in Squirrel SQL Client

Back to top

Workflow Automation


ProductTechnologyArticle Title
MuleSoft AnypointJDBCAccess SharePoint Excel Services in Anypoint Using SQL
Nintex Workflow CloudConnect ServerBuild SharePoint Excel Services-Connected Workflows in Nintex
Power AutomateConnect ServerIntegrate SharePoint Excel Services Data into Power Automate Automated Tasks
SSIS ExportSSISExport Data from SQL Server to SharePoint Excel Services through SSIS
SSIS ImportSSISImport SharePoint Excel Services Data into SQL Server using SSIS
SSIS LookupSSISInsert New or Update Existing SharePoint Excel Services Records from SQL Server

Back to top