Connect to a MySQL Data Repository

To access a project in your MySQL data repository, you must connect to the data repository from Enterprise Architect.

Prerequisites

The MySQL repository and the project already exist

You have SELECT, INSERT, UPDATE, DELETE, EXECUTE and SHOW VIEW access permissions

The MySQL ODBC driver has been set up

Access

Ribbon

: Open Project

Keyboard Shortcuts

Ctrl+O

Connect to the repository

Step

Action

1

In the 'Open Project' dialog, select the 'Connect to Server' checkbox.

2

Click on the button.

The 'Data Link Properties' dialog displays.

3

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

4

Click on the Next>> button.

The 'Connection' tab displays.

5

Click on the 'Use data source name' radio button and on the drop-down arrow in its field.

From the list, select the ODBC driver you have set up to connect to your MySQL repository.

6

If required, type in a User name and Password.

7

If required, type in an initial catalog.

8

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

9

If the test does not succeed, revise your settings.

If the test succeeds, click on the OK button; the 'Connection Name & Type' dialog displays.

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.

With this setting, the 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 and open the project.

This also adds the project name to the 'Recent' list on the 'Start Page'; from now on, you can open the project again just by clicking on this name.

Notes

This feature is available in the Corporate, Business and Software Engineering, System Engineering and Ultimate editions of Enterprise Architect