Add an RDS for SQL Server data source in DataV over an internal network and the public network-DataV(DataV)-阿里云帮助中心

Prerequisites

You can now add an RDS for SQL Server data source.

Important

Add the IP addresses of the corresponding region to your data source whitelist to ensure that DataV can access your database. For more information, see Configure a database whitelist.

Limits

This feature is available only in DataV Enterprise Edition and later versions.

Add a data source over an internal network

Access the DataV console.
On the Workbench page, click Data Preparation > Data Source in the navigation pane on the left. On the Data Source page, click New Data Source.
From the Type list, select RDS for SQL Server.
Select Internal Network, and select the region where your RDS instance is located.

Select the network type for the internal database. The options are virtual private cloud (VPC) and classic network.

Virtual private cloud

Turn on the VPC switch to enable VPC mode.

Enter the database information.

Parameter	Description
Name	The display name for the data source. You can enter any name.
VPC ID	The ID of the virtual private cloud (VPC) where your RDS for SQL Server instance is located. To find the ID, go to the RDS console and check the Network Type column in the Instance List.
VPC Instance ID	The ID of the database instance within the VPC. You can find this ID on the basic information page of the instance in the RDS console. Note The VPC instance ID displayed on the database product console may differ from the one required for DataV data source configuration. Obtain the required VPC instance ID by calling the OpenAPI of the database product. The ID is typically the `VpcCloudInstanceId` or `VpcInstanceId` parameter in the instance details. For more information about the API operation to query the VPC instance ID, see Query instance details.
SQL Server Version	Optional. Select this option if you use a version earlier than SQL Server 2012.
Domain Name	The URL to connect to the database. Important This URL is not a website URL or a native IP address. It is the URL that the DataV server uses to access your database over the public network or an Alibaba Cloud internal network in some regions. For example, if you use an Alibaba Cloud RDS for SQL Server instance in an internal network environment, the domain name looks like `rm-bpxxxxxxxxx33150.sqlserver.rds.aliyuncs.com`. You can find it on the basic information page of the instance in the RDS console.
Port	The port configured for the database.
Username	The username to log on to the database.
Password	The password to log on to the database.
Database	The name of the database.
encrypt	Turn on this option to ensure compatibility with Microsoft Azure SQL Server databases.

After you enter the database information, the system automatically tests the connection to verify that the database is accessible.

Classic network

To use the classic network, turn off the VPC switch.

Enter the database information.

Parameter	Description
Name	The display name for the data source. You can enter any name.
SQL Server Version	Optional. Select this option if you use a version earlier than SQL Server 2012.
Domain Name	The URL to connect to the database. Important This URL is not a website URL or a native IP address. It is the URL that the DataV server uses to access your database over the public network or an Alibaba Cloud internal network in some regions. For example, if you use an Alibaba Cloud RDS for SQL Server instance in an internal network environment, the domain name looks like `rm-bpxxxxxxxxx33150.sqlserver.rds.aliyuncs.com`. You can find it on the basic information page of the instance in the RDS console.
Port	The port configured for the database.
Username	The username to log on to the database.
Password	The password to log on to the database.
Database	The name of the database.
encrypt	Turn on this option to ensure compatibility with Microsoft Azure SQL Server databases.

After you enter the database information, the system automatically tests the connection to verify that the database is accessible.

After the connection test succeeds, click OK to add the data source.

The new data source appears in the data source list.

Add a data source over the public network

Access the DataV console.
On the Workbench page, click Data Preparation > Data Source in the navigation pane on the left. On the Data Source page, click New Data Source.
From the Type list, select RDS for SQL Server.
Select Public Network.

For more information about how to set a public endpoint, see Set a connection address.

Enter the database information.

Parameter	Description
Name	The display name for the data source. You can enter any name.
SQL Server Version	Optional. Select this option if you use a version earlier than SQL Server 2012.
Domain Name	The URL to connect to the database. Important This URL is not a website URL or a native IP address. It is the URL that the DataV server uses to access your database over the public network or an Alibaba Cloud internal network in some regions. For example, if you use an Alibaba Cloud RDS for SQL Server instance in a public network environment, the domain name looks like `rm-bpxxxxxxxxxxxxdo.sqlserver.rds.aliyuncs.com`. You can find it on the basic information page of the instance in the RDS console.
Port	The port configured for the database.
Username	The username to log on to the database.
Password	The password to log on to the database.
Database	The name of the database.
encrypt	Turn on this option to ensure compatibility with Microsoft Azure SQL Server databases.

After you enter the database information, the system automatically tests the connection to verify that the database is accessible.

After the connection test passes, click OK to add the data source.

The new data source appears in the data source list.

What to do next

To use the data source in your widgets, see Configure a widget data source.

FAQ

For more information, see FAQ about data source configuration and usage.