A repository is the entity that holds your architecture. It is a database instance that collects together everything that makes up your architecture.
When you start MooD, it is Repository Manager that starts first. Repository Manager knows what servers you have, and lists the repositories on them. Use it to:
- Manage your MooD licence. If you need to install a licence, open Repository Manager as an administrator (right click and select Run as administrator).
- Open a repository in Business Architect.
- See repository details such as size and last modified time.
- Create, rename, remove (hide) or delete repositories.
- Upgrade repositories when you get a version of MooD with a new schema. If you install a new version and all your repositories appear brown (sepia), it is due to a change in schema. See About schemas (page 7) for more details.
- Publish repository content as a static website.
- Create backups (SQL Server only).
- Merge repositories by integrating one into another.
- Validate and repair the data within a repository. Validation is a recommended step prior to making a repository available on the web using Active Enterprise. Validation can also help resolve structural issues within a database.
Repositories exist on servers. In MooD, servers are database servers, not just physical servers.
You can have multiple servers, and each server can have multiple repositories on it. In Repository Manager, you have the concept of a default server. The simplest way to create a repository creates it on the default server.
Repository Manager’s Servers tab lets you manage what servers Repository Manager knows about, and which repositories on each server are shown on the Repositories tab.
Note: When you open Repository Manager for the very first time, it won’t know about any servers and, consequently, won’t list any repositories. If this is the case, see Adding a database server on page 38.
About schemas (brown (sepia) repository icons)
All builds of MooD and consequentially all MooD repositories have an underlying schema. This is the database structure it is built upon. The MooD schema changes less frequently that the MooD build. Builds introduce features and fixes on top of a schema. Hence, a schema can support several builds. The schema only changes when a new feature requires a change to the underlying database.
Repositories that do not match the schema of your current build appear in shades of brown (sepia) and cannot be opened in your version of MooD unless upgraded to the same schema.
- Before upgrading, take a backup and make sure the repository is not being used by other users.
- Once a repository has been upgraded to a new schema, you cannot open it in a version of MooD with an earlier schema.
To upgrade, highlight the repository and then select Upgrade (it is one of the few commands available to you).
Note: If you have a repository that appears brown and you are not given the Upgrade option, the repository is on a newer schema than your current installation. You will not be able to open this repository unless you get a newer version of MooD itself.
Mandating a Build
Business Architect includes a complementary feature called mandate. This lets you specify a specific MooD build (version of Business Architect) that the repository must be edited with. If you try and open a repository on a different build (but same schema), Business Architect warns you but will let you proceed. Mandating a build helps development teams ensure they always work on a set build of Business Architect. Mandating is optional and can be found (in Business Architect) under File > Manage Repository > Mandate a Build of Business Architect.
SQL Server permissions required by MooD
Repository Manager makes use of SQL Server users when creating and maintaining repositories in SQL Server. The SQL Server permissions required by MooD are:
- DBCreator to create repositories. This is a global SQL Server permission.
- dbo to reindex or upgrade repositories. This is a per database SQL Server permission.
- repname_role to manage data within the repository. This is a SQL Server role per database.
If you are using Windows Authentication, the user must have the necessary SQL Server permissions. Many support issues regarding repository maintenance are caused by the user not having the necessary SQL Server permissions to perform tasks. Your database administrator should be able to advise you about the permissions your username has.
Starting Repository Manager
Repository Manager is a Windows application. When it is installed, a desktop shortcut is created for it:
Double-click the icon to start Repository Manager.
If you are running for the first time and need to install a licence, right click and select Run as administrator. Use the File tab to install a licence (see page 13).
Note: If you do not have a desktop shortcut, use the Start menu to find and open the MooD 15 program.
Repository Manager typically opens at its Repositories tab. This lists the repositories you can see.
Note: When you open Repository Manager for the very first time, it won’t know about any servers and, consequently, the Repositories tab won’t list any repositories.
If all your repository icons appear brown (sepia), the schema has changed.
Importing older repositories when Repository Manager starts On starting, if Repository Manager detects older (pre MooD 15) repositories (including Access repositories), it displays this message:
If you import the detected repositories, they will appear in an Imported Repositories group on the Repositories tab. You can then upgrade imported repositories as required.
If you choose not to import repositories, Repository Manager will continue to offer the option on opening unless you select the check box disabling this. Even then, you can use the Connection and Access tabs on the expanded Add Repository dialog box to find, import, and upgrade older repositories.
Opening a repository in Business Architect
Often you will only use Repository Manager to open a repository in Business Architect.
Task 1 To open a repository in Business Architect:
- On the Repositories tab, do one of the following:
- Double-click the repository.
- Right-click the repository, and then click Open in Business Architect.
- Click the repository (this selects it), and then, in the list of commands on the right hand side of the Repositories tab, click Open in Business Architect.
The Open dialog box is displayed.
- Type your password, then click OK.
Note: If you have not been given a password, try opening without a password before you contact your system administrator.
Business Architect will open the repository. You will see a progress message.
If you would like to read more please click on the attachment.