Add database assets

This page describes how you can collect data from your databases with discovery client. To view your database assets and perform an assessment, you need to enable the StratoZone integration.

You can add your database assets to a Database scan credential with the following methods.

  1. Manual entry: add individual databases through the UI.
  2. CSV upload: upload a pre-formatted CSV file containing your databases.

Requirements

Depending on the database type you want to scan, you need different permissions, as described in the following table.

Database Permissions required
Oracle To configure account permissions, review the permissions required in the permission script and grant them according to your internal policies.

To generate migration assessment results from Oracle to PostgreSQL, discovery client accesses DBA_HIST% views that are licensed separately under the Oracle Diagnostics Pack and DBMS_SQLTUNE/DBMS_SQL_MONITOR packages. Ensure that you have the correct licenses and select the Has AWR License option in discovery client to see the detailed migration assessment results.
MS SQL Server Role needed on target SQL server:
  • SysAdmin

If you use SQL authentication:
  • The username on database credential used to authenticate to SQL server must have SysAdmin role.

If you use Windows Authentication:
  • The username on database credential must have SysAdmin role on SQL server.
  • The username on database credential must have login permission on the local machine where discovery client is installed.
MySQL Account with SELECT privileges.
PostgreSQL Account with SELECT privileges.
MongoDB Use grantRolestoUser to assign the following permissions to the collection user:
  • clusterMonitor
  • readAnyDatabase

Manual entry

If you have a limited number of databases, you can manually add them to your credential from the UI.

To manually add a database to a Database scan credential, follow these steps.

  1. From the top of the screen, click Add assets > Database > Enter connection strings.
  2. Enter the name of the database asset to scan, if different from the default value provided.
    1. For SQL Server databases, you only need to specify one database name per instance to let discovery client scan all databases visible in that instance.
    2. For MySQL and PostgreSQL databases, select if you want to automatically scan other databases in the instance.
  3. Select the OS machine asset where the database is installed from the drop-down menu.
  4. From the Add database connection string section, select the name of the credentials that can authenticate to the database.
  5. Enter the hostname of the machine where the database is installed.
    1. For a cluster, specify any one of the host instances in the cluster. Note that the host instance must be scanned first with OS scan or vCenter scan.
  6. If necessary, edit the default port number that the target database is running on.
  7. Optionally, enter any additional parameters that you want to append to the connection string.
  8. Click Test connection string to verify that discovery client can successfully access your database, then click Add asset.

CSV upload

You can upload your database assets details in bulk by filling in the data in a pre-formatted CSV.

  1. From the top of the screen, click Add assets > Database > Upload CSV of connection strings.
  2. From the drop-down menu, select the credentials that can authenticate to the databases listed in the CSV.
  3. Click Download template to download the pre-formatted CSV template.
  4. Use the template to fill in the details of your assets with a CSV editor.
  5. Upload your CSV file.
  6. Click Save to finish.

What's next