All Products
Search

This Product

    Dataphin:Initialize the metadata warehouse using GaussDB (DWS) as the metadata warehouse engine

    Document Center

    Dataphin:Initialize the metadata warehouse using GaussDB (DWS) as the metadata warehouse engine

    Last Updated:Nov 18, 2025

    The Dataphin metadata warehouse manages business and compute engine metadata in Dataphin. It is part of a Dataphin project under the OPS tenant and consists of periodic data integration nodes, SQL script nodes, and Shell nodes. Initializing the metadata warehouse involves configuring the compute engine type for the Dataphin system and initializing the metadata. This topic describes how to initialize the metadata warehouse using 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

    You must safeguard the username and password for the metadata warehouse tenant super administrator or system administrator account. After you log on to the system with the metadata warehouse tenant super administrator account, proceed with caution.

    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. In the Metadata Warehouse Settings configuration wizard, click Start.

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

      Important

      If the metadata warehouse is already initialized, the last successfully initialized configuration is selected by default. If you switch to an incompatible compute engine, the administration feature may become unavailable.

    5. Click Next.

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

      Parameter

      Description

      Version

      Only version 9.1.0 is supported.

      JDBC URL

      Enter the Java Database Connectivity (JDBC) URL for the target database. For example, jdbc:postgresql://host:port/database.

      Schema

      Enter the schema information for GaussDB.

      Username, Password

      The username and password for the target database.

      Metadata Production Project

      The logical project for metadata production and processing. Set this to dataphin_meta. Keep the name unchanged during re-initialization. Otherwise, the 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 a success message is displayed, click Finish to complete the configuration.

    What to do next

    After you initialize the system's metadata, you can set the compute engine for the Dataphin instance. When the metadata warehouse engine is set to GaussDB (DWS), the compute engine for a business tenant can only be set to AnalyticDB for PostgreSQL or GaussDB (DWS). For more information, see Compute settings.