Creating Yonghong BI Data Set

Scenario

Create a DLI data set in the Yonghong SaaS production environment.

Procedure

1. On the home page of the Yonghong SaaS production environment, click Create Data Set in the left navigation tree. See Figure 1.
   Figure 1 Creating a data set
   

2. On the displayed page, click SQL Data Set. See Figure 2.
   Figure 2 Creating a SQL data set
   

3. On the displayed page, select the added DLI data source from the Connection drop-down list box. See Figure 3.
   Figure 3 Selecting a data source
   

4. In the Table area on the left pane, right-click and choose Update to update tables. All databases and their tables are listed in the area. Figure 4 shows the page displayed when Table Structure is not configured during connection creation.
   Figure 4 Updating tables
   

5. In the SQL Statement area on the left pane, enter the select * from table_name command to query tables. On the Preview Data page on the right pane, click . Metadata of the table, including fields and field types, is displayed. See Figure 5.
   Figure 5 Querying the table
   

6. Click on the right pane to query data details. See Figure 6.
   Figure 6 Querying data of the table
   

7. On the tool bar of the displayed page, click Save.