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
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:
Select the Database credential category.
Select the DB tab.
Select New account.
Select the required Department.
Enter a profile name.
Select the required platform from Database Type:
Microsoft SQL Server
MySQL / MariaDB
PostgreSQL
Oracle Database
MongoDB
Enter the database username and password.
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.
Enter the initial database name in Default Database (optional), when required.
Select the required option from SSL Mode.
Enter the database server host name or IP address in Test target host / IP.
Select Test Connection to verify the credentials, connection settings, and target availability.
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:
Select the Database credential category.
Select the DB tab.
Locate the credential profile in the list.
Select the Edit icon under Actions.
Update the required profile details.
Enter or update the password when required.
Enter a database server host name or IP address in Test target host / IP.
Select Test Connection to verify the updated credentials and connection settings.
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:
Select the Database credential category.
Select the DB tab.
Locate the credential profile in the list.
Select the History icon under Actions.
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. |