Forum Discussion

Bikematt's avatar
Bikematt
Frequent Visitor
1 year ago
Solved

Really bad throughput on copy data step copying data from SAP Hana into Lakehouse

Hi,   Our team is migrating from Synapse to Fabric.  Several of our datasets come from SAP Hana via an on prem data gateway with an ODBC connector.  We are seeing some pretty abysmal throughput in ...
data pipeline
  • Bikematt's avatar
    Bikematt
    1 year ago

    Hi v-lgarikapat ,

     

    We finally got the SAP Hana connector to work/perform as expected.  What ultimately worked for us was to roll back our on-prem gateway version back to the March 2025 (3000.262) version. The April 2025 (3000.266) and May 2025 (3000.270) versions did not work for us.  The throughput for those versions was really bad.  Below is a screenshot of the throughput after rolling back to March 2025:

     

Bikematt's avatar
Bikematt
Frequent Visitor
1 year ago

Hi v-lgarikapat ,

 

We finally got the SAP Hana connector to work/perform as expected.  What ultimately worked for us was to roll back our on-prem gateway version back to the March 2025 (3000.262) version. The April 2025 (3000.266) and May 2025 (3000.270) versions did not work for us.  The throughput for those versions was really bad.  Below is a screenshot of the throughput after rolling back to March 2025:

 

v-lgarikapat's avatar
v-lgarikapat
Icon for Community Support rankCommunity Support
1 year ago

Hi Bikematt ,

Thanks a lot for sharing the resolution. It was really helpful and much appreciated!

Your input will surely help others in the community as well. Great job!

Best Regards,

Lakshmi Narayana