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

Configuring a GaussDB(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 GaussDB(DWS) cluster are in the same region and VPC to ensure network connectivity.

  2. On the Cluster Management page, click Job Management in the Operation column of the cluster and choose Links > Create Link.
  3. Select Data Warehouse Service and click Next.
  4. Configure the GaussDB(DWS) connection, click Test. If the connection is successful, click Save.

    Table 1 GaussDB(DWS) connection information

    Parameter

    Value

    Name

    dws

    Database Server

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

    NOTE:

    The system automatically displays the GaussDB(DWS) clusters in the same region and VPC. If no GaussDB(DWS) cluster is available, manually enter the IP address of the GaussDB(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