Help Center/ Data Lake Insight/ Best Practices/ Connecting BI Tools to DLI for Data Analysis/ Configuring FineBI to Connect to DLI for Data Query and Analysis
Updated on 2025-09-30 GMT+08:00

Configuring FineBI to Connect to DLI for Data Query and Analysis

FineBI is an intelligent, visual tool that focuses on data analysis and visualization. It can connect to various data sources and transform intricate data into intuitive charts and dashboards to swiftly gain data insights.

This section describes how to configure FineBI to connect to DLI to access and analyze data in DLI.

Preparations

  • Environment requirements:

    Make sure that your system environment meets the following requirements:

    • Operating system: Only Windows 10 and Windows 11 (64-bit) are supported.
  • Toolkits:
  • Preparing connection information
    Table 1 Connection information

    Item

    Description

    How to Obtain

    DLI AKSK

    AK/SK-based authentication refers to the use of an AK/SK pair to sign requests for identity authentication.

    Obtaining an AK/SK

    DLI's endpoint address

    Endpoint of a cloud service in a region.

    Obtaining an Endpoint

    DLI's project ID

    Project ID, which is used for resource isolation.

    Obtaining a Project ID

    DLI's region information

    DLI's region information

    Regions and Endpoints

Step 1: Install FineBI and Configure Data Connections

  1. Download and install FineBI.

    1. Download the FineBI installation package.
    2. Find the downloaded FineBI installation program file.
    3. Double-click the installation program.
    4. Follow the installation wizard to perform installation operations, including accepting the license agreement, selecting the installation type (typical or custom), and setting the installation directory.

  2. Configure FineBI to support custom drivers.

    1. Open the script for editing custom drivers.

      Locate the edit script /webapps/webroot/WEB-INF/embed/finedb/db.script in the root directory of FineBI installation.

    2. Add the following content to the script:
      INSERT INTO FINE_CONF_ENTITY VALUES
    3. Change the value of the following configuration item to true:
      'SystemConfig.driverUpload','true'
    4. Restart FineBI for the modifications to take effect.

  3. Integrate the JDBC driver with FineBI.

    1. Download the data driver.

      Click dli-jdbc-x.x.x.jar to obtain the JDBC driver, named huaweicloud-dli-jdbc-xxx-dependencies.jar.

    2. Obtain Log4j-related JAR files.

      Download the following log4j dependency packages from the official Maven repository:

      • log4j-api-2.xx.jar,
      • log4j-core-2.xx.jar,
      • log4j-slf4j-impl-2.xx.jar
    3. Integrate the DLI driver into FineBI.
      1. Open FineBI.
      2. Choose Data Connection > Data Connection Management.
      3. Click New Driver. On the displayed page, select the DLI JDBC driver from the Driver list box, and click Upload File to upload the Log4j JAR files.
        Figure 1 Installing a data connection driver for FineBI

  4. Configure database connection.

    1. Choose Data Connection > Data Connection Management.
    2. Click New Driver and click Other JDBC.
      Figure 2 Clicking Other JDBC
    3. Set connection parameters.
      Figure 3 Setting connection parameters
      Table 2 Parameters for connecting FineBI to a database

      Parameter

      Description

      Example Value

      Data Connection URL

      JDBC connection string

      Format: jdbc:dli://<dliEndPoint>/projectId?<key1>=<val1>;<key2>=<val2>. For details about the parameters, see Table 3.

      jdbc:dli://dli.xxx.myhuaweicloud.com/0b33ea2a7e0010802fe4c009bb05076d?databasename=tpch;queuename=auto;regionname=xxx;obs.endpoint=obs.xxx.myhuaweicloud.com

      Encoding

      Mode in which FineBI interacts with the target database.

      Set this parameter to URF-8 in this example.

      _

      Username

      Username used to log in to the server. Enter an AK in this example.

      _

      Password

      Password used to log in to the server. Enter an SK in this example.

      _

      Table 3 URL parameters

      Parameter

      Mandatory

      Description

      Example Value

      databasename

      Yes

      Database name

      _

      queuename

      Yes

      Queue name of DLI

      _

      regionname

      Yes

      Region name of DLI

      _

      obs_endpoint

      Yes

      OBS endpoint

      _

      enginetype

      No

      DLI queue type. The options are:

      The default value is spark.

      spark: Spark queue

      hetuEngine: HetuEngine queue

      spark

      catalog

      No

      Metadata catalog name

      Spark metadata is used by default.

      · It is mandatory when a LakeFormation catalog is used. In this case, it indicates the name of the LakeFormation catalog used.

      When querying the LakeFormation catalog, there must be a default database under the catalog.

      · If left unset, a DLI catalog is used by default. You do not need to set this parameter when using the DLI catalog.

      For example, if you use a LakeFormation catalog named lfcatalog, the configuration is as follows: catalog=lfcatalog.

Step 2: Create a Custom SQL Query

  1. Choose Public Data. Click Add Dataset and select SQL Dataset.
    Figure 4 Opening a data connection
  2. Select Data from Data Connection.
  3. Enter a custom SQL query statement to start data analysis.
    Figure 5 Custom SQL query statement