Wondering how to use an Amazon S3 bucket as an AWS DMS target? We can help you!

Here at Bobcares, we often receive similar requests from our AWS customers as a part of our AWS Support Services.

Today let see the steps followed by our Support Techs to use an S3 bucket as the target endpoint.

Amazon S3 bucket as AWS DMS target

AWS DMS uses Database Migration Task to migrate the data from the source to the target destination.

We can use an S3 bucket as an AWS DMS target endpoint.

Steps to use an S3 bucket as a target

1. Creating an Amazon S3 bucket

1. Login to AWS Management Console and then open the S3 console.

2. Then create an S3 bucket by specifying the name.

3. After creating the bucket, select the bucket.

4. Select Create folder.

5. Then enter the folder name and click on the save option.

2. Creating an IAM policy

1. To create an IAM policy, firstly open the IAM console.

2. Then select Policies from the left side in the IAM console.

3. Select Create policy, and then select JSON.

4. Then add an IAM policy similar to the following example:

{
"Version": "2012-10-17",
"Statement": [
{
"Effect": "Allow",
"Action": [
"s3:PutObject",
"s3:DeleteObject"
],
"Resource": [
"arn:aws:s3:::nameofbucket*"
]
},
{
"Effect": "Allow",
"Action": [
"s3:ListBucket"
],
"Resource": [
"arn:aws:s3:::nameofbucket*"
]
}
]
}

Replace the ‘nameofbucket’ with the correct bucket name.

5. After updating the policy, then choose Review policy and enter a Name and Description.

6. Then select Create policy.

3. Creating an IAM role

1. From the IAM console, select Roles.Then select Create role >> DMS >> Next: Permissions.

2. Then, search for the newly created policy name and select it, then select Next: tags.

3. Select Next: Review.

4. Then enter the Role name and the description.

5. Click on Create Role.

6. Copy the Role ARN.

4. Creating the target Endpoint

1. Log in to the AWS console and then open AWS DMS console.

2. Then select Endpoints option under Resourse management.

3. Select Create endpoint, and then select Target endpoint.

4. Then eneter the Endpoint identifier.

5. And then choose S3 as the Target engine.

6. Paste the Role ARN in the field of Service Access Role ARN.

7. Then provide the Bucket name and the Bucket folder.

8. We can add our extra connection attributes under the Endpoint-specific settings.

9. To test endpoint connection, select VPC and Replication instance and then select Run test under the section Test endpoint connection. This is also optional.

10. Finally select Create endpoint.

[Need assistance with more AWS queries? We can help you]

Conclusion

To conclude, today we saw the steps followed by our Support Techs to use an Amazon S3 bucket as an AWS DMS target endpoint.