How to setup ODBC for PostgreSQL for erwin r9.8

How to setup ODBC for PostgreSQL for erwin r9.8

1. Download ODBC: https://www.postgresql.org/ftp/odbc/versions/msi/

2. Install ODBC – psqlodbc_x64.exe which will be installed at folder:

        C:\Program Files\psqlODBC\0906

3. Launch ODBC and access the Data source from Control Panel\System and Security\Administrative Tools\ODBC Data Sources (64bit)

4. Configure the Postgres ODBC data source and test the connection:

Database name

User Name

Password

Port number:

e.g., the Default database is Postgres and user name is Postgres / erwin with port number 5432.

NOTE: please see https://odbc.postgresql.org for more details on how to use the PostgreSQL ODBC driver.