Configure ODBC data source

  1. Launch ODBC Data Source Administrator (32-bit) by double clicking on the icon located on the desktop, ‘ODBC Data Sources (32-bit).

ODBC Icon

  1. Under System DSN tab.
    • Select PG.MFLABDB and click Configure.

System DSN

  1. PostgreSQL setup dialog box should appear.
    • Update Server field with Aurora writer endpoint captured in the previous section (Create Aurora PostgreSQL Database - step-11).
    • Click Test. Connection should be successful.
    • Click OK and Save.

Configure DSN

In case, if the connection was un-successful or timed-out, then issue could be in the misconfiguration of security group for Aurora database.

  1. Under System DSN tab.
    • Select PG.VSAM and click Configure.

System DSN

  1. PostgreSQL setup dialog box should appear.
    • Update Server field with Aurora writer endpoint captured in the previous section (Create Aurora PostgreSQL Database - step-11).
    • DO NOT click Test because this database has not been created yet.
    • Click Save and OK.

Configure DSN