This topic describes how to add RDS for SQLServer data sources over the internal and public networks in DataV.

Prerequisites

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

Add an ApsaraDB RDS for SQL Server data source over an internal network

  1. Log on to the DataV console.
  2. On the My Data tab, select Data Source and click Add Source.
  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)
        Parameter Description
        Name The name of the data source. Enter a custom name.
        VPC ID The ID of the VPC instance. This VPC is 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 ID The 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 instance ID of the DB instance directly in the console of the 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 need to use the OPEN API of the database product to obtain the VPC instance ID required by DataV, which is usually the VpcCloudInstanceId or VpcInstanceId in the database instance details. For more information about how to obtain the VPC instance ID of a specific database product, see Query instance details.
        SQL Server Version Optional. If you use a SQL Server version that is earlier than SQL Server 2012, select this option.
        domain name The URL that is used to connect to the database.
        Notice The URL address here is not the URL of the official website page or the local IP address. It is the URL that the DataV server can access your database through the public network or the internal network of some regions of Alibaba Cloud.

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

        Port Number The port that is used to connect to the database.
        Username The username that is used to log on to the ApsaraDB RDS for MySQL database.
        Password The password that is used to log on to the ApsaraDB RDS for MySQL database.
        Database The name of the database.
        encrypt If 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)
        Parameter Description
        Name The name of the data source. Enter a custom name.
        SQL Server Version Optional. If you use a SQL Server version that is earlier than SQL Server 2012, select this option.
        domain name The URL that is used to connect to the database.
        Notice The URL address here is not the URL of the official website page or the local IP address. It is the URL that the DataV server can access your database through the public network or the internal network of some regions of Alibaba Cloud.

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

        Port Number The port that is used to connect to the database.
        Username The username that is used to log on to the ApsaraDB RDS for MySQL database.
        Password The password that is used to log on to the ApsaraDB RDS for MySQL database.
        Database The name of the database.
        encrypt If 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.

Add an ApsaraDB RDS for SQL Server data source over the Internet

  1. Log on to the DataV console.
  2. On the My Data tab, select Data Source and click Add Source.
  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)
    Parameter Description
    Name The name of the data source. Enter a custom name.
    SQL Server Version Optional. If you use a SQL Server version that is earlier than SQL Server 2012, select this option.
    domain name The URL that is used to connect to the database.
    Notice The URL address here is not the URL of the official website page or the local IP address. It is the URL that the DataV server can access your database through the public network or the internal network of some regions of Alibaba Cloud.

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

    Port Number The port that is used to connect to the database.
    Username The username that is used to log on to the ApsaraDB RDS for MySQL database.
    Password The password that is used to log on to the ApsaraDB RDS for MySQL database.
    Database The name of the database.
    encrypt If 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.