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.
A CDM cluster is available and used as the network agent to ensure that DLV can communicate with RDS for SQL Server.

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
Click to enlarge

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	NOTE: RDS for SQL Server 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.