This topic describes how to add an ApsaraDB RDS for SQL Server data source in DataV.

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

  1. Log on to the DataV console.
  2. Click the Data Sources tab and then 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 SQL Server 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.Add an ApsaraDB RDS for SQL Server data source over a VPC (internal network)
      2. Enter database information.
        Parameter Description
        Name The name that you want to display for the data source.
        Domain Name The URL that is used to connect to the database.
        Notice The DataV server can use the URL to access the database over the Internet or an internal network in some regions of Alibaba Cloud.

        If you need to access an ApsaraDB RDS for SQL Server database over an internal network, an example of the domain name is rm-bpxxxxxxxxx33150.sqlserver.rds.aliyuncs.com. You can log on to the ApsaraDB for RDS console and view the required information on the Instances page.

        VPC ID The ID of the VPC to which your ApsaraDB RDS for SQL Server instance belongs. 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 SQL Server 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.
        Username The username that is used to connect to the database.
        Password The password that is used to connect to the database.
        Port The port that is used to connect to the database.
        SQL Server Version Optional. If you use a SQL Server version that is earlier than SQL Server 2012, select this option.
        Database The database that you want to use as the data source.
        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 that you want to display for the data source.
        Domain Name The URL that is used to connect to the database.
        Notice The DataV server can use the URL to access your database over the Internet or an internal network in some regions of Alibaba Cloud.

        If you need to access an ApsaraDB RDS for SQL Server database over an internal network, an example of the domain name is rm-bpxxxxxxxxx33150.sqlserver.rds.aliyuncs.com. You can log on to the ApsaraDB for RDS console and view the required information on the Instances page.

        Username The username that is used to connect to the database.
        Password The password that is used to connect to the database.
        Port The port that is used to connect to the database.
        SQL Server Version Optional. If you use a SQL Server version that is earlier than SQL Server 2012, select this option.
        Database The database that you want to use as the data source.
        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. Click the Data Sources tab and then 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 that you want to display for the data source.
    Domain Name The URL that is used to connect to the database.
    Notice The DataV server can use the URL to access your database over the Internet or an internal network in some regions of Alibaba Cloud.
    Username The username that is used to connect to the database.
    Password The password that is used to connect to the database.
    Port The port that is used to connect to the database.
    SQL Server Version Optional. If you use a SQL Server version that is earlier than SQL Server 2012, select this option.
    Database The database that you want to use as the data source.
    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.