Prev Next

Native Connection to Oracle Repository

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

Prerequisites

  • A Oracle database server
  • A Enterprise Architect repository defined in the Oracle database server
  • You know the database user credentials that have SELECT, INSERT, UPDATE, DELETE, and 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 Oracle option

3

Fill in the details of the repository, including:

  • Server Name: The host name or IP address of the Oracle server
  • Database Name: The database name on the selected server (in more recent versions of Oracle call the pluggable database)
  • Port: The port that the Oracle server is listening to
  • User and Password: database user credentials

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.

Note - Minimum requirements are:

  • Windows 8 (earlier versions doesn't support the underlying database driver, if you require connectivity from Windows 7 then you will need to use OLEDB or ODBC)

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