Help Center/ GaussDB(DWS)/ Best Practices/ Data Migration/ Using CDM to Migrate Oracle Data to a DWS Cluster/ Migrating Full Table Data/ Configuring a DWS Data Source Connection
Updated on 2025-09-08 GMT+08:00
View PDF
Share

Configuring a DWS Data Source Connection

  1. Create a CDM cluster and bind an EIP to the cluster by referring to Creating a CDM cluster.

    Ensure that the CDM cluster and the DWS cluster are in the same region and VPC to ensure network connectivity.

  2. Log in to the CDM console, choose Cluster Management. Locate a cluster, click Job Management in the Operation column, and choose Links > Create Link.
  3. Select Data Warehouse Service and click Next.
  4. Configure the DWS connection, click Test. If the connection is successful, click Save.

    Table 1 DWS connection information

    Parameter

    Value

    Name

    dws

    Database Server

    Click Select and select the DWS cluster to be connected from the cluster list.

    NOTE:

    The system automatically displays the DWS clusters in the same region and VPC. If no DWS cluster is available, manually enter the IP address of the DWS cluster that has been connected to the network.

    Host Port

    8000

    Database Name

    test

    User Name

    dbadmin

    Password

    Password of user dbadmin

    Use Agent

    No

Parent Topic: Migrating Full Table Data