PostGresql Configure connection

Hi ,

We use postgresql as a database in our project hence I want to do the database connection with postgresql using UiPath. But I am unable to find how to do that. Could you please help me know how to Configure the connection in UIPath for postgres with a sample xaml file.

Thanks!
Shan

Hi @shanvj

Is the POStGRESQL configured in your system?

Please send me the screenshot of connect activity

Use this post for your reference

https://www.postgresql.org/docs/10/static/manage-ag-config.html

Thanks
Ashwin S

Hi @shanvj, Please try the following steps for PostGresql Connection

PostgreSQl DB Conncetivity ISSUE :

When We are giving “Connection String” to the New connection Database

Step 1 :

Install ODBC driver(32-bit) from “https://dev.mysql.com/downloads/connector/odbc/5.3.html”

Step 2:

Install PostgreSQL driver(32-bit) from “https://jdbc.postgresql.org/”

Step 3:

Now, Create .DNS file using ODBC driver with PostgreSql driver

Step 4:

Now Configure the DNS file with the details of DB, User name and password

Step 5:

Now, Open UI Path -> Connection Wizard -> Set up Microsoft ODBC Data Source and upload the DNS file in the below path and click on ‘Test Connection’

Step 6:

Click on ‘Run’ and now the connection will set up

Note :

Don’t generate 64 bit DNS file. It is not supported for the Data base connection to postgresql.

1 Like

Thanks for the suggestion. I will make the changes and confirm.

Could you please let me know how to configure POSTGRESQL in my system. I have installed the postgresql driver. But nothing shows in Datasources(ODBC). Awaiting your reply. Thanks in advance.

Hi @shanvj

Please do check this post for your reference

Thanks
Ashwin S

1 Like