Setting Data Source & Database Owners
NineData supports setting a Data Owner for each data source, each database within a data source, or each database group, significantly enhancing the efficiency and accuracy of approval process configurations.
Background Information
Within an enterprise, different business lines typically use different data sources managed by different individuals. To approve various operations on data sources, enterprises create approval processes and configure the responsible individuals in the corresponding approval nodes.
However, since the approval personnel for each business data source may vary, there are two main approaches:
- Putting all approval personnel in a single approval process: This method involves including multiple business heads in a single approval process, with the submitter selecting the appropriate one based on the situation. The advantage is ease of configuration, requiring only one adjustment for personnel changes. The drawback is that with many business heads, it can take a long time to find the right one, and if the submitter is unfamiliar with the business, they might choose the wrong head.
- Creating separate approval processes for each business: This method avoids the above issue by having independent approval processes for each business. The advantage is precision; the drawback is that if there are 1,000 businesses, 1,000 approval processes need to be configured. Apart from the initial configuration cost, any personnel changes would require adjustments to each process, leading to high maintenance complexity.
To better address these issues, NineData offers a Data Owner solution. Administrators can assign different responsible individuals (Data Owners) for each business (data source or database) and select Data Owner as the approver in the approval process instead of specific individuals. When a submitter applies for an operation on a data source or database, the system automatically pulls the Data Owner for that source or database, effectively simplifying the approval process configuration and reducing operational and maintenance costs.
Prerequisites
- You have created or joined an organization, and this organization has subscribed to either or . Please ensure that your annual or monthly subscription is still active. For more information, please refer to Manage Organizations.
- Your current account has switched to the target organization. For more information, please refer to Switching to an Organization.
- The data sources that need a Data Owner have been added to NineData. For instructions on how to add them, please refer to Adding Data Sources.
- The database groups that need a Data Owner have been successfully created. For instructions on how to create them, please refer to Creating Database Groups.
Step 1: Adding a Data Owner
NineData supports adding Data Owners for data sources, databases within data sources, and database groups.
- Data Source
- Database
- Database Group
When you add a new data source, the person who adds it becomes the default Data Source Owner. If you need to change or add other Data Source Owners, follow these steps.
- Log in to the NineData Console.
- In the left navigation bar, click > .
- On the tab, click the target to open the page.
- In the data source details area (which contains information such as data source name, ID, creator, creation time, etc.), click .
- Find and click the icon on its right side.
- In the pop-up window, select the target user or role (single or multiple selection supported), then click .
If a single data source is managed by multiple different businesses, or if there is a need to add different Database Owners for each database, follow these steps.
- Log in to the NineData Console.
- In the left navigation bar, click > .
- On the tab, click the target to open the page.
- In the data source details area (which contains information such as data source name, ID, creator, creation time, etc.), click .
- Find and click the icon on its right side.
- In the pop-up window, select the target user or role (single or multiple selection supported), then click .
If you have created database groups for unified table changes across distributed databases, you can add Database Group Owners.
- Log in to the NineData Console.
- In the left navigation bar, click > .
- Click the tab, then click the target to open the page.
- In the database group details area (the area at the top of the page that contains information such as database group name, creator, creation time, etc.), find and click the icon on its right side.
- In the pop-up window, select the target user or role (single or multiple selection supported), then click .
Step 2: Configuring and Linking Approval Processes
- Log in to the NineData Console.
- In the left navigation bar, click > .
- On the page, click the tab, then click the target .
- The console will redirect to the page. Click the required task tab in the approval process, then click on the right side of the needed rule level.
- On the page, under the approval process section, select as the approver, then click .
- Link the configured approval process as needed to the environment, data source, or database group.