topic Re: How to integrate SAP ERP to databricks in Data Engineering

How to integrate SAP ERP to databricks

ricard98 — Thu, 28 Jul 2022 15:16:45 GMT

is there a way to integrate SAP erp to a databricks Notebook through python???,

Re: How to integrate SAP ERP to databricks

Hubert-Dudek — Fri, 29 Jul 2022 08:37:00 GMT

Direct connection to SAP is time-consuming and difficult. Fivetran is Databricks partner (you can see them in Partner connect). They have an excellent way to connect Databricks to SAP:

https://www.fivetran.com/connectors/sap-erp

Re: How to integrate SAP ERP to databricks

-werners- — Tue, 02 Aug 2022 13:39:07 GMT

The options are indeed limited.

Fivetran is certainly an option. There used to be SAP Vora, but I have no idea if that still exists.

Another way is to connect to the sap db directly, but that is a big nono in the SAP world.

Re: How to integrate SAP ERP to databricks

jose_gonzalez — Wed, 17 Aug 2022 21:34:49 GMT

Hi,

Just a friendly follow-up. Did any of the responses help you to resolve your question? if it did, please mark it as best. Otherwise, please let us know if you still need help.

Re: How to integrate SAP ERP to databricks

Kong — Fri, 02 Dec 2022 02:10:57 GMT

I've connected Databricks directly to S4/HANA ABAP layers but will re-iterate that it is extremely challenging if you do not have a background in sys administration, networking, devops, programming, and SAP.

Re: How to integrate SAP ERP to databricks

Azure_Data_Bric — Sat, 26 Aug 2023 18:04:57 GMT

Can you please help me with the steps of how you connected to SAP ECC/S4?
I want to connect to ECC and S4 from Databricks just to check the record count in some of the tables.

Re: How to integrate SAP ERP to databricks

felixdmeshio — Tue, 17 Dec 2024 09:29:21 GMT

Hey,

Yes, there is a way to integrate SAP (SAP HANA) data into Databricks, and our SAP HANA to Databricks connector makes this process seamless.

The connector enables you to extract data directly from SAP HANA tables and load it iteratively into Databricks for further processing.

The key benefits are:

Incremental Data Transfer: Particularly helpful for managing very large datasets.
Simple Usage: No complex configurations required.

With the connector, integrating your timestamped data should work seamlessly.

For more details, including implementation steps, please refer to our official documentation. If you need further support, don’t hesitate to contact us at info@dmesh.io.

I hope this helps you integrate SAP data into Databricks!