--- title: "Database" slug: "database" status: "new" updated: 2026-11-17T17:19:58Z published: 2026-11-17T17:19:58Z canonical: "help.symphonysummitai.com/database" --- > ## Documentation Index > Fetch the complete documentation index at: https://help.symphonysummitai.com/llms.txt > Use this file to discover all available pages before exploring further. # Database 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](https://cdn.document360.io/62351b42-cfbd-43ad-8ce1-82b8f455337f/Images/Documentation/database-image-p81dwexo.png?sv=2026-02-06&spr=https&st=2026-11-20T22%3A03%3A53Z&se=2026-11-20T23%3A03%3A53Z&sr=b&sp=r&sig=aK2VqHKAYVNjfrKtEToGtyJOEO2BCDB2wYpSbn%2F7w5s%3D) 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](/apex/docs/database#default-database-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](/apex/docs/database#ssl-modes). | | 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] > 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. | > [!NOTE] > 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. - [List page](/apex/docs/database#credential-profile-list) - [Active/Inactive Credential](/apex/docs/database#activate-or-deactivate-a-database-credential-profile) - [Edit Database Credential](/apex/docs/database#edit-a-database-credential-profile) - [Change History](/apex/docs/database#change-history-fields) #### 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. |