- Service Overview
-
User Guide
- Preparatory Work
- Introducing the DLV Console
- How-Tos
- Managing Workspaces
- Creating Data Connections
- Creating Screens
- Developing Screens
- Managing Screens
- Managing Layers
-
Data Connection Management
-
Creating Data Connections
- Data Connection Overview
- Using Static Data Sources
- Creating API Data Connections
- Creating CSV File Data Connections
- Creating Object Storage Service Data Connections
- Creating Data Warehouse Service Data Connections
- Creating Data Lake Insight Data Connections
- Creating MRS Hive Data Connections
- Creating MRS SparkSQL Data Connections
- Creating ClickHouse Data Connections
- Creating RDS for MySQL Data Connections
- Creating RDS for PostgreSQL Data Connections
- Creating RDS for SQL Server Data Connections
- Creating RDS for GaussDB Data Connections
- Creating GeminiDB Influx API Data Connections
- Creating Cloud Search Service Data Connections
- Creating DDM Data Connections
- Creating Oracle Data Connections
- Creating MySQL Data Connections
- Creating PostgreSQL Data Connections
- Creating SQL Server Data Connections
- Creating Elasticsearch Data Connections
- Editing Data Connections
- Searching for Data Connections
- Deleting Data Connections
-
Creating Data Connections
- Managing Components
- Component Guide
- Screen Combination
- Integrating DLV into Third-Party Systems
- Change History
- Developer Guide
- API Reference
-
FAQs
- What Is DLV Used For?
- Regions and AZs
- Can I Quickly Create a DLV Screen Using a Template?
- Can DLV Connect to Data Sources Through APIs?
- What Types of Data Connections Are Supported in DLV?
- How Do I Configure a CSV Data Source?
- How Do I Use the Interaction Function?
- What Can I Do If a Component Cannot Be Completely or Normally Displayed?
- How Do I Query Data Formats Supported by Different Components?
- What Can I Do When the WebGL Component Breaks Down?
-
More Documents
-
User Guide (ME-Abu Dhabi Region)
- Service Overview
- Preparatory Work
- Introducing the DLV Console
- How-Tos
- Managing Workspaces
- Creating Data Connections
- Creating Screens
- Developing Screens
- Managing Screens
- Managing Layers
-
Data Connection Management
-
Creating Data Connections
- Data Connection Overview
- Using Static Data Sources
- Creating API Data Connections
- Creating API Gateway Data Connections
- Creating CSV File Data Connections
- Creating Object Storage Service Data Connections
- Creating Data Warehouse Service Data Connections
- Creating Data Lake Insight Data Connections
- Creating MRS Hive Data Connections
- Creating MRS SparkSQL Data Connections
- Creating ClickHouse Data Connections
- Creating RDS for MySQL Data Connections
- Creating RDS for PostgreSQL Data Connections
- Creating RDS for SQL Server Data Connections
- Creating RDS for GaussDB Data Connections
- Creating GeminiDB Influx API Data Connections
- Creating Cloud Search Service Data Connections
- Creating a DAYU Data Connection
- Creating DDM Data Connections
- Creating Oracle Data Connections
- Creating MySQL Data Connections
- Creating PostgreSQL Data Connections
- Creating SQL Server Data Connections
- Creating Elasticsearch Data Connections
- Editing Data Connections
- Searching for Data Connections
- Deleting Data Connections
- Managing VPC Connections
-
Creating Data Connections
- Managing Components
- Component Guide
- Screen Combination
- Integrating DLV into Third-Party Systems
-
FAQs
- What Is DLV?
- What Is DLV Used For?
- Regions and AZs
- How Many Screens Can I Create in DLV?
- Can I Quickly Create a DLV Screen Using a Template?
- Can DLV Connect to Data Sources Through APIs?
- What Types of Data Connections Are Supported in DLV?
- How Do I Configure a CSV Data Source?
- How Do I Use the Interaction Function?
- What Can I Do If a Component Cannot Be Completely or Normally Displayed?
- How Do I Query Data Formats Supported by Different Components?
- What Can I Do When the WebGL Component Breaks Down?
- API Reference (ME-Abu Dhabi Region)
- Developer Guide (ME-Abu Dhabi Region)
-
User Guide (ME-Abu Dhabi Region)
- General Reference
Copied.
Creating Data Warehouse Service Data Connections
Before establishing a data connection to Data Warehouse Service (DWS), ensure that the following conditions are met:
- You have obtained the IP address, port number, username, and password of DWS.
- A Cloud Data Migration (CDM) cluster is used as the network agent to ensure that DLV can communicate with DWS. Ensure that an available CDM cluster exists and is in the same region, AZ, and VPC as the DWS data source. In addition, the CDM cluster and DWS data source must be in the same security group or the security group rule allows them to communicate with each other.
In CDM, you only need to do nothing but create a CDM cluster.
Creating a DWS Data Connection
- Log in to the DLV console.
- In the navigation pane on the left, click Data.
- On the Data page, click the workspace drop-down list at the top of the page, select the workspace to be accessed, and click New Data Connection.
Figure 1 Creating a data connection
- In the New Data Connection dialog box, set Data Source Type to DWS and set the related parameters.
Figure 2 Creating a DWS data connection
Table 1 DWS data connection parameters Parameter
Description
Name
Name of the data connection. Must contain 1 to 32 characters and contain only letters, digits, hyphens (-), and underscores (_).
Cluster Name
Name of the DWS cluster. To create a DWS cluster, click Create Cluster next to the drop-down list.
Domain Name
After a DWS cluster is selected, an intranet domain name of a database will be automatically matched. The domain name is alterable.
Port
After a DWS cluster is selected, a database port will be automatically matched. The port is alterable.
Username
Username of the database. The database user must have permission to access data tables and metadata.
Password
Password of the database user.
Agent
Name of the CDM cluster. To view all available CDM clusters, click View Agent next to the drop-down list.
NOTE:
DWS is not a fully managed service and thus cannot be directly connected to fully managed DLV. A CDM cluster serves as an agent that enables communication between them.
Database
You can select a database from the Database drop-down list.
NOTE:
If there is no database displayed, check whether the database username and password are correct. Then, ensure that security group rules have been configured to allow database connections. Ensure that the CDM proxy and the DB instance are in the same VPC. If the fault persists, contact technical support.
Currently, DLV cannot use CDM 2.9 or later as a proxy.
- Click OK.
Using DWS Data Sources
The following example compares visits of a service in different channels through a pie chart.
- Log in to the DLV console and click the Screens tab.
- On the Screens page, locate the screen to be edited and click
on the screen. The screen development page is displayed.
Figure 3 Editing a screen - Select a pie chart component from the component list on the left, click the Data tab, and set Data Source Type to Database.
- In the Data Connection drop-down list, select a created DWS data connection.
Figure 4 Selecting a DWS data connection
- Enter the SQL statement in the SQL editing box.
Figure 5 Executing the SQL statement
- Click View Response Result to view the data response result.
Figure 6 Viewing the response result
- Configure field mapping based on the response data.
Set y to volume and s to way and then set the legend color.Figure 7 Screen effect
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot