Help Center> Data Warehouse Service (DWS)> Best Practices> Data Migration> Migrating Data From Oracle to GaussDB(DWS)> Migrating Full Table Data> Configuring a GaussDB(DWS) Data Source Connection
Updated on 2022-11-22 GMT+08:00
View PDF

Configuring a GaussDB(DWS) Data Source Connection

  1. Create a cluster and bind an EIP to the cluster. For details, see section 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