Test Endpoint failed: Application-Status: 1020912, Application-Message: Network error has occurred” - Amazon Redshift as the target endpoint for AWS DMS

Of course this is a network issue but couldn’t figurable easily. I had to spent quite a good amount of time to find the issue while setting up the Redshift as a Target endpoint in AWS DMS.  

As per below docs, in #6 they mentioned- “6. Enter your Amazon Redshift endpoint for the Server name”  - https://aws.amazon.com/premiumsupport/knowledge-center/dms-redshift-target-endpoint/

Actually it won’t work (and you will get above error message) if you just copy and paste the whole Redshift cluster endpoint from Redshift Cluster general information page.  Normally Redshift cluster endpoint consist of cluster identifier + Region Identifier for cluster + database name + port.

So, the solution is for this error, you need to remove the database name and port number from the actual Redshift cluster endpoint and use this(rest of parts) in the “Server name:” field on AWS DMS endpoint creation page.

 

Hope this will save your valuable time and efforts!