Prev | Next |
Create a Project in a MariaDB Database
To create a project in a MariaDB repository, you work through these stages:
- Stage 1: Create an empty database repository and set up the data tables
- Stage 2: Set up the ODBC Driver
- Stage 3: Set up initial model data
Prerequisites
- A machine with MariaDB version 10.1.2 or higher installed and running,
- MySQL ODBC
1. Create a MariaDB Repository
Step |
Action |
See also |
---|---|---|
1.1 |
Create a new empty database and configure it to your installation's defaults. |
Create a MariaDB Repository |
1.2 |
Open your SQL management console of choice (such as HeidiSQL) and connect to the new database. |
|
1.3 |
Load the EASchema_1220_MySQL.sql file from the Sparx Systems website. |
|
1.4 |
Run EASchema_1220_MySQL.sql to create the required database schema. |
2. Set up the ODBC DSN
Step |
Action |
See also |
---|---|---|
2.1 |
Create a suitable ODBC Data Source (using the MySQL ODBC driver and NOT the MariaDB driver), to the new database. Making sure to select the extended option:
|
Set up a MariaDB ODBC Driver |
3. Set up Initial Data
Enterprise Architect repositories requires a basic amount of reference data to function correctly.
Setting up this initial data can be achieved in 2 different ways:
- Transferring the entire contents of an existing model into the new database, or
- Load Initial data using a SQL Script
3.1. Load Initial Data - Transfer existing model
If you choose to set up your new database with the contents of an existing model, then Sparx Systems recommend that a Project Integrity check is performed on the existing model to ensure it is 'clean' and free from data-related errors before being copied into the new database.
The Enterprise Architect installation provides a model specifically for this purpose; the model is copied into the installation folder and is called EABase.eap. However, if you have customized the various drop-down lists in another model then you might prefer to use that. Regardless of what model you choose to use the process is the same and is outlined here.
Step |
Action |
See also |
---|---|---|
3.1.1 |
In Enterprise Architect, open the existing repository and select 'Configure > Model > Integrity > Project Integrity' in the ribbon. |
Check Project Data Integrity |
3.1.2 |
Ensure that the Action is set to 'Report Only' and that all items in 'Checks to Run' are enabled, then click the . |
|
3.1.3 |
If Enterprise Architect detects that the existing model contains integrity issues then these will be listed, these should be corrected before continuing with the Project Transfer. |
|
3.1.4 |
With Enterprise Architect open, ensure that it there is no Project loaded, by selecting 'Close Project' from the |
|
3.1.5 |
Select the 'Configure > Model > Transfer > Project Transfer' ribbon option. The 'Project Transfer' dialog displays. |
|
3.1.6 |
In the 'Transfer Type' panel, select 'File to DBMS'. |
|
3.1.7 |
In the 'Source Project' field, click on the If the .EAP file has Replication enabled, this must be removed before performing the transfer. |
Remove Replication |
3.1.8 |
At the right of the 'Target Project' field, click on the The 'Datalink Properties' dialog displays. |
|
3.1.9 |
Select 'Microsoft OLE DB Provider for ODBC Drivers' from the list. Click on the . |
|
3.1.10 |
In the 'Use Data source name' field, click on the drop-down arrow and select the ODBC Data Source you configured to point to your new database. Click on the . The 'Project Transfer' dialog redisplays. |
Set up a MariaDB ODBC Driver |
3.1.11 |
If required, select the 'Logfile' checkbox and type a path and filename for the data transfer log file. |
|
3.1.12 |
Click on the to begin the data transfer process. |
|
3.1.13 |
When the process is complete, you have created a project on a MariaDB database and can now connect to it and open it from Enterprise Architect. |
Connect to a MariaDB Repository |
3.2. Load Initial Data - SQL Script
The Sparx Systems website provides a SQL Script that contains a series of INSERT statements that will load an empty database with all the data needed by Enterprise Architect.
Step |
Action |
See also |
---|---|---|
3.2.1 |
Open your SQL management console of choice (such as HeidiSQL), connect to the new database. |
|
3.2.2 |
Load the EABase_1220_MySQL.sql file from the Sparx Systems website. |
|
3.2.3 |
Run EABase_1220_MySQL.sql to create the required database schema. |