Wondering how to use Amazon Redshift as the target endpoint for AWS DMS task? We can help you.

At Bobcares we assist our customers with several AWS queries as part of our AWS Support Services for AWS users, and online service providers.

Today, let us see how our Support Techs assist with this Redshift query.

How to use Amazon Redshift as the target endpoint for AWS DMS task?

When you migrate to Amazon Redshift, AWS DMS first moves the data to an Amazon Simple Storage Service (Amazon S3) bucket.

Then, the data is transferred to the tables in the target Amazon Redshift cluster.

This S3 bucket is created in the same AWS Region as Amazon Redshift database.

For this, your Amazon Redshift cluster got to have the same account and same AWS Region as the replication instance.

Before we start, make sure to provide the security group, subnet CIDR range, or IP address of the replication instance in the inbound rules of the Amazon Redshift cluster security group.

The AWS DMS replication instance must have network connectivity to the Amazon Redshift endpoint (hostname and port) that the cluster uses.

Also, confirm that AWS DMS has permissions to create the S3 bucket.

AWS DMS uses Amazon S3 as the medium to transfer the data into an Amazon Redshift cluster.

This means that AWS DMS requires the dms-access-for-endpoint AWS Identity and Access Management (IAM) role.

Today, let us go through the steps followed by our Support Techs:

1. Firstly, open the AWS DMS console, and choose the AWS Region that your Amazon Redshift cluster is in.
2. Then, choose Endpoints from the navigation pane.
3. Next, choose Create endpoint.
4. From Endpoint type, choose Target endpoint.
5. Then, enter your Endpoint identifier, and choose Redshift as your Target engine.
6. Enter your Amazon Redshift endpoint for the Server name.
7. Enter your Port number.
   Please note the default port for Amazon Redshift is 5439.
8. Enter your Amazon Redshift User name, Password, and Database name.
9. Optionally, you can add extra connection attributes from the Endpoint-specific settings.
10. From the Test endpoint connection section, choose the VPC that the replication instance is in and choose the Replication instance.
11. Choose Run test, and wait for the status to be successful.
12. Finally, choose Create endpoint.

If you use the AWS DMS console to create the endpoint, then DMS creates the required IAM roles and policies automatically.

If you use the AWS Command Line Interface (AWS CLI) or the AWS DMS API, you must create the IAM roles and policies manually.

[Need help with the process? We’d be happy to assist]

Conclusion

In short, today we saw steps followed by our  Support Techs to use Amazon Redshift as the target endpoint for AWS DMS task