How does Databricks integrate with SAP? I am looking for a tech overview.

[sajith_appukutt]

SAP as you know has bunch of products . With some like Hana, you could use a jdb/odbc connector while others products have databases backing them ( like sql server ) which you could connect to .

Depending on your need ( CDC ) , you might also want to look at our partners like Azure Data factory or HVR , blitzz etc

[MarcoCaviezel · Accepted solution]

Hi,

I'm working with the Azure Data Factory (ADF) SAP Table connector.

Basically I'm using RCA calls to download SAP Tables and save them to ADLS Gen2. In a next step I trigger Databricks notebooks with ADF to transform these files.

Best regards,

Marco

[Atanu]

Currently supported datasources with Databricks https://docs.microsoft.com/en-us/azure/databricks/data/data-sources/

and may be this block will have more insight - https://blogs.sap.com/2019/10/24/your-sap-on-azure-part-22-read-sap-hana-data-from-azure-databricks/

Let me know if this help. @Frank Munz​