When advanced development of the database is required, such as enterprise collaboration, secure release, and federated query, you should first add the database to the data source and enable security control capabilities for unified management.
Data source management also supports modifying data source execution accounts, deleting data sources, and downloading the data source list.
Use Limits
For the same instance, the restriction relationships among the data source page, the controlled instance page, the quick login page, and the SQL window page are described as follows:
Control is not enabled for the data source.
Adding a database on the Basic Development > Quick Log-in page is supported, and all operations on the Quick Login page are supported.
Logging in to an instance via password on the Basic Development > SQL Window page is supported.
Control is enabled for the data source.
Adding a database on the Basic Development > Quick Log-in page is not supported. If quick login is added first before enabling control for the data source, the instance status on the Quick Log-in page will be Disable, and only deletion operation is supported.
Logging in to an instance via password on the Basic Development > SQL Window page is supported.
To log in to the SQL window, you can navigate to the Secure Release > Instance Control > Control Instances page, and click Log In in the Operation column of the instance list.
Prerequisites
The source database instance has been created.
The region, name, port, high-permission database account, and password of the source database instance have been obtained. For information on how to set high permissions for the account, see Setting High Permissions for Database Instance Accounts.
It is customizable and uniquely identifies a data source.
Naming specification: Only numbers, uppercase and lowercase English letters, Chinese characters, and special characters such as _, -, ., /, (), and [] are supported, with a length less than 60.
Example value: test
✓
✓
✓
Port
Enter the port number for accessing the CVM instance.
Example value: 3016
x
✓
x
Execution Account
Enter the high-level permission account of the database instance for the execution of advanced database features. If a low-level permission account is used, the system will prompt a detection failure when checking account permissions and connection status.
The password corresponding to the execution account.
Example value: azj***24!
✓
✓
✓
Account Status
After entering the above parameters, click Check Account Permissions and Connection Status. You may proceed to the next step once the check shows Passed.
After making any necessary modification, click Check Account Permissions and Connection Status again until it shows Passed, then proceed to the next step.
✓
✓
✓
Tag
Tags associated with the instance.
✓
✓
x
Remarks
Enter the description information related to the data source.
✓
✓
✓
5. After you complete the configuration, click Create Data Source.
The created data source will be displayed in the data source list.
2. In the left sidebar, select Advanced Development > Data Source.
3. In the Operation column corresponding to the data source to be enabled, click Activate Control. In the pop-up dialog box, select a rule template and click Activate Now.
For the rule template description and operations, see Rule Template.
Notes:
After an instance is bound to a rule template, subsequent SQL window operations, SQL change operations, and ticket approvals for that instance will be governed by the rule template.
After control is enabled, the page will redirect to the Manage Instance page, and the data source will be automatically added to the controlled instance list.
The Manage Instance page also supports enabling control for instances that have been added to the data source but have not yet had control enabled. For detailed operations, see Activating Control for Instances.
Modifying the Execution Account of the Data Source
2. In the left sidebar, select Advanced Development > Data Source.
3. In the Operation column corresponding to the data source to be modified, click More > Modify Execute Account.
4. In the pop-up dialog box, modify the execution account and the execution account password, click Test Connectivity, and after the test passes, click OK.
Deleting the Data Source
If there are open tickets, deletion is not supported.
