Set data source and database owners

Assign data owners to data sources, databases, or database groups so approval workflows can route requests to the right responsible person or role.

Overview

Different business lines often use different data sources and have different owners. Without data owner routing, administrators usually have to choose between two approval designs:

• Use one approval process for all owners: This is easy to maintain, but requesters may have to select from a long list of approvers and can choose the wrong owner.
• Create separate approval processes for each business: This improves routing accuracy, but it creates a large number of approval processes and increases maintenance effort when owners change.

NineData provides a Data Owner option to simplify this setup. Administrators assign owners to data sources, databases, or database groups, and then select Data Owner as the approver in the approval process. When a user submits a request, NineData routes the request to the owner of the related resource.

Before you begin

• You have created or joined an organization, and this organization has subscribed to either DevOps Pro or DevOps Enterprise. 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 details, see Add data sources.
• The database groups that need a data owner have been created. For details, see Create database groups.

Procedure

Add data owners

NineData supports owners for data sources, databases within data sources, and database groups.

Data Source

When a user adds a new data source, that user becomes the default data source owner. To change the owner or add more owners, follow these steps.

1. Sign in to the NineData Console.

2. Go to Datasource > Datasource.
3. On the Datasource tab, click the target Datasource ID to open the Details page.
4. In the data source details area, click More.
5. Find Datasource Owner and click the icon on its right side.
6. In the dialog, select one or more target users or roles, and then click OK.

Database

If a single data source is managed by multiple business teams, or if different databases need different database owners, follow these steps.

1. Sign in to the NineData Console.

2. Go to Datasource > Datasource.
3. On the Datasource tab, click the target Datasource ID to open the Details page.
4. In the data source details area, click More.
5. Find Database Owner and click the icon on its right side.
6. In the dialog, select one or more target users or roles, and then click OK.

Database Group

If you have created database groups for unified table changes across distributed databases, add database group owners.

1. Sign in to the NineData Console.

2. Go to Datasource > Datasource.
3. Click the Database Grouping tab, then click the target Database Grouping Name to open the Database Grouping Detail page.
4. In the database group details area, find Database Group Owner and click the icon on its right side.
5. In the dialog, select one or more target users or roles, and then click OK.

Link approval processes

1. Sign in to the NineData Console.

2. Go to DevOps > Policy & Process.
3. On the Policy & Process page, click the Approval Process tab, then click the target Name.
4. NineData opens the Details page. Click the required task tab in the approval process, and then click Edit for the target rule level.
5. On the Edit Process page, under the approval process section, select Datasource Owner as the approver, then click OK.
6. Link the configured approval process to the environment, data source, or database group that requires data-owner routing.

Result

The selected users or roles become owners of the corresponding data source, database, or database group. Approval processes that reference the data source owner can route requests to those owners.