Prev Next

Native Connection to PostgreSQL repository

In most installations users will be able to create native connections to PostgreSQL database without the need to install or configure any other software.

Prerequisites

  • A PostgreSQL database server (v9 or later)
  • A Enterprise Architect repository defined in the PostgreSQL database server
  • You know the database user credentials that has SELECT, INSERT, UPDATE, DELETE, EXECUTE access permissions to the Enterprise Architect repository

Access

Keyboard Shortcuts

Ctrl+O : Connect to Server

Other

Start Page | Server Connection (direct to 'Open Server Connection' dialog)

Project list | Open Project : Connect to Server

Start Page : Manage Projects : Connect to Server

Connect to Repository

Step

Action

See also

1

In Enterprise Architect, open the 'Open Server Connection' screen ('Project list | Open Project : Connect to Server' ribbon option).

2

Select the PostgreSQL option

3

Fill in the details of the database, including Server Name, Port, Database Name, Database User and Password

4

Click the [Test] button.  A "Connection Successful" popup message should be displayed, including a summary of the server's version details.

If the connection is not successful, the message should include a hint or reason why it failed, the reason(s) listed will need to be corrected before continuing.

5

Once step 4 succeeds the OK button will be enabled, click [OK] to open the repository.

Notes

  • Connecting to DBMS based Repositories is available in the Corporate, Unified and Ultimate Editions of Enterprise Architect

Learn more