This topic describes how to configure an Oracle connection in DataWorks.

Procedure

  1. Log on to the DataWorks console. In the left-side navigation pane, click Workspaces. On the page that appears, click Data Integration in the Actions column corresponding to the target workspace.
  2. On the Data Integration page that appears, click Connection in the left-side navigation pane. On the page that appears, click Add a Connection.
  3. In the Add Connection dialog box that appears, click Oracle.
  4. In the Add Oracle Connection dialog box that appears, configure the parameters as prompted.
    Parameter Description
    Connection Name The name of the connection. The name can contain letters, digits, and underscores (_). It cannot start with a digit or underscore (_).
    Description The description of the connection. The description can be up to 80 characters in length.
    Environment The environment in which the connection is used. Valid values: Development and Production.
    JDBC URL The Java Database Connectivity (JDBC) URL of the database, which is in the jdbc:oracle:thin:@host:port:SID or jdbc:oracle:thin:@//host:port/service_name format.
    Username and Password The username and password used to connect to the database.
  5. After you configure the preceding parameters, click Complete.

    Description of connectivity test

    • If the user-created data source is hosted on an ECS instance in the classic network, network connectivity is not guaranteed when nodes are deployed in the default resource group. We recommend that you use custom resource groups.
    • Connectivity testing is not supported for data sources in VPCs. You can click Complete without testing the connectivity.