Background information
After the project administrator creates a project member, the project member can create a data source and add a database in the data source to the project to perform database change tasks.
The system administrator creates a project in Web ODC and assigns members to the project.
The system administrator or a project member with the data source creation privilege creates a data source.
The project DBA and project owner adds a database in the data source to the project.
A project member creates a database change task.
When the project member initiates a task ticket, the approval process is automatically selected based on the risk level and identification rules.
The approval roles on the corresponding approval process nodes review the task process.
The database change task is executed after it is approved.
Manage data sources
View, edit, and remove the data sources in the data source list.
View data sources
In the data source list, you can perform the following operations:
Item | Description |
Connection Name | View the name, type, host name, port number, cluster name, tenant name, and database username information of the data source. You can click the name of a data source to manage the databases, sessions, and recycle bins of the data source. You can also execute SQL statements in the CLI. |
| Search for data sources. |
| Filter data sources by type. |
| Sort data sources. |
| Refresh the data source list. |
Actions | Manage data sources. You can click the More icon to display the Edit and Remove options. |
Edit a data source
Click Edit in the Actions column of the target data source. The Edit Data Source panel appears, which shows the configuration information of the current data source in a similar way as the Create Data Source panel. You can modify the settings in the Edit Data Source panel.
Before you change Database Password, you must first click Change Password next to the password box. If you want to cancel the modification, click Cancel next to the Password field.
Copy a data source
In the lower-right corner of the Edit Data Source panel, click Copy Connection String.
In the Create Data Source panel, paste the connection string to the Intelligent Parsing field. The configuration information of the current data source is automatically filled in for the new data source.
Remove a data source
If a database no longer exists or you no longer need to access a database, you can remove the corresponding data source.
Click Remove in the Actions column of the data source to delete it.