I have a SQL server which needs to be connected via UiPath and retrieve data. What are the infra required to achieve this. By infra I mean, what are the additional installations I have to do on the dev machine for this to work.
This sql server requires VPN to connect, so VPN is installed. Do we need sql client like sql server manager, dbeaver etc to be installed also inorder for the connect activity to work? If additional installations are required, what all should be configured within that?
Please recommend me the best available option to achieve this.
Hi, thanks for the response. What I am looking for is pre-requisites before using the UiPath database connect activity. Do I need to install sql server client in my dev environment? Whether it has to be always up and running if the bot has to get data from db etc…
In short, I am looking for the mandatory installations to be done, so that I can use database connect activity.
This made me think and happen to see below articles, in these it is saying we need a local instance running so that database connect can work. I am here to verify, whether this is the right approach or not.