Registering MySQL or SQL Server Data Source


To retrieve and analyze data from external MySQL or SQL Server databases, you need to configure the data source information and establish a JDBC connection to the target database. This document describes how to configure a connection to a MySQL 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 MySQL or SQL Server.

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

    • 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. Default MySQL port: 3306. Default SQL Server port: 1433.

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