How to connect external machine sql database in our machine uipath

Hi , Am trying to connect external machine postgresql server database to our machine through uipath,please someone help me out for this connection.

1 Like

Hi @DivyaT

You can use the database activities from the package manager. These activities can be used to connect to your database…

3 Likes

please find the attachment of error image,while trying to connect database.

1 Like

@DivyaT

Go through this post… you’ll find more info on how to use it…

How to connect to postgresql db from uipath

I can able to connect internal machine sql but am trying to connect external server,I mean i have downloaded postgresql in other machine this server am going to connect in my machine through uipath for data migration.

1 Like

Correct me If I’m wrong, if you created the server in internal machine and trying to connect from machine which is outside the network, you need to have a public IP or machine name for that server. If you are trying to connect within the network, check just by pinging the IP of that machine in your command prompt @DivyaT

Let me know the result :slight_smile:

3 Likes

@HareeshMR is right. @DivyaT you should have public Access to that system where sql server install. Put that ip address in server name field

4 Likes

@DivyaT

I also agree on this :slight_smile:

3 Likes

Thank you for giving the solution.

1 Like