PostgreSQL with UiPath - How To

[Prashant_08 (Prashant)]

Question

How can I connect UIPath to a Postgresql database?

Step by step guide

Prerequisites:-

• Please follow the steps mentioned in the link below to download and install and PostgreSQL.
• http://www.postgresqltutorial.com/install-postgresql/
• Please download the 32-bit version of PostgreSQL Windows Installer.
• Install PostgreSQL.
• Verify the installation

Please follow the steps below:-

1. Install PostgreSQL driver (32-bit) from the following link Link. Navigate to the link and click on “ PostgreSQL download site ” to open the download page. Then select the “ MSI ” from the directories section and then select “ psqlodbc_09_05_0400-x86.zip ” or any respective 32-bit driver.

2. Now, Create and configure the DNS using ODBC driver with PostgreSQL driver

• In windows, search for “ ODBC Data Sources (32-bit) ” and open it.
• In the “ User DSN ” tab click on the “ Add New ” button.

• Select “ PostgreSQL Unicode ” and click on “ Finish ”.

• A new Configuration window will appear. So you need to fill in the required details into it and then test if your connection is successful.

• Once the connection is successful you can go ahead and use PostgreSQL with UiPath.

  3. Open UiPath Studio and drag a “ Connect ” activity from Database Package.

• Click on “ Connection Wizard ” and select the “ Microsoft ODBC Data Source ” and then click “ OK ”

• In the “ Data Source Specification ” select the “ Use user or system data source name ” and from the drop-down select the recently created DSN source.
• Enter the “ User Name ”, “ Password ” and then test your connection.
• Once the connection is successful you can go ahead and use the PostgreSQL Database with UiPath.

[balupad14 (Balamurugan)]

Hi @Prashant_08,
Here you can get the PostgreSql Connector.

UiPath Go ! BalaReva PostgreSQL

Hi Guys, I have successfully uploaded PostgreSQL in UiPath Go.This package contains the below activities . Execute DataTable This brings the information from database even if you use the direct query or stored procedure. Execute NonQuery It helps to execute To insert, update and delete statements. Execute Scalar Returns the first column of the first row in the result set returned by the query or stored procedure as Object. https://go.uipath.com/component/balareva-postgresql-activities …

Regards
Balamurugan.S

[Mohammad_Hout]

Thank you a lot ,I followed your steps and it worked very well ,your explanation is very clear

[Priyanka_Ramesh]

Thanks a lot . It worked fine .

[Venkata_Sai_Thota]

I followed these steps i am able to connect to postgresql but i am not able to insert data with insert execute non query through parameters.it is showing the error like this ! error|553x129

[moenk (Thomas Meier)]

Works great without any further activities:

Test_Postgresql.xaml (5,1 KB)

[Sreevidhya_M]

Thanks a lot,it works

[venkat4u (venkat)]

when i follow these steps, i got excpetion as below can any one help on this.

Thanks

[venkat4u (venkat)]

I hve installed but i am getting error. looks like this package is not supported in 2022.10 version.

any new releases?

Thanks
venky

[Prashant_08 (Prashant)]

Hi @venkat4u,

1. Are you able to connect to Postgres normally without any drivers?
2. If Yes, then do you give any certificate or use any other authentication approach?