edit-icon download-icon

Oracle data source config

Last Updated: Apr 23, 2018

The Oracle relational database data source provides the ability to read data from and write data to Oracle, and supports configuring the synchronization task in both the wizard and script modes.

Procedure

  1. Enter the DataWorks console as a developer, and click Enter Project, as shown in the following figure.

    EnterProject

  2. Click Data Integration from the upper menu and navigate to the Data Sources page.

    DataSources

  3. Click New Source.

  4. In the dialog box, select Oracle as the data source type.

  5. Complete the configuration items of the Oracle data source.

    • Public IP

      16

      • Type: The selected network type.

      • Name: A combination of letters, numbers, and underscores (). It must begin with a letter or an underscore (), and the length must not exceed 60 characters.

      • Description: A brief description of the data source, which must not exceed 80 characters.

      • JDBC URL: The JDBC URL. Format: jdbc:oracle:thin:@serverIP:Port:Database.

      • Username/Password: The username and password of the database.

    • No public IP

      NoPublicIP

      • Type: No public IP.

      • Name: A combination of letters, numbers, and underscores (). It must begin with a letter or an underscore (), and the length must not exceed 60 characters.

      • Description: A brief description of the data source, which must not exceed 80 characters.

      • Select resource group: It can be used to perform synchronization tasks, and in general, multiple machines can be bundled when a resource group is added. For more information, see Add scheduling resources.

      • JDBC URL: An identifier to connect to the specified remote database. The format is jdbc:mysql://ServerIP:Port/Database.

      • Username/Password: The username and password of the database.

  6. Click Test Connectivity.

  7. When the connectivity test is passed, click Complete.

Connectivity test description

  • In a classic network, the connectivity test is provided to verify whether the JDBC URL and Username/Password entered are correct.
  • Currently, test of the connectivity to data sources is unavailable in VPC environments.

What to do next

Now you have learned how to configure the Oracle data source. The article explains how to configure the Oracle Writer plug‑in later. For more information, see Configure Oracle Writer.

Thank you! We've received your feedback.