SAP TABLE INPUT TO AZURE SYNAPSE(MY SQL SERVER)

[sam473]

Hi ,

When I'm loading data from tsapinput table to azure synapse(SSMS) data loading is very slow , can some one help me its little bit urgent.

1. I need to perform two operations for the first time it should load bulk
2. after that it should perform insert and update

Any suggestion on design and components will be highly recommended

[Anonymous]

Hello,

From your screenshot, here is a tMap component which will consume too much memory. For a large set of data, try to store the data on disk instead of memory on tMap and allocate more memory to execute the job. Let us know if it is OK with you.

Best regards

Sabrina

[sam473]

Hi ,

Really thanks for your replay , i am struck disparately need help i want to load my data into azure synapse(sql server) , data getting extraction fast but commit is happening very slow , bulk load not working

[sam473]

Hi, after removing tmap component , and try to ingest data commit inside the db happening very slow for tsqldwhoutput, so i tried to ingest data with tsqldwhbulk load but i am facing

[sam473]

[Prakhar1]

make sure you have all the required access on both the system i.e. reading and writing