Sources

The Sources tab allows various actions to be performed on the sources uploaded to mConsole and their features. The actions are listed under the corresponding Actions section: Exclude, Include, Download, or Delete.

Only account owners or users with Data Trustee roles can perform the these data management actions. For more details refer to Account → User Management.

By default, the action buttons are disabled. To enable them, switch to any tab below the Actions section; then, select an item or items to act upon:

Under the Features tab, you can include or exclude specific features across all databases or clusters.
Under the Databases or Clusters tab, you can include whole sources in or exclude them from the migration analysis, include or exclude features for specific sources, download sources to save them on the local environment or delete them from mConsole.

The Databases tab lists relational sources, while the Clusters tab lists NoSQL sources.

Under the Applications tab, you can include or exclude applications, declare new applications, download applications to save them on the local environment, or delete them from mConsole. For more details about the Applications tab, see Applications Management.

Exclude or Include Common Features

The Features tab allows choosing features to consider during the analysis. By default, migVisor uses all detected features to calculate migration complexity. When excluded, the excluded features are ignored during the migration complexity calculation.

The Features list displays features of all sources uploaded to mConsole split by the DB engine type. The Status column shows if a feature is included in or excluded from the analysis.

To exclude features from the analysis:

Select an engine type.
Select the checkbox of a feature in the list.
Click Exclude.

Excluding or including features changes their status in the list.

Databases and Clusters

The Databases and Clusters sections allow excluding sources or their features from the analysis, downloading sources, or deleting them from mConsole.

Switching to the Databases or Clusters tab opens the list of uploaded sources split in conformity with their platforms. The content of the table depends on the DB engine:

Oracle | SQL Server | PostgreSQL | MySQL | DB2

Hostname
Instance name
Database name
Version
CPU
Server RAM (GB)
Oracle: Allocated Memory - SGA (GB) / All Other: Allocated Instance Memory (GB)
DB Storage (GB)
Avg Physical Read Ops/Sec
Avg Physical Write Ops/Sec
Associated Applications
Status sections that show if any exclusions were made for features, sources, or schemas

In MySQL and PostgreSQL, the CPU, Server RAM, Allocated Memory, Avg Physical Read Ops/Sec, and Avg Physical Write Ops/Sec values are editable. The values shown may not reflect scan results, but rather best practice and configuration values. These parameters have an icon with a tooltip explaining that.

Mongo DB | HBase

Cluster
Cluster ID
Topology
Versions
Status sections that show if any exclusions were made for features or sources.
The Clusters tab

Exclude or Include Sources

The Databases, Clusters, and Applications tabs allow choosing sources to include or exclude in the analysis. By default, migVisor considers all sources uploaded to mConsole as candidates participating in different migration and/or modernization calculations. When excluded, the excluded sources are ignored from the calculation and can’t participate in the analysis.

Each tab displays all sources of that type that were uploaded to mConsole, split by the DB engine type for databases and clusters or Language type for Applications.

The Database/Cluster/Application exclusion status column shows if the source is Included in or Excluded from the analysis.

To exclude sources from the analysis:

Select DB engine.
Select the checkbox of one or more sources in the list
Click Exclude on the Actions section.

The Source exclusion status of the feature becomes grayed and turns into Excluded.

To include sources, repeat steps 1-3 by choosing the Include action instead of the exclude one.

Download Sources

To download a ZIP file with the data that mConsole used to calculate migration complexity, select a source from the list and click Download.

Remove Sources

To delete sources from mConsole, select them in the list and click Delete.

Exclude Source-Specific Features and Schemas

To view the components and features of a specific source:

For RDBMS sources, click the source name in the DB name column.
For NoSQL sources, click the source name in the Cluster column.

Selecting a source name allows viewing:

List of features the source contains. The Features tab opens by default.
List of schemas or databases the source includes.

Exclude Source Features

To exclude features of a selected source:

From the features list, select features subject to exclude.
Click Exclude on the Actions section.

Then, the status of features changes to Excluded.

If the schema the feature belongs to was excluded from the analysis, the feature’s status changes to Unused. For details, see Excluding Source Schemas below.

If all the features that belong to the schema were excluded from the analysis, the schema will be marked Unused in the list.

Exclude Schemas

Schemas are available for Oracle and PostgreSQL sources only. The Databases tab of MongoDB clusters only shows the list of databases of a cluster and their versions.

To exclude schemas of a selected source:

Open the Schemas tab.
From the list, select schemas subject to exclude.
Click Exclude on the Actions section.

Then, the status of schemas changes to Excluded.

If the schema includes features that were excluded from the analysis, the schema’s status will be Partial.
If all of a schema’s features were excluded from the analysis, the schema’s status will be Unused.

Clicking on a feature name in the Features column opens a new screen that lists the sources in which the feature was detected. The feature name appears at the top, and the list of sources is shown.

Exclusion Results

Excluded items are not considered in score calculations and complexity determination.

Excluded features are shown on the single source page in the Excluded Features subsection. For more details, see Source Features.

Excluded schemas are not displayed on the single source page in the Schemas section.

Include Features and Schemas

To include features or schemas back in the migration analysis:

Open the list of features or schemas. You can open the list of common or source-specific features.
Select excluded items in the list.
Click Include on the Actions section.

Search and Filter

To find particular items:

Search for a particular item using all or part of its name in the Filter field.
Select or clear checkboxes for all items using the checkbox next to the header.
Sort the list using the small arrow in the top row.