All Products
Search

This Product

    Dataphin:Initialize the metadata warehouse using AnalyticDB for PostgreSQL as the compute engine

    Document Center

    Dataphin:Initialize the metadata warehouse using AnalyticDB for PostgreSQL as the compute engine

    Last Updated:Jun 23, 2026

    The Dataphin metadata warehouse (meta warehouse) centrally manages internal business metadata and compute engine metadata within an OPS tenant project space. It consists of periodic data integration nodes, SQL script nodes, and Shell nodes. You can initialize the meta warehouse with AnalyticDB for PostgreSQL as the compute engine.

    Limits

    Initialization can only be performed by accounts with the metadata warehouse tenant super administrator or system administrator role.

    Important

    Keep the credentials of the metadata warehouse tenant super administrator or system administrator secure. Use caution when you perform operations as the metadata warehouse tenant super administrator.

    Procedure

    1. In the top menu bar of the Dataphin homepage, select Management Center > System Settings.

    2. In the navigation pane on the left, select System Operations > Metadata Warehouse Settings.

    3. In the Metadata Deployment configuration wizard, click Start.

    4. On the Select Initialization Engine Type page, select AnalyticDB for PostgreSQL as the engine type, and then click Next.

      Important

      If the metadata warehouse was previously initialized, the last successful configuration is used by default. Switching to an incompatible compute engine may make the administration feature unusable.

    5. Configure the AnalyticDB for PostgreSQL compute engine parameters on the Parameter Checking page.

      Parameter

      Description

      Version

      Select 6.x or 7.x. Default: 6.x.

      JDBC URL

      The JDBC connection address of the target database, such as jdbc:mysql://host:port/dbname.

      Schema

      The schema name for AnalyticDB for PostgreSQL.

      Username, Password

      The username and password of the target database.

      Meta Project

      The logical project space for metadata production and processing. We recommend that you set this to dataphin_meta. Use the same name during reinitialization to prevent failure.

    6. Click Test Connection. After the test succeeds, click Next.

    7. On the Initialization page, click Start.

      Note

      The initialization takes approximately 15 minutes.

    8. After the system shows successful execution, click Finish.

    What to do next

    After the metadata warehouse is initialized, configure the compute engine for the Dataphin instance. If the metadata warehouse engine is set to AnalyticDB for PostgreSQL, the business tenant engine can only be set to AnalyticDB for PostgreSQL or GaussDB (DWS). For more information, see Compute engine settings.