Set up a PostgreSQL ODBC Driver

1

Under both 32-bit and 64-bit operating systems, Enterprise Architect requires 32-bit ODBC drivers to connect to a repository through ODBC. You can quickly load the correct 32-bit ODBC Data Source Administrator by selecting the 'Configure > User Tools > ODBC Data Sources' ribbon option.

The ODBC Data Source Administrator window displays.

2

Click on the Add button.

The 'Create New Data Source' dialog displays, enabling you to add a new DSN.

3

Select 'PostgreSQL UNICODE' from the list.

4

Click on the Finish button.

The 'Postgre SQL Connector/ODBC' dialog displays.

5

Enter these configuration details:

• A data source name for the connection
• The actual name of the database
• The host address of the DBMS server
• User name
• A description (optional)
• The password

6

To set the advanced options, click on the Datasource button and set the options on 'Page 1' as shown:

Note: From version 9.5.4 onwards some options shown in this image are no longer available and can be ignored.

7

If you are using a version of PostgreSQL between 8 and 9.5.4, set the options on Page 2 as shown:

• The 'Disallow Premature' checkbox should be checked
• In the 'Protocol' panel, the '7.4+' radio button should be selected

Note: From version 9.5.4 onwards the two options are no longer available and can be ignored.

8

Click on the OK button to complete the configuration.