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

The Dataphin metadata warehouse is a unified data warehouse that manages both internal business metadata and Dataphin compute engine metadata. Located within a Dataphin project space in the OPS tenant, it consists of periodic data integration nodes, SQL script nodes, and Shell nodes. This topic guides you through initializing the metadata warehouse using 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

Safeguard the account credentials of the metadata warehouse tenant super administrator or system administrator. Exercise caution when performing operations after logging in as the metadata warehouse tenant super administrator.

Procedure

In the top menu bar of the Dataphin homepage, select Management Center > System Settings.
In the navigation pane on the left, select System Operations > Metadata Warehouse Settings.
In the Metadata Deployment configuration wizard, click Start.
On the Select Initialization Engine Type page, select AnalyticDB for PostgreSQL as the engine type, and then click Next.
Important
If the metadata warehouse has been previously initialized, the last successful configuration will be the default. Switching to an incompatible compute engine may render the administration feature unusable.

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

Parameter	Description
Version	You can select 6.x or 7.x. The default selection is 6.x.
JDBC URL	Enter the JDBC connection address for the target database, such as `jdbc:mysql://host:port/dbname`.
Schema	Input the schema details for AnalyticDB for PostgreSQL.
Username, Password	Provide the username and password for the target database.
Meta Project	Specify the logical project space for metadata production and processing. It is advisable to set it as `dataphin_meta`. Maintain the same name for reinitialization to avoid failure.

Click Test Connection. Once the connection test is successful, click Next.
On the Initialization page, click Start.
Note
The initialization process takes approximately 15 minutes. Please wait patiently.
Once the system indicates successful execution, finalize the setup by clicking Finish.

What to do next

After the system metadata is initialized, you can set 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.