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

Configuring an Oracle Data Source Connection

To migrate data from Oracle to GaussDB(DWS), you need to configure an Oracle data source connection first.

Procedure

  1. On the Cluster Management page, click Job Management in the Operation column of the cluster and choose Links > Driver Management.

  2. Click Upload on the right of ORACLE, select an Oracle driver package (if no driver package is available on the local PC, download it by referring to Managing Drivers), and click Upload.

  3. On the Cluster Management page, click Job Management in the Operation column of the cluster and choose Links > Create Link.
  4. Select Oracle as the connector and click Next.
  5. Configure the Oracle connection, click Test. If the connection is successful, click Save.

    Table 1 Oracle connection information

    Parameter

    Value

    Name

    oracle

    Database Server

    192.168.1.100 (This is an example. Enter the actual public IP address of the Oracle database.)

    Host Port

    1521

    Connection Type

    Service Name

    Database Name

    orcl

    User Name

    db_user01

    Password

    -

    Use Local API

    No

    Use Agent

    No

    Oracle Version

    Later than 12.1