All Products
Search

This Product

    Dataphin:Initialize the metadata warehouse with GaussDB (DWS)

    Document Center

    Dataphin:Initialize the metadata warehouse with GaussDB (DWS)

    Last Updated:Jun 08, 2026

    The Dataphin metadata warehouse manages business and compute engine metadata under the OPS tenant, consisting of periodic data integration, SQL script, and Shell nodes. Follow these steps to initialize the metadata warehouse with GaussDB (DWS) as the compute engine.

    Limits

    Only accounts with the metadata warehouse tenant super administrator or system administrator role can initialize the system.

    Important

    Keep the metadata warehouse tenant super administrator or system administrator credentials secure. Proceed with caution when logged in as the metadata warehouse tenant super administrator.

    Procedure

    1. On the Dataphin home page, choose Management Center > System Settings from the top menu bar.

    2. In the navigation pane on the left, choose System O&M > Metadata Warehouse Settings.

    3. On the Metadata Warehouse Settings wizard, click Start.

    4. In the Engine Type step, select GaussDB(DWS).

      Important

      If the metadata warehouse is already initialized, the last successful configuration is preselected. Switching to an incompatible compute engine may make the administration feature unavailable.

    5. Click Next.

    6. On the Parameter Checking page, configure the GaussDB (DWS) compute engine parameters.

      Parameter

      Description

      Version

      Only version 9.1.0 is supported.

      JDBC URL

      The JDBC URL of the target database. Example: jdbc:postgresql://host:port/database.

      Schema

      The GaussDB (DWS) schema name.

      Username, Password

      The username and password for the target database.

      Metadata Production Project

      The logical project for metadata production. Set to dataphin_meta. Do not change the name during re-initialization, or initialization fails.

    7. Click Test Connection. If the test is successful, click Next.

    8. On the initialization page, click Start.

      Note

      The initialization process takes about 15 minutes.

    9. After the success message appears, click Finish.

    What to do next

    After initialization, configure the compute engine for the Dataphin instance in Compute settings. With GaussDB (DWS) as the metadata warehouse engine, the business tenant compute engine must be AnalyticDB for PostgreSQL or GaussDB (DWS).