Metadata Repository

This applies to: Visual Data Discovery

Metadata is any data that is used for the configuration and runtime operation of the Symphony application, with the exception of customer-managed data stores. The metadata repository is simply the relational database instance containing the Symphony schemas. The primary metadata schema includes configurations for:

• dashboards, visuals, and filters
• data store connectivity
• data source configurations and statistics
• enterprise authentication, accounts, users, groups, and permissions.

The metadata repository also contains separate schemas for storing raw data, which supports upload and keyset functionality. Note that the metadata schema definitions and the stored data are internal to the Symphony application; they are not intended for direct manipulation.

Symphony uses relational database technology for metadata storage, and ships with an open-source PostgreSQL 12 database. Symphony strongly recommends using this instance due to the specific configuration and version employed. If you would like to use another PostgreSQL instance, contact Technical Support for further guidance.

Internally, industry-standard technologies are used for database connectivity, object-relational mapping, and schema changes that are executed during Symphony software upgrades. The database administrator can use well-known tools and procedures for backing up and restoring the entire metadata repository. The administrator is responsible for setting up authenticated access from the Symphony server to the database.