Azure Databricks data integration tutorials
Tutorials for reading live SharePoint, SAP, Dynamics 365, Dataverse and Athena data in Azure Databricks notebooks with the CData JDBC driver.
What this integration does
Databricks provides data processing through Apache Spark. A notebook can read from any JDBC source into a DataFrame, which makes it a convenient place to combine operational data with the data already in your lakehouse.
How CData fits in
The CData JDBC driver is installed on the cluster, and Spark reads SharePoint, SAP, Dynamics 365 and other sources through it with ordinary SQL. The tutorials cover speeding up reads, choosing between connection options for SAP, replacing file exports with a live read, and a quick reference for Dataverse.
Azure Databricks tutorials by data source
Amazon AthenaQuery Amazon Athena from a Databricks Notebook and Keep a Copy
Build an Azure Databricks notebook that reads an Amazon Athena table through the CData JDBC driver, runs SparkSQL over it, and saves a copy as a table.
Dynamics 365Replace Dynamics 365 File Exports with a Live Databricks Read
Swap a scheduled Dynamics 365 export for a live JDBC read in Azure Databricks: choose the edition, install the driver, cut over one table, and keep a way back.
Microsoft DataverseDataverse JDBC in Databricks: Connection and Notebook Cheat Sheet
Class name, URL form, connection properties and copy-paste notebook snippets for reading Microsoft Dataverse from Azure Databricks with the CData JDBC driver.
SAPSAP Data in Azure Databricks: JCo, SOAP, or Replicate First?
Three ways to get SAP ERP data into Azure Databricks with CData: a live read over SAP JCo, a live read over SOAP, or replication first. Then a notebook read of MARA.
SharePointSpeed Up SharePoint Reads in Azure Databricks: Measure, Then Trim
Time a baseline SharePoint read in an Azure Databricks notebook, then scope the site, filter, trim columns, split joins and land a copy, re-measuring each time.
Don't see your data source or tool?
CData connects hundreds of sources to the tools you already use. Browse the connectors, or talk to us about a specific setup.