Step 6: Configure Data Providers - Database Migration Guide

Step 6: Configure Data Providers

In this step, you create data providers that describe your source and target databases. A data provider stores a data store type and the location information about your database. Data providers don’t include database credentials. You store database credentials in AWS Secrets Manager. Make sure that you include data providers and database secrets in your migration project.

You can create only one data provider for a single database. If you try to create a second data provider for the same database, AWS DMS displays an error message. However, you can use one data provider in multiple migration projects.

To create a data provider for your source database

  1. Sign in to the AWS Management Console and open the AWS DMS console at https://console.aws.amazon.com/dms/v2/.

  2. Choose your AWS Region.

  3. In the navigation pane, choose Data providers, and then choose Create data provider.

  4. For Configuration, choose Enter manually.

  5. For Name, enter a unique name for your source data provider. For example, enter dm-postgresql-source-provider.

  6. For Engine type, choose PostgreSQL.

  7. For Server name, enter the Domain Name Service (DNS) name or IP address of your database server.

  8. For Port, enter the port used to connect to your database server.

  9. For Database name, enter the name of your source database.

  10. For Secure Socket Layer (SSL) mode, choose none. Optionally, choose the type of your SSL enforcement, and provide the certificate information.

  11. Choose Create data provider.

To create a data provider for your Amazon RDS for PostgreSQL database

  1. Sign in to the AWS Management Console and open the AWS DMS console at https://console.aws.amazon.com/dms/v2/.

  2. Choose your AWS Region.

  3. In the navigation pane, choose Data providers, and then choose Create data provider.

  4. For Configuration, choose RDS database instance.

  5. For Database from RDS, choose the Amazon RDS for PostgreSQL database that you created in Step 3.

  6. For Name, enter a unique name for your target data provider. For example, enter dm-postgresql-target-provider.

  7. Choose Create data provider.

Use these data providers when you create your migration project in Step 7.