cancel
Showing results forย 
Search instead forย 
Did you mean:ย 
Data Engineering
Join discussions on data engineering best practices, architectures, and optimization strategies within the Databricks Community. Exchange insights and solutions with fellow data engineers.
cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

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

User16752244127
Contributor
 
1 ACCEPTED SOLUTION

Accepted Solutions

MarcoCaviezel
New Contributor III

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

View solution in original post

3 REPLIES 3

sajith_appukutt
Honored Contributor II

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
New Contributor III

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
Esteemed Contributor

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โ€‹ 

Connect with Databricks Users in Your Area

Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you wonโ€™t want to miss the chance to attend and share knowledge.

If there isnโ€™t a group near you, start one and help create a community that brings people together.

Request a New Group