Prev Next

Connect to a Repository via ODBC

Server based connection via ODBC (and OLE DB) have been supported in Enterprise Architect for many year and with the release of Enterprise Architect v16 this continues however they are no longer the default server based connection since they are complex to define and may involve steps being performed outside of Enterprise Architect.

Enterprise Architect supports ODBC based connections from the following list of DBMSs:

  • MariaDB
  • MySQL
  • PostgreSQL
  • Oracle

Prerequisites

  • A DBMS database server
  • A database defined in the database server with the necessary table definitions
  • You have the database user credentials that have the correct access permissions, such as SELECT, UPDATE, INSERT, EXECUTE, SHOW VIEW and DELETE
  • The appropriate ODBC driver is installed on the local machine

Access

Keyboard Shortcuts

Ctrl+O

Other

Project list: Open Project

Start Page : Manage Projects

Connect to a Data Repository Using an ODBC Driver

Step

Action

1

In the 'Open Project' dialog, click on the Connect to Server button drop-down arrow and select the 'ODBC Connection Wizard' option. The 'Data Link Properties' dialog displays.

2

Select 'Microsoft OLE DB Provider for ODBC Drivers' from the list.

3

Click on the Next>> button.

The 'Connection' tab displays.

4

Click on the 'Use data source name' radio button and, in the data field, click on the down arrow. From the list, select the ODBC driver you have set up to connect to your database repository.

5

If required, type in a user name and password.

If required (for MariaDB, MySQL), in the 'Enter initial catalog to use' field, click on the down arrow and provide an initial catalog name.

6

Click on the Test Connection button to confirm that the details are correct.

7

If the test does not succeed, revise your settings.

If the test succeeds, click on the OK button.

If appropriate (Oracle) the database prompts you for the password - type in the password.

8

The 'Connection Name and Type' dialog displays.

9

Give the connection a suitable Name so that you can recognize it in the 'Recent Projects' panel on the 'Open Project' dialog.

10

If you want to hide the connection details from anyone reviewing the connection string, select the 'Encrypt Connection String' checkbox.  This option is most useful when sharing a connection string with other users but you don't want them knowing the exact details.

11

Click on the OK button to complete the configuration and open the repository.

This also adds the Name (defined at step 9) to the 'Recent' list on the Start Page; from now on, you can open the project again just by clicking on this Name.

Notes

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

Learn more