All Products
Search
Document Center

Data Transmission Service:Manage a database profile

Last Updated:Aug 17, 2022

A database profile is used to evaluate a source database. The database profile helps you monitor the status of your source database. When you migrate or transform the source database, you can search for the database based on the database profile.

Create a profile

  1. Log on to the Data Management (DMS) console V5.0.

  2. In the top navigation bar, move the pointer over DTS. Choose Heterogeneous Database Migration(ADAM) > Database Evaluation.

  3. Click the Source DB Profile tab. In upper-left corner of the Source DB Profile tab, click Create Profile.

  4. In the Create Profile panel, set the Profile Name, Type, and Report Language Type parameters. Click Upload to upload a data file. Then, click Create.

    Note

    • The database profile is expected to be created in 1 minute to 30 minutes. The time depends on the collected data of the source database.

    • If the database profile enters the Complete state, the database profile is created.

View the profile

On the Source DB Profile tab, find the database profile that you want to view and click Details in the Actions column.

View the overview

On the Overview tab, you can view the overview of the database profile.

  • Basic Information

    • Session: the connection status of the database. The higher the value is, the more sessions are established to the database.

    • Complexity: the complexity of the database. The complexity is evaluated based on the collected information about the source database, such as the scenarios in which the source database is used. The higher the value, the more complex the database.

    • Risk: the risk level of the database. The higher the value is, the more likely the database is exposed to performance risks related to SQL statements or objects.

    • Hotspot: indicates whether the database contains objects that are frequently accessed. The higher the value is, the more objects are frequently accessed.

    • Scale: the scale of database resources. The higher the value, the larger the database scale.

    • Load: the performance of the database. The higher the value, the larger the load of the database.

  • Main Objects

    This section displays the distribution of object types in the source database.

Note

You can also click Download Report in the lower part of the page to download the database profile.

View the details

On the Details tab, you can view the details of the database profile.

Note

You can view the details of only the profiles of Oracle databases.

  • Performance

    This metric shows the transactions per second (TPS), queries per second (QPS), CPU utilization, and load of the database.

  • Capacity

    This metric shows the capacity ranking of database schemas and the capacity proportion of different object types such as table, index, and large object (LOB).

  • Oracle Features

    This metric shows features used by your source database in a tree diagram and a table. The tree diagram provides two levels to list all the features collected from the database. If you click a feature, the objects that use the feature are listed in a table. You can search for features by entering a condition in the search box.

  • External Dependency

    This metric shows database links and link details. You must revise schemas when you transform databases that contain external dependencies.

  • Other Dimensions

    This metric shows special tables and SQL statements, such as tables without primary keys, high growth tables, and SQL statements with aggregate functions. You can click View in the Actions column to view details.

  • Object Details

    This metric shows object information from different dimensions, such as object feature tags, relationships such as association and dependency, and features contained in objects. You can click View Object Details in the Actions column to view details.

    In the Basic Information section of the View Object Details dialog box, you can view the basic information and DDL statements of the object. In the Details section, you can view the analysis data provided by ADAM, such as the features, referenced objects, dependent objects, and features of the object.

  • Object Search

    The Object Search feature allows you to search for objects when you transform databases and applications. Exact matches, fuzzy matches, and type-based matches are supported. You can combine different filter conditions to search for objects in the database profile. You can search for objects by schema, DDL, object type, or tag. You can also view the dependencies and tags of objects.

Other operations

Operation

Description

Procedure

Update the profile

You can create multiple versions for a database profile. If the data in a source database is changed after a database profile is created, you can append a new data file to the database profile.

  1. On the Source DB Profile tab, find the database profile to which you want to append a new data file and click Append in the Actions column.

  2. Click Upload to upload the new data file. Then, click Create.

  3. Enter the remarks and click Create.

The system automatically generates a new version of the database profile based on all data files.

Grant permissions on the profile

  • If you grant permissions on a profile to a user, the user can view the database profile, view projects related to the database profile, create database evaluation projects, and download evaluation reports.

  • The validity period of the permissions is one month. You can revoke the permissions before the permissions expire.

Notice

Use the authorization feature with caution. You are liable for data disclosures caused by improper authorization.

  1. On the Source DB Profile tab, find the database profile on which the permissions you want to grant and click Authorize in the Actions column.

  2. In the Authorize panel, select Confirm and enter the Alibaba Cloud unique ID (UID) of the user to whom the permissions are granted. Then, click OK.

Note

To obtain the UID, you can move your pointer over the icon in the upper-right corner of the Data Management (DMS) console.

Delete the profile

You can delete a profile that is no longer needed. After you delete the profile, evaluation projects that are generated based on the profile are automatically deleted.

  1. On the Source DB Profile tab, find the database profile that you want to delete and choose ... > Delete in the Actions column.

  2. In the Delete message, click OK.

What to do next

Select a profile and click Next: Select Destination Database to go to the Select Destination DB tab. For more information, see Select a destination database.