Connection with PostGreSql

[ralall (Rahul Lall)]

Could you please help me with the connection of PostGreSql with uipath . If you could share any workflow that would be great

[sarathi125 (Parthasarathi)]

Hi @ralall,

Please check these posts for better understanding,

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 …

How to use postgresql database in database connectivity?

Have you found a solution?

Launching Applications/Postgres Connectivity

Hi, Ad 1. Since you’re using Chrome, make sure you have the plugin installed. Use OpenBrowser activity (remember to change which browser in properties) instead of LaunchApplication. There are a couple of activities, like NavigateTo that should fit your needs. Check the Web Tutorials (note: some of them show older versions of software, but most functionality is almost the same from user perspective). From experience I can say that I have some projects running with Chrome and I’m pretty happy w…

[Samuel_Ehrlich]

You need:

1. Install ODBC Driver
2. Add your connection via connection properties.
   
   Find your system data source. If you don’t see your connection there, you need to double check in your odbc connections.

[balupad14 (Balamurugan)]

Hi ,
Take a look at this to connect the PostgreSql.

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 …

PostgreSql UiPath | uipath postgresql | select the data

Regards
Balamurugan.S