Quick BI:Alibaba Cloud Data Source SQL Server

Procedure

1. Add the whitelist.

   Before connecting to ApsaraDB RDS for SQL Server, you need to add the IP address of Quick BI to the whitelist of ApsaraDB RDS for SQL Server. For more information on how to add to the whitelist, see Set Whitelist.

2. Log on to the or the international Quick BI console.

3. Follow the instructions in the figure below to add a data source.

   1. Navigate to the data source creation interface via the data source creation entry.

   2. Select the SQL Server data source.

      

   3. Choose Alibaba Cloud as the Data Source.

      

4. In the configuration dialog box, complete the configurations as per your business scenario.

   Name	Description
   Display Name	The display name in the data source configuration list. The name cannot contain special characters or start or end with spaces.
   Database Address	The public address of the SQL Server database deployment (if using a VPC data source, you need to fill in the internal address and internal port of the database deployment). Log on to the RDS Management Console, click to view connection details in the Basic Information area, and obtain the database address. Example: rm-xxxxxxxxxxxxxxxxxx.sqlserver.rds.aliyuncs.com. For more information, see View or Modify Internal and External Network Addresses and Ports.
   Port	Enter the correct port number. The default is 1433.
   Database	The name of the database that you want to access.
   Schema	The schema of the database that you want to access. The default is dbo.
   Username	The corresponding username.
   Password	The corresponding password of the database.
   VPC Data Source	If you use a VPC network to connect to the database, select the VPC Data Source option and enter the relevant parameters. Purchaser Accessid: The AccessKey ID of the purchaser of this instance. For more information, see Obtain AccessKey. Note Ensure that the AccessKey ID has Read permissions on the destination instance. Additionally, if you have Write permissions, the system will automatically add the whitelist. Otherwise, you need to add it manually. For more information, see Create a Custom Policy. Purchaser Accesskey: The AccessKey Secret of the purchaser of this instance. For more information, see Obtain AccessKey. Instance ID: The ID of the purchaser of this instance. Log on to the RDS Management Console and obtain the instance ID in the Basic Information area. Area: The area where this instance is located. Note If you select the VPC data source, you need to fill in the internal address and internal port for the database address and port.
   Enable File Upload Entry	After enabling, file uploads are supported.
   Initialize SQL	After enabling, you can configure the SQL statements that are executed after the data source connection is initialized. Only SET statements are allowed for the SQL statements executed after each data source connection initialization. Separate statements with periods.

5. Click Connection Test to verify the data source connectivity.

   

6. Once the test is successful, click OK to finalize the data source addition.

   If a data source with the same configuration already exists, a message will indicate a configuration conflict. In this case, there is no need to add the data source again.