Servers and Databases

When installing Data Hub, the following databases are created:

  • STAGING. The STAGING database contains the raw data that was ingested into Data Hub for further processing.

    app serverdata-hub-STAGING, port 8010
    content databasedata-hub-STAGING
    modules databasedata-hub-MODULES
    triggers databasedata-hub-staging-TRIGGERS
    schemas databasedata-hub-staging-SCHEMAS

  • FINAL. The FINAL database contains the harmonized data, which the FINAL app server makes available to downstream applications.

    app serverdata-hub-FINAL, port 8011
    content databasedata-hub-FINAL
    triggers databasedata-hub-final-TRIGGERS
    modules databasedata-hub-MODULES
    schemas databasedata-hub-final-SCHEMAS
  • JOBS. The JOBS database contains both the logs of job activity and the traces of what happened during flow runs.
    Note: This app server shares some staging databases.
    app serverdata-hub-JOBS, port 8013
    content databasedata-hub-JOBS
    triggers databasedata-hub-staging-TRIGGERS
    modules databasedata-hub-MODULES
    schemas databasedata-hub-staging-SCHEMAS

The names of these databases are all configurable using values in gradle.properties.