This page describes how you can collect data from your databases with StratoProbe.
You can add your database assets to a Database scan credential with the following methods.
- Manual entry: add individual databases through the UI.
- 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, StratoProbe 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 StratoProbe to see the detailed
migration assessment results.
|
MS SQL Server | Role needed on target SQL server:
If you use SQL authentication:
If you use Windows Authentication:
|
MySQL | Account with SELECT privileges. |
PostgreSQL | Account with SELECT privileges. |
MongoDB | Use grantRolestoUser to assign the following
permissions to the collection user:
|
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.
- From the top of the screen, click Add assets > Database > Enter connection strings.
- Enter the name of the database asset to scan, if different from the
default value provided.
- For SQL Server databases, you only need to specify one database name per instance and StratoProbe will scan all databases visible in that instance.
- For MySQL and PostgreSQL databases, select if you want to automatically scan other databases in the instance.
- For MongoDB, specify the database name associated with the user's credentials.
- Select the OS machine asset where the database is installed from the dropdown menu.
- From the Add database connection string section, select the name of the credentials that can authenticate to the database.
- Enter the hostname of the machine where the database is installed.
- 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.
- If necessary, edit the default port number that the target database is running on.
- Optionally, enter any additional parameters desired to be appended to the connection string.
- Click Test connection string to verify that StratoProbe 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.
- From the top of the screen, click Add assets > Database > Upload CSV of connection strings.
- From the dropdown menu, select the credentials that can authenticate to the databases listed in the CSV.
- Click Download template to download the pre-formatted CSV template.
- Use the template to fill in the details of your assets with a CSV editor.
- Upload your CSV file.
- Click Save to finish.
What's next
- Learn how to automatically find and scan machine assets.
- Learn how to manually add machine assets.