| 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)
- An Enterprise Architect repository defined in the PostgreSQL database server
- You know the database user credentials that have SELECT, INSERT, UPDATE, DELETE, EXECUTE access permissions to the Enterprise Architect repository
Access
|
Keyboard Shortcuts |
: Connect to Server |
|
Other |
Start Page | Server Connection (direct to 'Open Server Connection' dialog)
Start Page : Manage Projects : Connect to Server |
| Open Project : Connect to ServerConnect 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 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