Discovering databases for migration using data collectors - Amazon Database Migration Service
Permissions
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

Discovering databases for migration using data collectors

To discover your source data infrastructure, you can use Amazon DMS data collectors. A data collector is a Windows application that you install in your local environment. This application connects to your data environment and collects metadata and performance metrics from your on-premises database and analytic servers. Then DMS Fleet Advisor uses your data collector to build an inventory of servers, databases, and schemas that you can migrate to the Amazon Web Services Cloud.

Amazon DMS has the maximum number of data collectors that you can create for your Amazon Web Services account. See the following section for information about Amazon DMS service quotas Quotas for Amazon Database Migration Service.

You can run the DMS data collector in Windows. However, your DMS data collector can collect data from all supported database vendors regardless of the OS server where they run.

The DMS data collector uses a protected RTPS protocol with TLS encryption to establish a secure connection with DMS Fleet Advisor. Therefore, your data is encrypted during transit by default.

Topics

Permissions for a DMS data collector

The database users that you create for the DMS data collector should have read permissions. However, in some cases, the database user requires the EXECUTE permission. For more information, see Creating database users for Amazon DMS Fleet Advisor.

The DMS data collector requires additional permissions to run the discovery scripts.

  • For OS discovery, the DMS data collector needs credentials for the domain server to run requests using the LDAP protocol.

  • For database discovery in Linux, the DMS data collector needs credentials with sudo SSH grants. Also, you should configure your Linux servers to allow running remote SSH scripts.

  • For database discovery in Windows, the DMS data collector needs credentials with grants to run Windows Management Instrumentation (WMI) and WMI Query Language (WQL) queries and read the registry. Also, you should configure your Windows servers to allow running remote WMI, WQL, and PowerShell scripts.