Connecting PostgreSQL Database with UiPath

News Knowledge Base
1

How can UiPath be connected to a PostgreSql database?

Prerequisites:

  • Follow the steps mentioned in Install PostgreSQL on Windows to download and install and PostgreSQL
  • Download the 32-bit version of PostgreSQL Windows Installer
  • Install PostgreSQL
  • Verify the installation

Perform the below steps:

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

image2018-12-20_15-47-18.png
image2018-12-20_15-47-18.png602×181 38.8 KB

2.png
2.png221×249 21.4 KB

3.png
3.png602×196 63 KB

4.png

  1. Now create and configure the DNS using ODBC driver with PostgreSQL driver
    1. In Windows, search for “ODBC Data Sources (32-bit)” and open it
    2. In the “User DSN” tab click on the “Add New” button

5.png
5.png354×249 46.1 KB

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

6.png
6.png340×250 38.8 KB

  1. A new Configuration window will appear. Fill in the required details into it and then test if the connection is successful

7.png
7.png437×250 32.2 KB

  1. Once the connection is successful, go ahead and use PostgreSQL with UiPath.

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

8.png
8.png342×155 7.75 KB

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

9.png
9.png434×249 39.3 KB

  1. 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
  2. Enter the “User Name”, “Password” and then test your connection
  3. Once the connection is successful you can go ahead and use the PostgreSQL Database with UiPath.