Creating RDS for SQL Server Data Connections
Before establishing a data connection to RDS for SQL Server, ensure that the following conditions are met:
- You have obtained the address, port number, username, and password of RDS for SQL Server.
- To enable network communication between DLV and RDS, you can use a VPC connection as a network proxy. Create a VPC connection by referring to instructions in Managing VPC Connections.
Creating an RDS for SQL Server Data Connection
- Log in to the DLV console.
- 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 RDS for SQL Server and set the related parameters.
Figure 2 Creating an RDS for SQL Server data connection
Table 1 describes the RDS for SQL Server data connection parameters.
Table 1 RDS for SQL Server 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 (_).
Instance ID
ID of the database instance.
Domain Name
After an instance ID is selected, an intranet IP address of a database is automatically matched. The domain name cannot be changed.
Port
After an instance ID is selected, a database port is automatically matched. The port cannot be changed.
Username
Username of the database. The database user must have permission to access data tables and metadata.
Password
Password of the database user.
Agent
Select an available connection agent, such as VPC connection, CDM proxy, or Internet. To use the VPC connection, create a VPC connection by referring to instructions in Managing VPC Connections.
Database
You can select a database from the Database drop-down list.
- Click OK.
Using RDS for SQL Server Data Sources
You can configure and use RDS for SQL Server data sources by referring to the instructions in Using DWS Data Sources.
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