Installing and Configuring Database Access for MySQL

Installing the SQL Client Tools for MySQL

For MySQL, install the required MySQL client tools and define all necessary configuration parameter as described in the MySQL installation guide.

Note the following hints:

• On the MySQL pages you will find a tutorial, that helps you with making first steps with MySQL.

• Add the MySQL lib directory to the PATH variable before starting MagicDraw. Otherwise this variable won't be visible for the embedded xUML RUNTIME.

Defining the MySQL Database Preferences on the Bridge

In a browser, open the Web-based user interface of the system, on which the Bridge is installed (see Checking the Installation). Enter a user id and password of a user with administration rights (the pre-defined user admin, for instance).
The welcome page is displayed.

In the Navigation, select the xUML Services item of the node instance you want to define the database preferences for and switch to tab Preferences:

Now, you can define the SQL adapter preferences for each database type. Select the DB2, Oracle, MySQL, or MSSQLServer Adapter in the drop down box and the parameters of the selected adapter are displayed.

Select the MySQL Adapter, enter the following parameter and click Apply.

You do not have to set this parameter, if the path is already defined in the system environment.