This topic describes how to add a RDS for SQLServer data source in DataV over an internal network and over the Internet.

Prerequisites

The RDS for SQLServer data source is ready to be added.

Procedure for adding a data source over an internal network

  1. Log on to the DataV console.
  2. On the My Data tab, click Data Sources and click Add Data.
  3. Select RDS for SQLServer from the Type drop-down list.
  4. Select Intranet from the network type drop-down list, and select the region where the target ApsaraDB RDS for PostgreSQL instance resides from the region drop-down list.
  5. Specify a network type for the internal network of the database, such as VPC or classic network.
    • VPC
      1. Turn on VPC to enter the VPC mode.
      2. Enter database information. Add an ApsaraDB RDS for SQL Server data source over a VPC (internal network)
        ParameterDescription
        NameThe name of the data source. Enter a custom name.
        VPC IDThe ID of the VPC where your RDS for SQLServer instance resides. You can log on to the ApsaraDB for RDS console and navigate to Instances > Basic Information to view the VPC ID of the target ApsaraDB RDS for PostgreSQL instance in the Network Type column. Obtain VPC ID
        Instance IDThe ID of the database instance in the VPC. You can log on to the ApsaraDB for RDS console and view the ID of the target database instance on the Instances page.
        Note Generally, you can view the VPC ID of a database instance in the console of a database product. However, due to the VPC network implementation mechanism, sometimes the instance ID displayed in the console is not the instance ID required to configure the VPC network for the DataV data source. Therefore, you must call the OPEN API operation of a database product to obtain the ID of the VPC that DataV needs. In most cases, the ID is VpcCloudInstanceId or VpcInstanceId in the details of a database instance. For more information about the API operation that is used to obtain the ID of a VPC, see DescribeDBInstanceAttribute.
        SQL Server VersionOptional. If you use a SQL Server version that is earlier than SQL Server 2012, select this option.
        DomainThe URL that is used to connect to the database.
        Important The URL here is not the URL of the official website page or the IP address of the local machine. It is the URL that the DataV server can use to access your database over the Internet or the internal network of some Alibaba Cloud regions.

        For example, if you use a ApsaraDB for RDS for SQLServer instance over an internal network, the domain name is rm-bpxxxxxxxxx33150.sqlserver.rds.aliyuncs.com. You can obtain the domain name on the Basic Information page of the instance in the ApsaraDB RDS console.

        Port NumberThe port that is used to connect to the database.
        User NameThe username that is used to connect to the database.
        PasswordThe password that is used to connect to the database.
        DatabaseThe name of the database. Select the desired database.
        encryptIf you enable this feature, you can use a Microsoft Azure SQL Server database as the data source.
      3. After you enter the database information, DataV automatically tests whether the database can be connected.
    • Classic Network
      1. Turn off VPC to enter the classic network mode.
      2. Enter database information. Add an ApsaraDB RDS for SQL Server data source over a classic network (internal network)
        ParameterDescription
        NameThe name of the data source. Enter a custom name.
        SQL Server VersionOptional. If you use a SQL Server version that is earlier than SQL Server 2012, select this option.
        DomainThe URL that is used to connect to the database.
        Important The URL here is not the URL of the official website page or the IP address of the local machine. It is the URL that the DataV server can use to access your database over the Internet or the internal network of some Alibaba Cloud regions.

        For example, if you use a ApsaraDB for RDS for SQLServer instance over an internal network, the domain name is rm-bpxxxxxxxxx33150.sqlserver.rds.aliyuncs.com. You can obtain the domain name on the Basic Information page of the instance in the ApsaraDB RDS console.

        Port NumberThe port that is used to connect to the database.
        User NameThe username that is used to connect to the database.
        PasswordThe password that is used to connect to the database.
        DatabaseThe name of the database. Select the desired database.
        encryptIf you enable this feature, you can use a Microsoft Azure SQL Server database as the data source.
      3. After you enter the database information, DataV automatically tests whether the database can be connected.
  6. After the connectivity test is complete, click OK.

    The added data source is displayed in the data source list.

Procedure for adding a data source over the Internet

  1. Log on to the DataV console.
  2. On the My Data tab, click Data Sources and click Add Data.
  3. Select RDS for SQLServer from the Type drop-down list.
  4. Select Internet from the network type drop-down list.
  5. Enter database information.
    Add an ApsaraDB RDS for SQL Server data source (Internet)
    ParameterDescription
    NameThe name of the data source. Enter a custom name.
    SQL Server VersionOptional. If you use a SQL Server version that is earlier than SQL Server 2012, select this option.
    DomainThe URL that is used to connect to the database.
    Important The URL here is not the URL of the official website page or the IP address of the local machine. It is the URL that the DataV server can use to access your database over the Internet or the internal network of some Alibaba Cloud regions.

    For example, if you use the ApsaraDB for RDS for SQLServer in an external environment, the domain name is rm-bpxxxxxxxxxxxxdo.sqlserver.rds.aliyuncs.com, which can be obtained on the Basic Information page of the RDS console.

    Port NumberThe port that is used to connect to the database.
    User NameThe username that is used to connect to the database.
    PasswordThe password that is used to connect to the database.
    DatabaseThe name of the database. Select the desired database.
    encryptIf you enable this feature, you can use a Microsoft Azure SQL Server database as the data source.

    After you enter the database information, DataV automatically tests whether the database can be connected.

  6. After the database passes the connectivity test, click OK.

    The added data source is displayed in the data source list.