A database profile is an evaluation report that ADAM generates for your source database. It summarizes complexity, risk exposure, and object distribution so you can estimate migration effort, identify schema conversion challenges, and search for specific objects during transformation.
Before you begin
Before you create a profile, collect the data file exported from your source database. You upload this file in step 4 of the creation procedure. Profile creation takes 1–30 minutes depending on the collected data.
Create a profile
Log on to the Data Management (DMS) console V5.0.
In the top navigation bar, hover over Data + AI, then choose Heterogeneous Database Migration(ADAM) > Database Evaluation.
Click the Source DB Profile tab, then click Create Profile in the upper-left corner.
In the Create Profile panel, set the Profile Name, Type, and Report Language Type parameters. Click Upload to upload the data file, then click Create.
The profile is ready when its status changes to Complete. This typically takes 1–30 minutes.
View a profile
On the Source DB Profile tab, find the profile and click Details in the Actions column.
The profile page has two tabs with distinct purposes:
Overview — a high-level assessment across six dimensions plus object distribution. Use this to judge overall migration complexity and risk before committing to a project plan.
Details — granular performance, capacity, and object-level data for deeper analysis. Available for Oracle database profiles only.
Overview tab
The Basic Information section shows six metrics that together give you a snapshot of your source database:
| Metric | What it measures | How to interpret it |
|---|---|---|
| Session | Concurrent connection activity | A higher value means more sessions are established to the database. |
| Complexity | Overall database complexity, evaluated from usage scenarios and collected source data | A higher value means more complex migration work. |
| Risk | Exposure to performance-related issues in SQL statements or database objects | A higher value means more objects or SQL patterns that require manual review or conversion. |
| Hotspot | Frequency of object access | A higher value means more objects are accessed frequently. |
| Scale | Scale of database resources | A higher value means a larger database. |
| Load | Database performance load | A higher value means the database is under heavier load. |
The Main Objects section displays the distribution of object types in the source database.
To download the full profile, click Download Report at the bottom of the page.
Details tab
The Details tab is available for Oracle database profiles only.
| Section | What it shows |
|---|---|
| Performance | Transactions per second (TPS), queries per second (QPS), CPU utilization, and load. |
| Capacity | Capacity ranking by database schema, and capacity breakdown by object type — table, index, and large object (LOB). |
| Oracle Features | A two-level tree diagram and a table listing all features collected from the source database. Click a feature to see which objects use it. Use the search box to filter by keyword. |
| External Dependency | Database links and their details. If the source database has external dependencies, plan to revise the affected schemas before transformation. |
| Other Dimensions | Special tables and SQL statements that may require attention — for example, tables without primary keys, high-growth tables, and SQL statements with aggregate functions. Click View in the Actions column to see details. |
| Object Details | Object information grouped by feature tags, relationships (association and dependency), and contained features. Click View Object Details in the Actions column to open the detail dialog. In the Basic Information section, you can view basic object info and DDL statements. In the Details section, you can view ADAM analysis data: features, referenced objects, dependent objects, and object-level features. |
| Object Search | Search for objects during database and application transformation. Supports exact matches, fuzzy matches, and type-based matches. Filter by schema, DDL, object type, or tag, and view object dependencies and tags. |
Other operations
| Operation | Description | Steps |
|---|---|---|
| Update the profile | Append a new data file to create a new version of the profile. Use this when source database data has changed after the initial profile was created. | 1. Find the profile and click Append in the Actions column. <br>2. Click Upload to upload the new data file, then click Create. <br>3. Enter remarks and click Create. The system generates a new version from all data files. |
| Grant permissions on the profile | Grant a user access to view the profile, view related projects, create database evaluation projects, and download evaluation reports. Permissions are valid for one month and can be revoked before they expire. | 1. Find the profile and click Authorize in the Actions column. <br>2. In the Authorize panel, select Confirm and enter the Alibaba Cloud unique ID (UID) of the target user, then click OK. <br> Important Use this feature with caution. You are responsible for data disclosures caused by improper authorization. Note To get the UID, hover over the |
| Delete the profile | Delete a profile you no longer need. Deleting a profile also deletes all evaluation projects generated from it. | 1. Find the profile and choose ... > Delete in the Actions column. <br>2. In the Delete message, click OK. |
icon in the upper-right corner of the DMS console.What's 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.