[mMC GUI] Databases

The Databases tab contains the list of all databases that were configured.

If a data source lacks the information required for scanning, the database icon has a pencil icon inside.

Database List

The data source database list is a table with the following columns:

The possible data source statuses are:

Incomplete: the provided data source configuration is not enough for establishing a connection.
Unprocessed:
- Connection was added but wasn’t scanned.
- Connection was scanned but, after that, was edited.
- Connection was added and tested but wasn’t scanned.
Processing:
- Connection is being tested.
- Connection is being scanned.
- Scan results are being uploaded.
- Scan results are being saved.
Saved: connection was scanned and scan results were successfully saved locally.
Uploaded: connection was scanned and scan results were successfully uploaded to mConsole.
Failed: errors occurred during the testing, scanning, saving, or uploading process.

To edit any data source configuration, press the pencil icon within the tile.

Add Data Source Database Configuration

To add and configure a data source database configuration manually:

On the Databases tab, press the round + button in the bottom right corner to expand it.
In the dropdown list, press Add Data Source.
In the Add Data Source Database window, enter the connection name. It must be unique among all configured databases.
In the Add Data Source Database window, select the DB engine of the data source.
In the Add Data Source Database window, in the tabs, enter the source information. The displayed tabs and fields depend on the selected DB engine. For more details about specific tabs and parameters, see the Engine-Specific Parameters section below.
To perform scanning, it is necessary to fill in all fields in the Connection tab. A data source with missing values can be saved but can’t be scanned.
To save the source, press Save.

Engine-Specific Parameters

Oracle

For Oracle data sources, the Add/Edit Data Source Database window contains the following tabs:

Connection that contains the following connection details:
- Host
- Port
- User
- Password
- Service name/SID
- CDB User
- CDB Password
- CDB SID
Scan that contains the following scan settings:
- Max Number of Parallel Queries that defines the maximum number of threads for the parallel execution of queries
- Query Time Out (in minutes)
Tags that allow assigning custom tags to the database. Assigning custom tags simplifies further filtering sources in mConsole.

PostgreSQL

For PostgreSQL data sources, the Add/Edit DataSource Database window contains the following tabs:

Connection that contains the following connection details:
- Host
- Port
- User
- Password
Scan that contains the following scan settings:
- Max Number of Parallel Queries that defines the maximum number of threads for the parallel execution of queries
- Query Time Out (in minutes)
- Scan Duration for the Extended Scan mode
- Sample Interval for the Extended Scan mode
Tags that allow assigning custom tags to the database. Assigning custom tags simplifies further filtering sources in mConsole.

SQL Server

For SQL Server data sources, the Add/Edit Source Database window contains the following tabs:

Connection that contains the following connection details:
- Host
- Port
- User
- Password
Scan that contains the following scan settings:
- Max Number of Parallel Queries that defines the maximum number of threads for the parallel execution of queries
- Query Time Out (in minutes)
- Exclude Read-Only Databases
Tags that allow assigning custom tags to the database. Assigning custom tags simplifies further filtering sources in mConsole.

MySQL

For MySQL data sources, the Add/Edit Data Source Database window contains the following tabs:

Connection that contains the following connection details:
- Host
- Port
- User
- Password
Scan that contains the following scan settings:
- Max Number of Parallel Queries that defines the maximum number of threads for the parallel execution of queries
- Query Time Out (in minutes)
- Scan Duration for the Extended Scan mode
- Sample Interval for the Extended Scan mode
Tags that allow assigning custom tags to the database. Assigning custom tags simplifies further filtering sources in mConsole.

MongoDB

For MongoDB data sources, the Add/Edit Data Source Database window contains the following tabs:

Connection that contains the following connection details:
- Host
- Port
- User
- Password
- Cluster name
- Authentication
SSL/TLS that contains the following settings:
- CA Certificate File
Tags that allow assigning custom tags to the database. Assigning custom tags simplifies further filtering sources in mConsole.

HBase

For HBase data sources, the Add/Edit Data Source Database window contains the following tabs:

Connection that contains the following connection details:
- ZooKeeper Quorum
- ZooKeeper Client port
- HBase Master port
Kerberos Authentication that contains the following settings:
- Keytab File Path
- Configuration File Path
- Principal
Tags that allow assigning custom tags to the database. Assigning custom tags simplifies further filtering sources in mConsole.

DB2 LUW

For DB2 data sources, the Add/Edit DataSource Database window contains the following tabs:

Connection that contains the following details:
- Host
- Port
- User
- Password
- Database ID
SSL/TLS that contains the following settings:
- CA Certificate File
Tags that allow assigning custom tags to the database. Assigning custom tags simplifies further filtering sources in mConsole.

