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:

     

v-lgarikapat's avatar
v-lgarikapat
Community Support
1 year ago

Hi Bikematt ,

 

Thanks for the update! If you have any trouble or need help, just let us know  we're happy to support you.

Looking forward to your response.

Best regards,
LakshmiNarayana

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