Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi All,
We have a SAP HANA system in our on-premises and we have installed the On-premises data gateway to copy data into Lakehouse.
The OPDG is present in VM which has 8 GB RAM.
When we tried to extract data from SAP HANA into Lakehouse as delta table, it runs for 30-40 mins and timeouts. I even tried just 100 records but fails.
But the same thing works when I use parquet format or CSV. I can even extract 20K records under a minute in those formats. I also tried ADF with Self-hosted Integration runtime, but still the same result.
Had the same problem, but I wasn't able to load data from on-premises SQL Server to lakehouse at all (table and files). I am using March version of on-prem data gateway running on Hyper-V virtual machine and I had to disable processor compatibility mode on it additionally for this to work.
Hi @govindarajan_d
Thanks for using Fabric Community.
At this time, we are reaching out to the internal team to get some help on this. We will update you once we hear back from them.
Thanks
Hi @govindarajan_d
The internal team has replied as follows: Insufficient information for troubleshooting. Customer Failed to test Connection or copy timeout? Since ADF with SHIR also encountered this timeout, it's highly likely to be due to incorrect user configuration.
Copy data from SAP HANA - Azure Data Factory & Azure Synapse | Microsoft Learn
Can you please confirm if its Failed to test connection or Copy timeout?
Than
Hi @govindarajan_d
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. Otherwise, will respond back with the more details and we will try to help.
Thanks
Hi @govindarajan_d
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. Otherwise, will respond back with the more details and we will try to help.
Thanks
.
Sorry i put wrong response