Registering OPENGAUSS Data Source


To retrieve data from an external OPENGAUSS data source, you first need to configure the connection information for the OPENGAUSS 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 OPENGAUSS.

    • 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:

    • Compatibility Mode: Select either B Mode (compatible with MySQL syntax) or PG Mode (compatible with PostgreSQL syntax).

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

    • Database Name （Required）: Enter the name of the database, which serves as its unique identifier. The character rules are the same as for the data source name.

    • 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 OPENGAUSS port is 5432.

    • Query Parameters：Enter database URL query parameters, e.g., useSSL=false&serverTimezone=UTC.

    • Username (Required): Enter the username for accessing the database. 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.