Configuring FineBI to Connect to DLI for Data Query and Analysis

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:
  • DLI JDBC driver: dli-jdbc-x.x.x.jar
  • FineBI installation package: FineBI installation package

• 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