Topic
Prev Next

Set up a Joomla! ODBC Link

After you have created a Joomla! repository in your MySQL database, you must set up the MySQL ODBC driver so that you can connect to this repository from Enterprise Architect and publish model contents as Articles.

Prerequisites

Install:

  • MySQL DBMS (this will be part of the XAMPP installation)
  • MySQL ODBC driver software version 5.3.4 or higher

Set up the ODBC Driver

Your MySQL ODBC driver is now available to connect to the Joomla! Repository from Enterprise Architect.

Step

Action

1

Under both 32-bit and 64-bit operating systems, Enterprise Architect requires 32-bit ODBC drivers to connect to a repository through ODBC. You can quickly load the correct 32-bit ODBC Data Source Administrator by selecting the 'Configure > User Tools > ODBC Data Sources' ribbon option.

The ODBC Data Source Administrator window displays.

2

Click on the Add button. The 'Create New Data Source' dialog displays, through which you add a new DSN.

3

Click on the appropriate MySQL ODBC driver in the list, and click on the Finish button.

The 'MySQL Connector/ODBC' dialog displays.

4

Enter these configuration details:

  • A data source name for the connection
  • (Optional) a description of the connection
  • The host address of the DBMS server - – if you have installed MySQL DBMS using XAMPP, then the host address and port can be determined as boxed and underlined, respectively, in green on these control panels:

  • User name and password (the default user name for a MySQL repository is root with no password)
  • The database name on the selected server - this name will be the name of the Joomla! folder you created when you installed Joomla! locally

5

Click on the Details>> button to set the advanced options.

6

Select these checkboxes (where provided):

  • 'Return matched rows instead of affected rows' ('Conversion' or 'Cursors/Results' tab)
  • 'Allow big result sets' ('Connection' tab)

7

Click on the Test Connection button to confirm that the configuration is correct.

8

If the test succeeds, click on the OK button to complete the configuration.

If the test fails, review your settings.

Learn more