:Connect a VPC data source to an exclusive Data Integration resource group

Procedure

1. Obtain the ApsaraDB RDS instance information.

   When creating the MySQL data source, you need the instance ID, database name, username, and password of the ApsaraDB RDS instance:

   1. Log on to the ApsaraDB RDS console.

   2. In the left-side navigation pane, click Instances.

   3. On the Instances page, find the target instance and note its instance ID.

   4. Click Manage in the Actions column of the target instance.

   5. In the left-side navigation pane, click Databases. Find the database you want to connect to and note its database name.

   6. In the left-side navigation pane, click Accounts. Note the account associated with the database. This is the username that is required when you create the data source.

2. Create an exclusive resource group for Data Integration.

   1. Log on to the DataWorks console.

   2. Select a region. In the left-side navigation pane, click Resource Group.

   3. On the Exclusive Resource Groups tab, click Create Scheduling Resource Group or Create Resource Group for Data Integration of Old Version.

   4. On the purchase page, configure the Region, Type, Exclusive Resources for Data Integration, Units, and Duration parameters, and then click Buy Now.

      For this example, select China (Shanghai) for the Region parameter. Select a specification for Exclusive Resources for Data Integration that meets your needs. For more information, see Subscription billing for exclusive resource groups for Data Integration.

   5. Confirm the order details, select DataWorks Exclusive Resources Agreement of Service, and then click Pay.

   6. Return to the Create a dedicated resource group panel and configure the parameters.

      Parameter	Description
      Resource Group Type	The type of the resource group. Select Exclusive Resources for Data Integration.
      Resource Group Name	The name of the resource group. The name must be unique within your Alibaba Cloud account. Note An Alibaba Cloud account can have multiple Resource Access Management (RAM) users.
      Resource Group Description	A brief description of the resource group.
      Order Number	Select the order for the exclusive resources you purchased.

   7. Click OK.

3. Bind the exclusive resource group for Data Integration to a VPC.

   1. On the Resource Groups > Exclusive Resource Groups tab, find the exclusive resource group for Data Integration and click Network Settings in the Actions column.

      Important

      Before you bind the resource group to a VPC, ensure your RAM user has the required permissions to access the ApsaraDB RDS instance.

   2. On the VPC Binding tab, click Add VPC Binding. In the Add VPC Association panel, configure the parameters.

      

      Parameter	Description
      Resource Group Name	From the Resource Group Name drop-down list, select the resource group you want to associate.
      VPC	From the VPC drop-down list, select the VPC where the data source is located.
      Availability Zone	From the drop-down list, select the desired Availability Zone.
      vSwitch	From the vSwitch drop-down list, select the vSwitch where the data source is located.
      Security Groups	From the Security Groups drop-down list, select the appropriate Security Group.

   3. Click OK.

4. Optional: Add a custom route in the VPC.

   If the exclusive resource group and the data source are in different Availability Zones, you must add a custom route. Otherwise, skip this step.

   1. On the Exclusive Resource Groups tab, find the exclusive resource group and click Network Settings.

   2. Find the associated VPC and click Custom Route.

   3. In the Custom Route panel, click Add Route.

   4. In the Add Route dialog box, configure the parameters.

      

      Parameter	Description
      Destination Type	Because the data source is in a VPC, select VPC.
      Destination VPC	The region and name of the VPC where the data source is located. Note This parameter is displayed only when Destination Type is set to VPC.
      Connection Method	Options include Switch, Fixed IP Address, and CIDR Block. For this example, select Switch.
      Destination VSwitch	Select a vSwitch in the destination VPC as the route target.
      Routing	This parameter cannot be modified.

   5. Click Generate Route.

5. Add the Elastic IP Address (EIP) and Elastic Network Interface (ENI) IP address of the resource group to the ApsaraDB RDS whitelist.

   1. On the Exclusive Resource Groups tab, find the resource group and click Details in the Actions column.

   2. In the Exclusive Resource Groups dialog box, view and copy the Elastic IP Address (EIP).

      

   3. On the Resource Groups > Exclusive Resource Groups tab, find the resource group and click Network Settings.

   4. On the details page of the resource group, view and copy the Elastic Network Interface (ENI) IP address.

   5. Log on to the ApsaraDB RDS console.

   6. In the upper-left corner of the Instances page, ensure the correct region is selected. Then, find the target instance and click Manage.

   7. In the left-side navigation pane, click Whitelist and SecGroup.

   8. On the Whitelist Settings tab, click Create Whitelist.

   9. In the Create Whitelist dialog box, configure the parameters and click OK.

      

      Parameter	Description
      Whitelist Name	The name of the whitelist must meet the following requirements: It can contain only lowercase letters, digits, and underscores (_). It must start with a lowercase letter and end with a letter or a digit. It must be 2 to 32 characters in length.
      IP Addresses	Enter the copied Elastic IP Address (EIP) and Elastic Network Interface (ENI) IP address.

6. Create a MySQL data source and test its connectivity.

   1. Go to the Data Sources page.

      1. Log on to the DataWorks console. In the top navigation bar, select the desired region. In the left-side navigation pane, choose More > Management Center. On the page that appears, select the desired workspace from the drop-down list and click Go to Management Center.

      2. In the left-side navigation pane of the SettingCenter page, click Data Sources.

   2. On the Data Sources page, click Add Data Source in the upper-right corner.

   3. In the Add Data Source dialog box, select MySQL.

   4. In the Add MySQL Data Source dialog box, configure the parameters.

      MySQL data sources support two connection methods: Alibaba Cloud instance mode and connection string mode. This topic uses Alibaba Cloud instance mode as an example.

      Parameter	Description
      Data source type	The connection method for the data source. This example uses Alibaba Cloud instance mode.
      Data Source Name	The name can contain letters, digits, and underscores (_). It cannot start with a digit or an underscore (_).
      Data Source Description	A brief description of the data source. The description cannot exceed 80 characters.
      Environment	Select Development or Production. Note This parameter is available only for workspaces in standard mode.
      Region	Select the region where the ApsaraDB RDS instance is located.
      Alibaba Cloud Account	Select the type of account to use.
      Instance	Enter the ApsaraDB RDS instance ID.
      Database Name	Enter the name of the database.
      Username	Enter the database username.
      Password	Enter the account password.
      Authentication Method	Select whether to use SSL authentication.

   5. Under the Data Integration tab, click Test Connectivity in the Actions column of the target resource group.

   6. After the connectivity test is successful, click Complete Creation.