Registering Oracle Data Source


To retrieve data from an Oracle data source, you first need to configure the connection information for the Oracle data source.

Prerequisites


Before you begin, ensure the following:

  • Your account has been granted the required asset permissions, operation permissions, and menu group access. If not assigned, contact OU administrator.

  • You have obtained the detailed connection configuration of the data source, including the server IP address, port number, database name, access credentials, password, etc.

Procedure


  1. Log in to the EnOS Application Portal, and select Data > Data Source Registration from the left navigation bar.

  2. Click Add Data Source.

  3. On the Add Data Source page, complete the following configurations:

    Basic Information:

    • Data Source Type (Required): Select ORACLE.

    • Data Source Name (Required): Enter a name for the data source. The maximum length is 50 characters, and the name can consist of:

      • Letters

      • numbers

      • _ (underscore)

      • - (hyphen)

    • Data Source Description: Enter a description for the data source. The maximum length is 100 characters and supports internationalization (default, Chinese, English).


    Configuration Information:

    • Driver Version (Required): Supports ojdbc8 and ojdbc14 versions. Click Query Version to view new features in ojdbc14(19C).

    • Host Name/IP Address （Required）: Enter the hostname or IP address of the database.

    • Service Name (Required): Enter the service name of the Oracle data source.

    • Port：Enter the port number used for the connection. EnOS uses the database address, name, and port to establish a JDBC connection from EnOS to the database. The default ORACLE port is 1521.

    • Username (Required): Enter the username for accessing the Oracle data source. The character rules are the same as for the data source name.

    • Password (Required): Enter the password for the username.

  4. Click Test to verify the connectivity of the data source.

  5. After a successful test, click Confirm.

    • Connectivity is not validated during data source creation. A data source can still be created even if the connectivity test fails.

    • If the connectivity test fails five times consecutively, the account will be locked for 10 minutes.

Outcome


Once the data source is successfully registered, it will appear in the Data Source Registration list. Users can view basic information about all data sources within the OU, but only the creator can modify or delete their registered data sources. For more details, see Managing Data Source.