How feasible is uipath and sql connectivity

Help Studio
, , ,
1

Hi,

I am working on UIPATH to AZURE SQL connectivity. I have moved a dump data which consists of 3 columns and 6000 rows from UIPATH. so what i observed was it is taking 30 minutes.

If i have a bulk data then it takes day to push in to AZURE SQL CLOUD which is not feasible.

Can someone suggest me how to increase the transferring speed from uipath to Azure sql.

Thanks for understanding!!!

1 Like
2

Hi
I hope it’s not the issue with uipath
Did we check with this blog

Cheers @Karthik_Kulkarni

3

Hello @Karthik_Kulkarni

I think I can give you a answer for this as I was in the business intelligence domain some time back…

Usually this slowness is caused when it highly uses the number of DTU’s available for your azure instance… you can check the utilization of the processing capability by logging in to the azure portal…

From the queries point of view, you can also check which part of the queries are taking highest resources/ time to process…

I recommend you to do this analysis and then decide what to do based on the findings…

Let me know if you need any help in this regard

3 Likes
4

Hi @Lahiru.Fernando,

So you mean there is no problem from UIPATH standpoint,overall problem exists with azure sql.

If i allocate sufficient DTU’s will the data transfer increase? because as of now am using trial version of azure where i can’t allocate sufficient resources.