Set Up the Configuration Microservice Metadata Store or Repository

This applies to: Visual Data Discovery

Before you can install and start Symphony's configuration microservice, you must set up a PostgreSQL metastore or a GitHub repository to store Symphony property metadata. A separate PostgreSQL database or a separate GitHub repository must be configured.

See the following sections:

PostgreSQL Database Setup Notes

If you elect to persist property metadata to a PostgreSQL metastore:

  1. Configure a separate database and make it accessible to the connection user account:

    CREATE DATABASE <composer-config> WITH OWNER <db_username>;

    where <composer-config> is the name of the PostgreSQL database and <db_username> is the connection user account name.

  2. Add the following properties to the Symphonyconfig-server.properties file, located in the /etc/zoomdata directory:

    # metadata storage settings
    spring.datasource.url=jdbc:postgresql://localhost:5432/<composer-config>
    spring.datasource.username=<db_username>
    spring.datasource.password=<db_password>

    Substitute the connection user account name and password you set up in Step 1 for <db_username> and <db_password>. Substitute the name of the PostgreSQL database for <composer-config>.

  3. Save the properties file. You will restart the configuration microservice when you configure it. See Configure and Start the Configuration Microservice.

GitHub Repository Setup Notes

If you elect to persist property metadata to a GitHub repository:

  1. Add the following properties to the Symphonyconfig-server.properties file, located in the /etc/zoomdata directory:

    # metadata storage settings
    spring.cloud.config.server.git.uri=<repo_uri>

    spring.cloud.config.server.git.skipSslValidation=true

    spring.cloud.config.server.git.username=<repo_username>

    spring.cloud.config.server.git.password=<repo_password>

    Substitute the repository user account name and password for <repo_username> and <repo_password>. Substitute the URI of the repository for <repo_uri> (for example, https://example.com/my/repo).

    Additional and advanced configuration information can be found in Spring.io's documentation.

  2. Save the properties file. You will restart the configuration microservice when you configure it. See Configure and Start the Configuration Microservice.