PostgreSQL Data Repository

Note:

This feature is available in the Corporate, Business and Software Engineering, System Engineering and Ultimate editions.

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 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 & Type dialog displays.
     
    PostgreConnName1
     
  10. Give the connection a suitable name so that you can recognize it in the Recent Projects panel on the Open Project dialog.
  11. If required, select the Encrypt Connection String checkbox. This encrypts and hides the connection details of the database from the users that the connection string is given to.
  12. If required, select the Lazy Load checkbox to not load the full project view when the model is loaded. Instead, only the parts that are necessary to display the visible portion of the tree are loaded. This means that a model loads faster and users can begin work sooner, but at the expense of later small delays as Enterprise Architect loads specific portions of the model.
  13. If required, select the Use WAN Optimization checkbox. (To improve performance over a Wide Area Network, remote database calls can be routed through a WAN Optimizer that compresses the data returned from the repository, reducing transfer time.)
     
    If you select this checkbox, complete the next three fields (see your administrator for the correct values). Otherwise go to step 17.
  14. In the Server field, type the network name or address of the optimizer server.
  15. In the Port field, type the port on which the server is running on the remote machine.
  16. In the DSN field, type the data source name of the database as it appears on the remote machine.
  17. Click on the OK button to complete the configuration.