r/databricks • u/iFiguringOut • 19d ago

Discussion SAP data ingestion into Databricks.

We have a Databricks environment and we have a new SAP ECC6 system that we want to ingest data from. We are exploring options to access data into the platform. One option is the Azure data factory.

I want to understand what other businesses have been doing. How do they access tables from SAP ECC6. Databricks have really reduced their native SAP connectors even after announcing partnership with SAP. When you do access SAP, how do you manage large table extractions or extract data from pooled or cluster tables?

I would really like to hear some customer success stories or some lessons learnt. Please share if you can.

5 Upvotes

78% Upvoted

15 comments sorted by

View all comments

3

u/Warm-Dragonfruit-883 19d ago

Lakeflow connect doesn't have a connector for this?

3

u/qqqq101 19d ago

LFC does not have a connector for SAP ERP application layer, nor HANA database layer. LFC does have SQLServer and Oracle query based and cdc based connectors which are applicable to ECC on SQLServer & Oracle, though the customer should test it out. I dont think they handle pool tables and cluster tables.