Please note : This help page is not for the latest version of Enterprise Architect. The latest help can be found here.
Set up a PostgreSQL ODBC Driver
After you have created a repository on your PostgreSQL database, you set up the PostgreSQL ODBC driver so that you can connect to a project on that repository from Enterprise Architect.
Prerequisites
Install:
| • | PostgreSQL DBMS and repository |
| • | PostgreSQL ODBC driver software version 7.03.01.00 or above (note that versions 8.3.4 and 8.4.1 of the PostgreSQL ODBC Driver are not supported) |
Set up the ODBC driver
Step |
Action |
||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 |
If you are using a 32-bit operating system:
If you are using a 64-bit operating system:
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 the following configuration details:
|
||||||||||||
6 |
To set the advanced options, click on the Datasource button and set the options on Page 1 and Page 2 as shown below:
|
||||||||||||
7 |
If you are using PostgreSQL version 8+, on Page 2 select:
|
||||||||||||
8 |
Click on the OK button to complete the configuration.
|
Your PostgreSQL driver is now available to connect to the repository from Enterprise Architect.
Learn more
