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

[SidzOne9]

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]

@SidzOne9  

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.

[#3]

thanks!

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...

Regards,
Sid