Please note : This help page is not for the latest version of Enterprise Architect. The latest help can be found here.

Prev Next

Set up a MariaDB ODBC Driver

After you have created a repository on your MariaDB database, you set up the MariaDB ODBC driver so that you can connect to a project on that repository from Enterprise Architect.



  • MariaDB DBMS and repository
  • MariaDB ODBC driver software

Set up the ODBC Driver

Your MariaDB driver is now available to connect to the repository from Enterprise Architect.




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.


Click on the Add button.

The 'Create New Data Source' dialog displays, enabling you to add a new DSN.


Select the appropriate MariaDB ODBC Driver from the list.


Click on the Finish button.

The 'MariaDB Connector/ODBC' dialog displays.


Enter these configuration details:

  • A data source name for the connection
  • A description (optional)
  • The host address of the DBMS server
  • User name and password
  • The database name on the selected server


To set the advanced options, click on the Details>> button.


Select these checkboxes (where provided):

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


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


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

If the test does not succeed, review your settings.

Learn more