Updated on 2023-06-02 GMT+08:00

Creating Oracle Data Connections

Before establishing a data connection to Oracle, ensure that the following condition is met:

You have obtained the IP address, port number, username, password, and service name of Oracle.

Creating an Oracle Data Connection

  1. Log in to the DLV console.
  2. On the Data page, click the workspace drop-down list at the top of the page, select the workspace to be accessed, and click New Data Connection.

    Figure 1 Creating a data connection

  3. In the New Data Connection dialog box, set Data Source Type to Oracle and set the related parameters.

    Figure 2 Creating an Oracle data connection

    Creating Oracle Data Connections describes the Oracle data connection parameters.

    Table 1 Oracle data connection parameters

    Parameter

    Description

    Name

    Name of the data connection. Must contain 1 to 32 characters and contain only letters, digits, hyphens (-), and underscores (_).

    Domain Name

    IP address of the database.

    Port

    Port of the database.

    Username

    Username of the database. The database user must have permission to access data tables and metadata.

    Password

    Password of the database user.

    Service Name

    Service name of the database.

    Agent

    Select an available connection agent, such as VPC connection, CDM proxy, or Internet.

    NOTE:

    Oracle is not a fully managed service and thus cannot be directly connected to fully managed DLV. A CDM cluster serves as an agent that enables communication between them.

  4. Click OK.

Using Oracle Data Sources

You can configure and use Oracle data sources by referring to the instructions in Using DWS Data Sources.