Best/Fastest approach for Injesting Big SAP Tables like BSEG, BKPF into Azure Data Lake gen 2?

Copper Contributor

Possible Approch in Theory- 


- Pump Data from SAP BODS to Azure data Lakes.

- Use Data Factory 


I would basically like to land the data  into SQL Data Warehouse. But for Polybase to work it needs to be staged in either Blog or Azure Data Lake?


Please suggest a proven way by experience?



2 Replies


You can use Azure Data Factory - SAP Table Connector to connect to SAP System and Extract Data in BLOB Storage and later Copy Data to SQL DW using Polybase.


Do you have any performance measure of extracting from SAP connectors and putting them in Blog?

Poly base would possibly work well from Blog to Azure warehouse but I am not sure on the ingestion performance...