Connect to a PostgreSQL Data Repository

 Return to Introduction  Previous page  Next page

Note: This feature is available in the Corporate edition only.

In order to use a PostgreSQL data repository, you must connect to it in Enterprise Architect first. Before connecting to the repository, you must have set up a PostgreSQL ODBC driver. To connect to a PostgreSQL data repository in Enterprise Architect, follow the steps below:

1.In the Open Project dialog, select the Connect to Server checkbox, or on the Start Page, click on the Connect to Server Repository link.
2.Click on the  [...] (Browse) button, as you normally would to browse for a project. As you have selected the Connect to Server checkbox, the Data Link Properties dialog displays instead of the Browse Directories dialog.
 
PostgreDataLink-Provider
 
3.Select Microsoft OLE DB Provider for ODBC Drivers from the list.
4.Click on the Next button. The Connection tab displays.
 
PostgreDataLink-Connection
 
5.Click on the Use data source name drop-down arrow and, from the list, select the ODBC driver you have set up to connect to your PostgreSQL repository.
6.Click on the Test Connection button to confirm that the details are correct.
7.If your test succeeded, click on the OK button.
8.If your test did not succeed, revise your settings.
9.After you have clicked on the OK button, the Connection Name dialog displays. Give the connection a suitable name so that you can recognize it in the Recently Opened Projects list on the Open Project dialog.
 
PostgreConnName
 
10.Click on the OK button to complete the configuration.