Creating and Managing Metadata Repositories

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 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, one can create a repository backup and restore repository from backup.

The Repository Manager utility is used to facilitate repository creation and management in Windows OS.

The repository manager is a tool used by the application administrator to automate updating of Foresight Analytics Platform versions, repository and MDM repository versions.

There are two implementations of the repository manager depending on the operating system in use:

Starting from the version 10.10, new repositories based on PostgreSQL DBMS use the BYTEA data type by default. Repositories that were created in earlier versions of Foresight Analytics Platform and that use the LO data type are supported without restrictions. If required, one can set up a repository to work with the BYTEA data type instead of LO. For details see the Setting Up Repository to Work with the BYTEA Data Type instead of LO section.

If the repository was created in FlyBI, to connect it to Foresight Analytics Platform, see the Connecting Repository Created in FlyBI section.