Test Connectivity

Testing connectivity allows validation of the input data before scanning and without scanning. Do this to avoid running scanning that would result in errors because of incorrect connection parameters.

mMC has two ways of testing connectivity to sources:

Select a data source from the list and press the Test button.
Press the Test button in the Add Data Source Database or Edit Data Source Database window.

After selecting the data sources and running tests, the pop-up window displays a list of the data source tiles. The pop-up window helps to track the progress of testing and see which data sources can be connected successfully and which cannot.

As the testing progresses, the progress icons near the file names will change to the success or error icons that represent the testing results:

Tile

Status Description

Testing is in progress.

Testing is finished. mMC failed to connect to the data source.

The accurate interpretation of status is displayed in the log.

Testing is finished. mMC successfully tested the data source connection. The data source is ready for scanning.

To continue working with other data sources during the testing, minimize the pop-up window.

To explore testing results in more detail, in the pop-up window, press View Log.

The log is a table that contains metadata of each test and provides information about possible reasons for errors. To export the log for further analysis, press the Log Directory button and choose the directory for saving the log.

Edit Data Source Database Configuration

To edit an existing data source configuration in the Edit Data Source Database window, use either of the ways:

Press the Edit button inside the source tile.
Select the check box of the source and press the Edit button on the Actions panel.

To edit several existing data source configurations, select data sources from the list and press the Edit button on the Actions panel. Then, the bulk edit window appears. For each source:

Edit the configuration.
Press Save Current.
Then, the next selected data source configuration appears.

Delete Data Source Database Configuration

To delete existing data sources, select them in the list and press the Delete button in the Actions panel.

Filter Data Sources

To filter the displayed data source databases, use the Filter section. The Filter section allows searching by the data source name, status, and DB engine.

For example, it would help to find only previously unscanned Oracle data sources or filter out all data source databases that failed to be scanned.

Discover Databases

The database discovery feature allows identifying the data sources in the specific connection for their subsequent scanning.

The database discovery is available only for Oracle, PostgreSQL, MySQL, and SQL Server sources.

To discover databases, on the Databases tab:

Press the round + button in the bottom right corner to expand it.
In the dropdown list, press Discover.
In the Data Source Discovery pop-up window, select DB engines and enter the hosts and ports for connections to discover. To discover multiple connections, enter the range of values needed to discover. For example, in the Host field, you can enter 192.168.101.999-192.168.999.999.
Add as many rows as needed.
Press Discover.
After the source discovery is completed, select sources to save from the list and press Save.

Scan Data Source Databases

To scan data source databases, select them from the list and press Scan.

If scanning in the offline mode, the pop-up window suggesting to log in appears. Go to the login page or proceed with scanning in the offline mode.

After pressing the Scan button, the Scan Processing pop-up window showing the scanning status appears. The Scanned, Processing title shows a number of data sources that are already scanned and that are still being scanned.

As the scanning progresses, the progress icons near the file names will change to the success or error icons that represent the testing results.

To cancel scanning for one source, press the Cancel button next to it. To cancel scanning for all sources, press the Cancel Processing button.

Cancelling is possible only for those data sources that haven’t been scanned yet.

To explore scanning results in more detail, in the pop-up window, press View Log.

The log is a table that contains metadata of each scanning and provides information about possible reasons for errors. To export the log for further analysis, press the Log Directory button and choose the directory for saving the log.

During the scanning, mMC doesn’t allow adding new data sources to the list of scanned data sources. Wait till the end of scanning and, then, run new scanning process.

During the scanning, the data source tiles reflect the status:

Tile	Status Description
	The data source number is bigger than the maximum thread number set in the Scan Preferences. The data source is scheduled for scanning after the current processes are completed.
	Scanning is in progress.
	The scan results are being uploaded or saved locally.
	The scanning is finished. mMC failed to scan, upload, or save the source. The accurate interpretation of status is displayed in the log.
	The scanning is finished. mMC succesfully scanned the data source and uploaded/saved the scan results.

Incomplete Data Sources

If any data sources lack the necessary information, the notice near the Scan button will indicate how many sources will be skipped due to the missing information.

Press View to open the page with the list of incomplete data sources.

To include data sources in scanning:

Edit data sources and add the missing information.
Press Back.
Run scanning.

To proceed with only some of the data sources in the list, add the missing information only for them and, then, press Back.

Scan in Background

While scanning is in progress, it is possible to continue working with data sources. To do that, minimize the processing window and continue working in mMC.

To get back to the processing window, press the chevron next to the Scan button.

The panel next to the Scan button indicates the processing state. It shows how many data sources from the total amount were processed.

To cancel processing, press the cross and confirm canceling in the pop-up window.