A repository manager is a tool used by the application administrator to automate updating of Prognoz Platform 9 versions and repository or MDM repository versions of Prognoz Platform 9.
A repository is a warehouse for system and service information about Prognoz Platform 9 objects: tables, dictionaries, cubes, and so on.
The contents of Prognoz Platform 9 repository can change in later versions. It is recommended to update repositories after a new version of Prognoz Platform 9 to use new capabilities. All the information about the latest repository structure is stored in files with the RM4 extension.
Requirements for working with repository manager:
All repository operations are executed using the repository manager, which is included in the PP9Full.exe and PP9BIServer.exe packages.
To start the program:
Load the RepoMngr.exe file from the folder with installed Prognoz Platform 9.
Select the Repository Manager item in the Windows menu: select the All Programs > Prognoz Platform 9.
The repository manager dialog box opens:
The Metadata Repository tab contains the following operations:
Create Metadata Repository. The operation is used to fill the prepared database with the system tables required for the proper functioning of Prognoz Platform 9. All information about the structure of database objects is stored in the system tables. System tables form a metadata database, while the data itself is stored in the database. Initially, any database is empty. To fill the database with system tables, create a Prognoz Platform 9 repository. To create a new repository, use the file with the *.rm4 extension, in which executable scripts are stored. This file is included in the standard setup package and is located at S\Rm\current.rm4, where S is a path to the folder with installed Prognoz Platform 9.
Update Metadata Repository Version. The contents of Prognoz Platform 9 repository may change in later versions. Updating the repository version may require the use of new capabilities. System tables are automatically modified based on the information in the *.rm4 file, which stores executable scripts. This file is included in the standard setup package and is located at S\Rm\current.rm4, where S is a path to the folder with installed Prognoz Platform 9. This function is used to update Prognoz Platform 9 system tables according to the changes and improvements made in the executable Prognoz Platform 9 unit.
Create Metadata Repository Backup. Creating a repository backup might be needed to restore lost or modified data. Before creating a repository backup, create a configuration file, which includes the necessary information about the structure and databases of the schema in use. To do this, connect to the schema, then select the Tools > Create Configuration File main menu item in the Object Navigator dialog box.
Restore Metadata Repository from Backup. Prognoz Platform 9 can be restored from an earlier created backup.
Create Service User of Security Subsystem. Creating the p4audit service user of the security subsystem is required to provide correct auditing and user locking. If the p4audit user has been already created, this operation grants permissions at database level (grants). SQLite DBMS does not require a service user.
Select the required operation and click the Next button. The wizard page opens.
See also: