As the business develops and the number of tables increases, Data Management (DMS) provides the category feature to help you classify tables. This way, administrators, developers, and O&M engineers can manage or use the tables more conveniently.

Prerequisites

  • A relational database or data warehouse is used. For more information, see Supported database types.
  • You are a database administrator (DBA) or a DMS administrator. For more information about user roles, see System roles.

Manage categories

  1. Log on to the DMS console.
  2. In the top navigation bar, move the pointer over the All functions icon and choose Data Factory > Category.
  3. Click Create Category.
  4. In the Category Name field of the dialog box that appears, enter the name of a category and click Confirm.
    The created category is displayed in the left-side category tree.
    Note By default, DMS creates the Uncategorized category. All the tables that are not added to categories belong to this category.
  5. Find the category that you want to manage. Move the pointer over the Icon for managing categories icon.
    • Create a subcategory

      To create a subcategory, move the pointer over the Icon for managing categories icon and select Create Subcategory.

      You can create up to four category levels. If no table is added to a category, you cannot create a subcategory for this category.

    • Modify the name of a category

      To modify the name of a category, move the pointer over the Icon for managing categories icon and select Change.

    • Delete a category

      To delete a category, move the pointer over the Icon for managing categories icon and select Delete.

      If a subcategory is created in this category or tables are added to this category, this category cannot be deleted.

Add a table to a category

Each table can be added to only one category. If you add a table to another category, the table is removed from the existing category.

  1. Log on to the DMS console.
  2. In the top navigation bar, move the pointer over the All functions icon and choose Data Factory > Category.
  3. Click the category to which you want to add a table.
    Note To view subcategories, you can click the Icon to display subcategories icon on the left side of the category.
  4. On the page of the category, click Add Tables in the upper-right corner of the page.
    Note You can also use one of the following methods to add a table to a category.
    • On the Tables page of the table that you want to manage, click the Icon for configuring categories icon next to Category. For more information, see Table details.
    • On the page of the Uncategorized category, find the table that you want to manage and click Associate Category in the Actions column.
  5. In the dialog box that appears, search for and select the table that you want to add, and then click Confirm.
    Note You can add multiple tables to a category at a time.
    At this time, the table is added to the category.

Remove a table from a category

To remove a table from a category, find the table on the page of the category and click Remove from Category in the Actions column.