All Products
Search
Document Center

ApsaraDB RDS:Connect Kingdee K/3 WISE to an ApsaraDB RDS for SQL Server instance

Last Updated:Jan 24, 2024

This topic describes how to connect Kingdee K/3 WISE 15.0 or 15.1 that is deployed on an Elastic Cloud Service (ECS) instance to an ApsaraDB RDS for SQL Server instance. After the connection is established, you can configure a distributed transaction whitelist for the RDS instance and the ECS instance to implement transaction consistency and isolation.

Process

  1. Upload a full backup file of the specified Kingdee K/3 WISE set of books to an Object Storage Service (OSS) bucket. Then, restore the data from the full backup file to the RDS instance. For more information, see Restore data to the RDS instance.

  2. Modify the access settings of the RDS instance, ECS instance, and Windows operating system to open required ports. This allows you to smoothly run distributed transactions between the RDS instance and the ECS instance. For more information, see Enable distributed transactions.

  3. Replace the original accounting data management tool of Kingdee K/3 WISE with a new one that is compatible with ApsaraDB RDS for SQL Server. For more information, see Initialize the new accounting data management tool.

Preparations

  1. Install Kingdee K/3 WISE on an ECS instance that runs Windows Server 2016.

  2. Create an RDS instance that resides in the same region and virtual private cloud (VPC) as the ECS instance on which Kingdee K/3 WISE is installed. For more information, see Overview of VPCs and vSwitches and Create an ApsaraDB RDS for SQL Server instance.

    Note
  3. Create a full backup file for the specified Kingdee K/3 WISE set of books.

Restore data to the RDS instance

Upload a full backup file of the set of books to an OSS bucket

  1. Log on to the OSS console.

  2. In the left-side navigation pane, click Buckets. On the Buckets page, click Create Bucket.

  3. Configure the following parameters and retain the default values for other parameters. Then, click OK.

    Parameter

    Description

    Bucket Name

    Enter a name for the bucket.

    Region

    Select the region in which you want to create the bucket.

    Important

    Make sure that the bucket resides in the same region as the ECS instance and RDS instance.

    Storage Class

    Select IA.

    Redundancy Type

    Select LRS.

    ACL

    Select Private.

    Versioning

    Select Not Activated.

    Encryption Method

    Select None.

    Real-time Log Query

    Select Not Activated.

    Note

    For more information, see Create buckets.

  4. In the left-side navigation pane, click Buckets. On the page that appears, click the bucket that you created.

  5. In the left-side navigation pane of the page that appears, choose Object Management > Objects. On the page that appears, click Upload Object.

  6. Drag the full backup file that you want to upload to the Files to Upload field. Alternatively, click Select Files and select the full backup file.

    Note

    For more information, see Upload objects.

    上传文件

Create a privileged account for the RDS instance

  1. Go to the Instances page. In the top navigation bar, select the region in which the RDS instance resides. Then, find the RDS instance and click the ID of the instance.
  2. In the left-side navigation pane, click Accounts.

  3. Click Create Account.

  4. Configure the following parameters and click OK.

    Parameter

    Description

    Database Account

    Enter a username for the account. The name can be up to 50 characters in length and can contain lowercase letters, digits, and underscores (_). It must start with a lowercase letter and end with a lowercase letter or a digit.

    Account Type

    Specify the type of the account. Select Privileged Account. For more information, see Account permissions in an ApsaraDB RDS for SQL Server instance.

    New Password

    Enter a password for the account. The password must meet the following requirements:

    • It is 8 to 32 characters in length.

    • It must contain at least three types of the following characters: uppercase letters, lowercase letters, digits, and special characters.

    • It can contain the following special characters: ! @ # $ % ^ & * ( ) _ + - =

    Confirm Password

    Enter the password for the account again.

    Description

    Enter a description that helps identify the account.

Restore the full backup file from the OSS bucket to the RDS instance

Note

The AliyunServiceRoleForDBS service-linked role is created by using your Alibaba Cloud account when you use the backup feature of ApsaraDB RDS for the first time. For more information, see How do I create a service-linked role for DBS?

  1. Go to the Instances page. In the top navigation bar, select the region in which the RDS instance resides. Then, find the RDS instance and click the ID of the instance.
  2. In the left-side navigation pane of the page that appears, click Backup and Restoration. On the page that appears, click Migrate OSS Backup Data to RDS.

    Note

    If you cannot find the button, check whether the SQL Server version and edition of the RDS instance meet requirements. For more information, see Preparations.

  3. Click Next twice to go to the Import Data step.

  4. Configure the following parameters.

    Parameter

    Description

    Database Name

    Enter the name of the destination database on the RDS instance.

    OSS Bucket

    Select the OSS bucket in which the full backup file is stored.

    OSS File

    Specify the full backup file that you want to import. You can enter a prefix in the search box and click the search icon to search for the full backup file in fuzzy match mode. The system displays the name, size, and update time of each full backup file that is returned. Select the backup file that you want to migrate to the RDS instance.

    Cloud Migration Method

    Select Immediate Access (Full Backup).

    Consistency Check Mode

    Select Synchronous DBCC.

    Note

    If you migrate backup data from OSS to ApsaraDB RDS for the first time, the system prompts you to authorize ApsaraDB RDS to access your resources in OSS. In this case, click Authorize and then Confirm Authorization Policy.

    image.png

  5. Click OK.

    Note

    Wait until the full backup file is imported into the destination database on the RDS instance. You can click Databases in the left-side navigation pane to view the status of the destination database.

