The Oracle data source allows you to read data from and write data to Oracle, and supports configuring synchronization tasks in wizard mode and script mode.

Procedure

  1. Log on to the DataWorks console as an administrator and click Enter Workspace in the actions column of the relevant project in the Project List.
  2. Click Data Integration in the top navigation bar to go to the Data Source page.
  3. Click New source to pop up the supported data source.

  4. In the new data source pop-up box, select the data source type as Oracle.
  5. Configure each item of information for the Oracle data source.

    Oracle Data source types are divided into public network IP and non-public network IP, and you can choose according to your own situation.

    Consider a data source that adds a new Oracle > network IP type.

    Configurations:
    • Type: With a public IP address.
    • Name: It is a combination of letters, numbers, and underlines It must begin with a letter or underline and cannot exceed 60 characters.
    • Description: It is a brief description of the data source with no more than 80 characters.
    • JDBC URL: Format: jdbc:oracle:thin:@serverIP:Port:Database.
    • Username/Password: The user name and password used to connect to the database.
    Consider a data source that adds a new Oracle > network IP type.

    Configurations:
    • Data Source Type: No public network IP, this type of data source requires custom scheduling resources for synchronization, you can click the help manual to view it.
    • Data source name: It is a combination of letters, numbers, and underlines It must begin with a letter or underline and cannot exceed 60 characters.
    • Data source description: It is a brief description of the data source with no more than 80 characters.
    • JDBC URL: Format: jdbc:oracle:thin:@serverIP:Port:Database.
    • Username/Password: The user name and password used to connect to the database.
  6. Click Test Connectivity
  7. When the connectivity test is passed, click Complete.

Connectivity test description

  • The connectivity test is available in the classic network arrangement, to identify whether the input JDBC URL, user name, and password are correct.
  • Private Network and no public network IP, data source connectivity test is currently not supported, click confirm.

Next step

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