Database

Prev Next

Database credentials enable Discovery to connect to supported database platforms and retrieve database server and instance information.

The Database Credentials page supports the following database types:

Database Type

Description

Microsoft SQL Server

Connects to a Microsoft SQL Server instance by using database credentials.

MySQL / MariaDB

Connects to a MySQL or MariaDB database server by using database credentials.

PostgreSQL

Connects to a PostgreSQL database server by using database credentials.

Oracle Database

Connects to an Oracle Database instance by using database credentials.

MongoDB

Connects to a MongoDB database server by using database credentials.

Figure: Database

Figure: Database

Configure a Database Credential Profile

Create a database credential profile to allow Discovery to connect to a supported database server and retrieve database information.

Perform the following steps to configure and check a database credential profile:

  1. Select the Database credential category.

  2. Select the DB tab.

  3. Select New account.

  4. Select the required Department.

  5. Enter a profile name.

  6. Select the required platform from Database Type:

    • Microsoft SQL Server

    • MySQL / MariaDB

    • PostgreSQL

    • Oracle Database

    • MongoDB

  7. Enter the database username and password.

  8. In Port (0 = default), enter 0 to use the default port for the selected database type, or enter the port configured for the target database server.

  9. Enter the initial database name in Default Database (optional), when required.

  10. Select the required option from SSL Mode.

  11. Enter the database server host name or IP address in Test target host / IP.

  12. Select Test Connection to verify the credentials, connection settings, and target availability.

  13. After a successful connection test, select Save Profile.

Select Cancel to discard the entered information.

Database Credential Fields

Field Name

Description

Department

Select the Department for which you want to create the database credential profile.

Profile Name

Enter a unique and descriptive name for the credential profile. For example, Production SQL Server.

Database Type

Select the database platform to which Discovery must connect. The available options are Microsoft SQL Server, MySQL / MariaDB, PostgreSQL, Oracle Database, and MongoDB. For more information, refer Database Type Examples.

Username

Enter the username that has permission to connect to the selected database platform and retrieve the required information.

Password

Enter the password associated with the database username.

Port (0 = default)

Enter the port configured for the target database server. Enter 0 to use the default port for the selected database type.

Default Database (optional)

Enter the database name that Discovery must use to establish the initial connection. Leave this field blank when a default database is not required.

SSL Mode

Select the SSL mode that controls whether Discovery uses TLS and verifies the database server certificate. For more information, refer SSL Mode.

Test target host / IP

Enter the host name or IP address of the database server against which you want to test the credentials. For example, 10.0.0.12 or dc01.corp.local.

Default Database Ports

When Port (0 = default) contains 0, Discovery uses the default port associated with the selected database type.

Database Type

Default Port

Microsoft SQL Server

1433

MySQL / MariaDB

3306

PostgreSQL

5432

Oracle Database

1521

MongoDB

27017

Note

Enter a different port when the target database server does not use its default port.

Default Database Examples

The value entered in Default Database (optional) depends on the selected database type.

Database Type

Example

Microsoft SQL Server

master

MySQL / MariaDB

information_schema

PostgreSQL

postgres

Oracle Database

ORCL

MongoDB

Enter the database configured for authentication or initial connection.

SSL Modes

The SSL Mode setting determines whether Discovery encrypts the database connection and verifies the database server certificate.

SSL Mode

Description

Disable (no TLS)

Connects to the database server without TLS encryption. Select this option only when the target database server does not require an encrypted connection.

Require (TLS, no verify)

Encrypts the connection through TLS but does not verify the database server certificate or host name.

Verify CA

Encrypts the connection and verifies that a trusted Certificate Authority signed the database server certificate. This mode does not verify whether the certificate host name matches the target host name.

Verify Full

Encrypts the connection, validates the database server certificate against a trusted Certificate Authority, and verifies that the certificate host name matches the target host name.

Important

Use Verify Full when the database server has a valid certificate issued by a trusted Certificate Authority and the certificate contains the host name used for the connection.

Manage Database Credential Profiles

The credential profile list displays the configured database credential profiles.

Credential Profile List

Column

Description

Account Name

Displays the name assigned to the database credential profile.

Type

Displays Database as the credential type.

Username

Displays the username configured for the database credential profile.

Active Status

Indicates whether the credential profile is active. Use the toggle to activate or deactivate the profile.

Last Updated

Displays the date and time when a user last updated the credential profile. Select the column heading to sort the profiles by the last updated date and time.

Actions

Provides options to edit the credential profile or view its change history.

Activate or Deactivate a Database Credential Profile

Use the Active Status toggle to control whether Discovery can use the database credential profile.

  • Turn on the toggle to activate the credential profile.

  • Turn off the toggle to deactivate the credential profile.

A deactivated credential profile remains available in the list, but Discovery does not use the profile for later discovery operations.

Edit a Database Credential Profile

To edit a database credential profile:

  1. Select the Database credential category.

  2. Select the DB tab.

  3. Locate the credential profile in the list.

  4. Select the Edit icon under Actions.

  5. Update the required profile details.

  6. Enter or update the password when required.

  7. Enter a database server host name or IP address in Test target host / IP.

  8. Select Test Connection to verify the updated credentials and connection settings.

  9. Select Save Profile.

View Database Credential Profile History

The credential profile history provides a read-only record of changes made to the selected database credential profile. The newest changes display first, and secret values remain masked.

To view the credential profile history:

  1. Select the Database credential category.

  2. Select the DB tab.

  3. Locate the credential profile in the list.

  4. Select the History icon under Actions.

  5. Review the available history records.

Change History Fields

Field Name

Description

Field name

Displays the name of the database credential profile field that a user added or changed, such as Discovery Credential Name, Department, Used for, or Active.

Old value

Displays the field value before the change. A hyphen (—) displays when no previous value exists. Secret values remain masked.

New value

Displays the field value after the change. Secret values remain masked.

Date changed

Displays the date and time when the change occurred.

Changed by

Displays the identifier of the user who made the change.

The page also displays the number of available change records. End of history indicates that no other records are available.

Select Close to close the Change history page and return to the database credential profile list.

List Page Actions

Action

Description

New account

Opens the form for creating a database credential profile.

Active Status

Activates or deactivates the database credential profile.

Edit

Opens the selected database credential profile for modification.

History

Displays the change history for the selected database credential profile.