A repository is a warehouse for system and service information about platform objects: tables, dictionaries, cubes, and so on. To get started with Foresight Analytics Platform, it is required to create a metadata repository.
In later versions of as well Foresight Analytics Platform repository contents may change. To be able to use new features, it is recommended to update repositories after installing a new version of Foresight Analytics Platform. All the information about the latest repository structure is stored in files with the RM4 extension. To restore lost or modified data, it is available to create a repository backup and restore repository from backup.
To facilitate metadata repository creating and managing in Windows OS, there is a Repository Manager program.
A repository manager is a tool used by the application administrator to automate updating of Foresight Analytics Platform versions, repository and MDM repository versions.
To work with repository manager in Windows OS, it is required:
To create a metadata repository in Linux OS, use the script.
All repository operations are executed using the repository manager, which is included in the FP9Full.exe and FP9BIServer.exe packages.
To start the program:
Load the RepoMngr.exe file from the folder with installed Foresight Analytics Platform.
Select the Foresight Analytics Platform 9.2 > Repository Manager item in the Windows main menu.
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 proper functioning of Foresight Analytics Platform. 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 platform repository. To create a new repository, use the file with the *.rm4 extension, which stores executable scripts. This file is included in the standard installation package and is located at S\Rm\current.rm4 path, where S is a path to the folder with installed Foresight Analytics Platform.
Update Metadata Repository Version. In later versions of Foresight Analytics Platform repository contents may change. Updating the repository version may require the use of new capabilities. System tables are automatically changed based on the information in the *.rm4 file, which stores executable scripts. This file is included in the standard installation package and is located at S\Rm\current.rm4 path, where S is a path to the folder with installed Foresight Analytics Platform. This function is used to update platform system tables according to the changes and improvements made in the executable unit of Foresight Analytics Platform.
Create Metadata Repository Backup. Creating a repository backup might be needed to restore lost or changed 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. Platform repository 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, the operation grants permissions at DBMS level. SQLite DBMS does not require a service user.
The MDM Repository tab is used to create an MDM metadata repository and for compatibility with earlier versions, and contains the following operations:
Create an MDM metadata repository. An MDM metadata repository is used to create objects according to the top-down scheme: automatic cubes. To create an MDM metadata repository, use an *.rm4 file, which stores executable scripts. This file is included in the standard installation package and is located at S\Rm\current_RDS.rm4, where S is a path to Foresight Analytics Platform installation folder.
Update MDM metadata repository. In later versions of Foresight Analytics Platform MDM metadata repository contents may change and a version update may be required. To update MDM metadata repository, use an *.rm4 file, which stores executable scripts. This file is included in the standard installation package and is located at S\Rm\current_RDS.rm4, where S is a path to the folder with installed Foresight Analytics Platform.
Select the required operation and click the Next button. The wizard page opens.
See also: