Link Reference Data to a Shared Repository

If you have a number of projects that use the same sets of reference data, you can use a central project containing that common data as a shared repository. The common data includes system resources such as as Security Users and Groups, Glossary terms or Data Types.  Shared repositories make it possible for teams working on multiple projects to leverage a common and consistent set of system resources. Common standards and definitions can be applied across all projects using this repository. Any time a new project is started, that project can automatically inherit some or all of these common resources from the repository; there is no need to establish these resources again for each project.

Shared repositories apply to Database Management System (DBMS) based Enterprise Architect projects and can link all projects residing within one DBMS.

A new DBMS based project in Enterprise Architect is initially created with its own stand-alone repository.  A single step process then allows that new project to be linked to the shared repository residing on its DBMS. Any older or pre-existing Enterprise Architect projects can also be linked to the shared repository, taking their resource data from the master version. This then allows for centralized management of the contents of the repository, promoting or enforcing common usage and standards.

Any changes to the shared repository are automatically available to every participating project.

Access     Tools | Data Management | Shared Repository

Set up a shared repository

Step

Action

See Also

1

Create the script file to set up the shared repository, as explained in the next table.

 

 

2

Execute the generated SQL script using a third-party tool.

 

 

Select the repository tables to share

Field/Button

Action

See also

Script File

Type in or browse ( ... ) to the location into which the script file will be generated by this dialog.

 

 

Main Repository

Type in the name of the current main repository.

 

 

Shared Repository

Type in the name of the database to be used as the shared repository.

This name cannot be the same as the name of the main repository.

 

 

Table Groups

In the list of table groups that can be linked to the shared repository, select the checkbox against each table group to share in the repository.

 

 

Tables in each group

(Read only) Review the list of database tables in the currently-selected table group. All of these tables in the selected group will be available through the shared repository.

 

 

Generate

Click on this button to generate the SQL script to link the selected tables of the current (main) repository to the shared repository. The script is generated into the file location you specified in the Script File field.

 

 

View Script

Click on this button to open the generated script file in the default Code Editor, and to close the dialog.

 

Editing Source Code

Close

 

Click on this button to close the dialog.

 

Notes

This feature is not applicable to projects that are based on local project files (.eap or .feap)
Shared repositories are supported for MySQL, SQL Server and Oracle