Feb 22 2023 03:13 AM - edited Feb 22 2023 04:22 AM
Hi Team,
i am asking few questions about ADF which i have created but need suggestion for improvement
Requirement: Using ADF for transferring records from Source (SAP ECC) to Destination (Rest API)
Approach used :
1. Create Copy Activity with appropriate connector and applied proper mapping of fields , but surprised even output of pipeline showing records are written on destination , but there were no records refer below SS. [ Any comment or suggestion for this issue ]
2. In next approach i created a new pipeline with below chaining components :
A. Web Activity [for fetching records from SAP ECC connector ] which returns many fields but few of needed for next processing
B. Store output of A into Variable (Array) using set variable
C. Then add Foreach activity to process each record of B one by one through another Web Activity (inside for each loop) although destination api have option to put many records in one request.
Now problem area is that second approach take so long time as it iterates for each element of array, but in my case , it would need to be speedup (in case of need to process 20000 records Ex.)
Constraints need to follow : Without saving data records anywhere like BLOB storage .
Any suggestion for overcoming this problem.
Apr 06 2023 01:42 AM
Finally, i got the solution by implementing pipeline with help of several activities.Just posting here so that it can be help others if have same requirement (i just temporary stored data on blob storage and deleted on execution of pipelines get completed)
@if(greater(activity('Copyactivity1').output.rowsCopied,0) , activity('MetadataActivity').output.childItems,variables('varEmptyArr')) *varEmptyArr is a declared variable contain blank value , used in case of no record received form source