Skip to main content
Sign in

Connecting to Amazon RDS PostgreSQL

  • Updated

This article covers how to connect Openprise to Amazon RDS PostgreSQL when setting up a data source. You will need a Amazon RDS PostgreSQL account and credentials for Openprise. You can learn more about Data Sources HERE.

When creating a new data source, select Amazon RDS PostgreSQL from the source technology and data format picklist.

AmazonSQL_0.png

AmazonSQL_1.png

Connection_SFDCSandbx_3.png

  1. Select the Add Account Information button to link your Amazon RDS PostgreSQL account to Openprise
  2. Click on the Add Account button to sign into your Amazon RDS PostgreSQL account using your credentials
  3. Select from an existing account if you've already linked your Amazon RDS PostgreSQL account to Openprise

If you selected the Add Account button, you will need to include the username, password, database, port, and host name from your Amazon RDS PostgreSQL account. 

AmazonSQL_4.png

AmazonSQL_5.png

Directory or entity - Select the directory or entity in your Amazon RDS PostgreSQL account containing the data you want to import as a new data source.