How to connect UiPath with postgresql

[Arjun1 (Arjun)]

Hi,
I need to connect postgresql and uipath.can anybody please help me.
[If possible please give step by step info]
Thanks in advance.

[Lahiru.Fernando]

Hi @Arjun1

There are couple of solutions provides in the below thread. There is also a sample workflow provided… i think it should work for you to connect with the database.

How to connect to postgresql db from uipath

If this works for you, please make sure to mark the answer as the solution

Let know how it goes

[pavanh003 (Pavan Harisha)]

Hi,
Please follow the below chain and this should solve your issue.

How to use postgresql database in database connectivity in UiPath?

Hi , I used the ODBC driver provided by postgreSQL. note that you must use the 32 bit driver x86 - UIpath does not seem to work with the 64 bit driver. for me , it connects OK… however I am having issues committing data to the database. can any experienced developer help out in configuring this driver properly ? i have tried different options with no avail. I get an error in data insert “message”: “PSQLODBC35W.DLL : ERROR [42601] ERROR: syntax error at or near "-";\nError while executing the …

Let us know if not.

Regards,
Pavan H

[balupad14 (Balamurugan (BalaReva))]

Hello @Arjun1,

I have uploaded the custom activity to Postgresql . I am waiting for publish. But any way you can use it which i attached it here.

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

[Arjun1 (Arjun)]

Thank you guys…I have attached full step by step uipath and postgress access solution pdf.I did like this way and it working for my CRUD operation sucessfully.Thank you so much for your great helpInstall ODBC drivers-UiPath2-converted.pdf (762.7 KB)