Forum Discussion
Thanks for this post, This is Karthi, I am part of Data Engineering Team, we have Workday in our company, we are facing performance issue on downloading the WD web enabled URL in CSV file format.
We have SSIS ETL tool where we use script task (C#) to hit WD web enabled URL to download the files, last couple of month we are facing some performance issue in this task, some times this task is running longer, generally this will complete in 10 mins but sometime its running in Hours/days and timed out finally.
We checked with SQL Server side there server performance is good, but we are not able to find why this download part is running longer and timed out, it will really helpful if you have some suggestion on this, and is there any alternative way to download the WD reports data in file formats?