Learn more
 

CData Software - Knowledge Base

Recent SharePoint Articles

Deploy the ADO.NET Provider for Excel Online on an SSRS Report Server

Connect to Microsoft Excel Online from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.

Query SharePoint Excel Services in MySQL Workbench

Create a virtual MySQL database for SharePoint Excel Services in CData Software Connect (or Connect Server) and work with live SharePoint Excel Services in MySQL Workbench.

Deploy the ADO.NET Provider for Box on an SSRS Report Server

Connect to Box from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.

Deploy the ADO.NET Provider for Invoiced on an SSRS Report Server

Connect to Invoiced from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.

Use the CData ODBC Driver for DocuSign from SharePoint Excel Services

This article demonstrates how to use the CData ODBC Driver for DocuSign to connect to DocuSign from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring DocuSign in Excel.

Automate SharePoint Excel Services Replication to Azure Synapse

Use CData Sync to customize and automate SharePoint Excel Services replication to Azure Synapse.

Use the CData ODBC Driver for ConstantContact from SharePoint Excel Services

This article demonstrates how to use the CData ODBC Driver for ConstantContact to connect to ConstantContact from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring ConstantContact in Excel.

Use Biml to Build SSIS Tasks to Replicate SharePoint to SQL Server

Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Microsoft SharePoint to SQL Server.

How to connect and process SharePoint Excel Services from Azure Databricks

Use CData, Azure, and Databricks to perform data engineering and data science on live SharePoint Excel Services

Publish SharePoint-Connected Dashboards in Tableau Server

Use CData JDBC drivers and Tableau Server to visualize live Microsoft SharePoint.

Use the CData ODBC Driver for Splunk from SharePoint Excel Services

This article demonstrates how to use the CData ODBC Driver for Splunk to connect to Splunk from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Splunk in Excel.

Connect to Oracle HCM Cloud in CloverDX (formerly CloverETL)

Transfer Oracle HCM Cloud using the visual workflow in the CloverDX data integration tool.

Create SharePoint Dataflows on PowerBI.com

Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.

Connect to Zoho Creator in CloverDX (formerly CloverETL)

Transfer Zoho Creator using the visual workflow in the CloverDX data integration tool.

Use the CData ODBC Driver for Redshift from SharePoint Excel Services

This article demonstrates how to use the CData ODBC Driver for Redshift to connect to Amazon Redshift from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Amazon Redshift in Excel.