Add a DMS logical data warehouse as an application data source for Quick BI.
Prerequisites
A logical data warehouse in DMS is created and the One-click JDBC feature is enabled.
Procedure
-
Log on to the Quick BI console.
-
Perform the following steps to add a user-created MongoDB data source.
-
Go to the Create Data Source page.
-
Select the DMS data source.
-
-
In the Configure Connection dialog box, configure the following settings.
Name
Description
Display Name
The display name of the data source, shown in the data source list.
The name cannot contain special characters or start or end with spaces.
Database address and port
The endpoint and port number that correspond to the public endpoint (MySQL) of JDBC in the logical data warehouse of DMS.
Database
The virtual database name of the logical data warehouse to connect to.
Username and Password
The default account and default password that correspond to the JDBC key in the logical data warehouse of DMS.
-
Click Test Connection to verify that the data source can be connected.
-
Click OK.
What to do next
After you add the data source, you can create a dataset and analyze data.
-
Add a data table from the DMS data source or a custom SQL statement to Quick BI. For more information, see Create and manage datasets.
-
Add charts for data analysis. For more information, see Create a dashboard and Chart overview.
-
Drill down data for in-depth analysis. For more information, see the Step 3: Configure and Display Drilling section of the "Drilling" topic.