Forum Discussion

SidzOne9's avatar
SidzOne9
Copper Contributor
Aug 03, 2019

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

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?

 

 

SAP on Azure
  • Badeeul's avatar
    Badeeul
    Copper Contributor
    Aug 06, 2019

    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.

    • SidzOne9's avatar
      SidzOne9
      Copper Contributor
      Aug 06, 2019
      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

Resources