Skip to content
  • There are no suggestions because the search field is empty.

PostgreSQL Data Connection Setup

Setting up a PostgreSQL connection should only take 5-10 minutes.

There may be fees associated with setting up a new data connection. Please contact your account team to confirm pricing.

Pre-Implementation

To establish the data connection, you will need the BUCS Remote Agent installed on the machine where your PostgreSQL data is located. Remote Agent installation instructions can be accessed here.

Implementation

1. Connect to PGSQL

Go to BUCS Customer Portal > Connection Management > Connection Hub. Locate or search for the PostgreSQL connector and click Connect.

 

 2. Name Connection

Enter a Name for your connection on the first page of the connection wizard and then click Next. The connection name should be descriptive and specific to the connection you want to establish. 

 

3. Provide Connection Details

Provide your PostgreSQL Username and Password and the Host Name and Database where your PostgreSQL Server data is located. Enter the Application Name of the data source you are connecting. Click Save. 

The Username and Password can be associated to an existing user or you can setup a new dedicated BUCS user in your PostgreSQL account.

4. Connection Established

If the connection was established successfully, you will see a Connection Established message and data from your PostgreSQL data source will continuously sync to BUCS. If the connection was not successful, you will be asked to try again.

NOTE: If you don't see your data appear in the BUCS platform in 24 hours, please contact your account team.