Metadata is any data that is used for the configuration and runtime operation of the Zoomdata application, with the exception of customer-managed data stores. The metadata repository is simply the relational database instance containing the Zoomdata schemas. The primary metadata schema includes configurations for:
- dashboards, charts, 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 Zoomdata application; they are not intended for direct manipulation.
Zoomdata uses relational database technology for metadata storage, and ships with an open-source PostgreSQL 9.5 database. Zoomdata strongly recommends using this instance due to the specific configuration and version employed. If you would like to use another PostgreSQL instance, click to 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 Zoomdata version 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 Zoomdata server to the database.