ODBC Connection to PostgreSQL repository

1

Download the appropriate PostgreSQL ODBC driver (psqlODBC) for your operating system and architecture (32 or 64 bit) of Enterprise Architect from the PostgreSQL website.

Note:

• Not all versions of PostgreSQL ODBC driver function correctly with Enterprise Architect, see  the Driver Issues page for details of the versions that cause problems.

2

Run the PostgreSQL driver installer, accepting the default values.

1

The Windows Operating System includes 2 different versions of the ODBC administrative tool, one for 32 bit and the other for 64 bit applications. Therefore you need to open the 'Open Data Source Administrator' that corresponds to the architecture of your Enterprise Architect application.  The easiest way to achieve this is to use Enterprise Architect's build-in ribbon option:  'Settings > User Tools > ODBC Data Sources'.

The ODBC Data Source Administrator window displays.

2

The DSN can be saved as either a User or System DSN, if you have administrator privileges on the local machine then we would suggest saving the DSN  as a System DSN, otherwise your only option is to create a User DSN.

3

Click on the Add button.

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

4

Select 'PostgreSQL UNICODE' from the list.

5

Click on the Finish button.

The 'Postgre SQL Connector/ODBC' dialog displays.

6

Enter these configuration details:

• Data Source: a unique name for the connection
• Description: (optional) description of the DSN
• Database: The database name on the selected server
• Server: The host name or IP address of the MariaDB server
• Port: The Port that the PostgreSQL server is listening to
• User and Password: database user credentials

7

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.

8

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.

9

Click on the OK button to close the Advanced Options screen.

10

Click Test and if successful, click on the OK button to complete the configuration.

If the test does not succeed, review your settings.

1

Open the 'Data Link Properties' dialog using one of these methods:

• Keyboard Shortcut:  Ctrl+O : Connect to Server
• Start Page | Server Connection (direct to 'Open Server Connection' dialog)
• | Open Project : Connect to Server
• Start Page : Manage Projects : Connect to Server

2

On the Provider tab select 'Microsoft OLE DB Provider for ODBC Drivers', click  [Next >>]

3

Select the ODBC DSN in the 'Use data source name' combo, click  Test Connection.

4

Once step 3 is successful, click [OK] to open the repository.

If the test does not succeed, review your settings.