Connect to AWS Aurora Postgres DB

  1. From the Cognos Analytics welcome screen, go to Menu and click on Manage.

data-server-connections

  1. click on Data Server Connections to create a new DB connection as shown below.

data-server-connections-button

  1. Now, click on Data server + icon for the new Data Server connection.

data-server

  1. Select a type as PostgreSQL database as shown below.

postgresql

  1. Edit the JDBC details and add the HostName (Postgres endpoint url), Port and DatabaseName, and select the radio button Use the following signo under Authentication method and click on + as shown below.

postgresql-jdbc-credentials

  1. Now fill in your AWS Aurora Postgres DB credentials - User ID and Password, as shown below. Click on Test and Save.

postgresql-login-credentials

Note: Load the metadata for public schema and then save the connection.

load-metadata