Enable distributed transactions

Configure the RDS instance

  1. Go to the Instances page. In the top navigation bar, select the region in which the RDS instance resides. Then, find the RDS instance and click the ID of the instance.
  2. In the left-side navigation pane of the page that appears, click Whitelist and SecGroup. On the Whitelist Settings tab of the page that appears, click Modify to the right of the IP address whitelist that is labeled default and add the IP address of the ECS instance to the whitelist.

    Note
    • If the ECS instance and RDS instance reside in the same VPC, enter the private IP address of the ECS instance. You can view the private IP address on the Instance Details page for the ECS instance in the ECS console.

    • If the ECS instance and RDS instance reside in different VPCs, you must enter the public IP address of the ECS instance. In addition, you must apply for a public endpoint for the RDS instance. For more information, see Apply for or release a public endpoint.

    Ip地址

  3. Click OK.

  4. In the left-side navigation pane, click Data Security. On the page that appears, click the Distributed Transaction Whitelist tab.

  5. Click Create Whitelist.

  6. Configure the following parameters and click OK.

    Parameter

    Description

    Whitelist Name:

    Enter a name for the whitelist. The name must be 2 to 32 characters in length and can contain digits, lowercase letters, and underscores (_). The username must start with a lowercase letter and end with a lowercase letter or digit.

    IP Addresses

    Enter the IP address of the ECS instance and the name of the Windows-based computer on which the ECS instance resides. Make sure that you separate the IP address and the computer name with a comma (,). Example: 192.168.1.100,k3ecstest.

    If you want to enter more than one entry, make sure that each entry is in a different line.

    Note

    To view the computer name, open Control Panel of your computer and choose System and SecuritySystem.

    image.png

Configure the ECS instance

  1. Log on to the ECS console.

  2. In the left-side navigation pane, choose Instances & Images > Instances. In the top navigation bar, select the region in which the ECS instance resides.

  3. Find the ECS instance and click its ID.

  4. Click the Security Groups tab.

  5. Find the security group and click Configure Rules in the Actions column.

  6. On the Inbound tab, click Add Rule.

  7. Configure the following parameters and click OK.

    Parameter

    Description

    Action

    Select Allow.

    Priority

    Enter 1.

    Protocol Type

    Select Custom TCP.

    Port Range

    Enter 135.

    Note

    Port 135 is the fixed port for the Remote Procedure Call (RPC) service.

    Authorization Object

    Enter the two IP addresses of the RDS instance in the Authorization Object field. You can view the IP addresses on the Distributed Transaction Whitelist tab of the Data Security page.分布式事务白名单

    Description

    Enter a description that helps identify the rule. The description must be 2 to 256 characters in length and cannot start with http:// or https://.

  8. Add another security group rule. Set the Port Range parameter for this rule to 1024/65535 and use the same settings of other parameters as the previous rule.

Configure your Windows operating system

  1. Log on to the Windows Server 2016 operating system.

  2. Open the hosts file in the C:\Windows\System32\drivers\etc directory.

  3. Enter the two IP addresses of the RDS instance at the end of the hosts file. You can view these IP addresses on the Distributed Transaction Whitelist tab of the Data Security page in the ApsaraDB RDS console.

    分布式事务白名单

  4. Save the hosts file.

  5. Open Control Panel of your computer, choose System and Security > Administrative Tools, and then double-click Component Services.

  6. Choose Component Services > Computer > My Computer > Distributed Transaction Coordinator.

  7. Right-click Local DTC and select Properties.

  8. Click the Security tab and configure the parameters.

  9. Click OK. In the MSDTC Service message, click Yes. Then, wait for the MSDTC service to restart.

Initialize the new accounting data management tool

  1. Download the software package of the accounting data management tool that is used with Kingdee K/3 WISE 15.1 or 15.0.

    Note

    Different Kingdee K/3 WISE versions require different accounting data management tools. Only the accounting data management tools of Kingdee K/3 WISE 15.0 and 15.1 are provided.

  2. Decompress the package and save it to the following installation directory of Kingdee K/3 WISE: K3ERP\KDSYSTEM\KDCOM.

  3. Open Kingdee K/3 WISE.

  4. In the dialog box that appears, configure the identity verification and data server information.

    Note

    You must configure the internal endpoint of the RDS instance for the data server.

  5. Configure the preset connection.

  6. Register the set of books.

  7. Select the specified database and click All.

Log on to Kingdee K/3 WISE

After all the settings are complete, you can run distributed transactions between the ECS and RDS instances. In addition, you can then log on to and use Kingdee K/3 WISE.

References