How to load BSEG table FROM SAP ECC/HANA to Azure through ADF using the SAP connector?

Hello @Vinayak Mathur ,
Thanks for the question and using MS Q&A platform.
As we understand the ask here is to copy the BSEG table to Azure , please do let us know if its not accurate.
Let me start with , I am not SAP literate and neither I have an environment to test the ask here . i was reading and I did found this link https://stackoverflow.com/questions/71209436/delta-load-on-bseg-table-into-azure-using-sap-table-conenctor and I am sure if you got a chance to read this before .
You did mentioned "nothing seems to be working" , can you please lets us know what is that you are experiencing any error , any config issues etc .

Please do let me if you have any queries.
Thanks
Himanshu

Hi @HimanshuSinha-msft ,

When I am trying to load data from BSEG table into Azure Synapse, I get an error saying

Operation on target Copy_z0z failed: ‘Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Failed to invoke function /SAPDS/RFC_READ_TABLE2 with error: SAP.Middleware.Connector.RfcAbapRuntimeException, message: No more memory available to add rows to an internal table., stacktrack: at SAP.Middleware.Connector.RfcConnection.ThrowRfcErrorMsg() at SAP.Middleware.Connector.RfcConnection.ReadBytes(Byte* buffer, Int32 count) at SAP.Middleware.Connector.RfcConnection.ReadRfcIDBegin(Int32& length) at SAP.Middleware.Connector.RfcConnection.ReadUpTo(RFCGET readState, RfcFunction function, RFCID toRid) at SAP.Middleware.Connector.RfcConnection.RfcReceive(RfcFunction function) at SAP.Middleware.Connector.RfcFunction.RfcDeserialize(RfcConnection conn, IRfcIOStream stream) Boolean initStatefulSession, Boolean checkForErrors) at Microsoft.Practices.TransientFaultHandling.RetryPolicy.,Source=Microsoft.DataTransfer.Runtime.SapRfcHelper,”Type=SAP.Middleware.Connector.RfcAbapRuntimeException,Message=No more memory available to add rows to an internal table.,Source=sapnco,

I know this is because the data I am trying to load is too large, I have tried to go for the smallest chunk and yet I am facing this issue.
We cannot increase the memory on SAP Server, I need help with some approaches on the Azure end.

So far I have used partition option in Azure
Increasing/Reducing Parallelism
I need some other approach or way to get this data.

Thanks!