Can anyone help with the AWS DMS target endpoint setup for OpenSearch, we are trying CDC option from a database into OpenSearch

sundarkannan September 11, 2023, 12:45pm 1

Versions (relevant - OpenSearch/Dashboard/Server OS/Browser):
OpenSearch 2.7

Describe the issue:
AWS DMS target endpoint unable to assume AWS role and connect to OpenSearch domain

Configuration:
We did the AWS role mapping for the OpenSearch local user with proper cluster and index permissions.
AWS roles, and policies are created as well.

Relevant Logs or Screenshots:
The IAM Role arn:aws:iam::xxxx:role/custom-opensearch-role1 is not configured properly.AccessDenied

Eugene7 September 11, 2023, 4:57pm 2

Hi @sundarkannan

How have you deployed OpenSearch?

Have you used the Amazon OpenSearch Service, or have you deployed OpenSearch using one of the following methods:
Installing OpenSearch - OpenSearch documentation ?

sundarkannan September 11, 2023, 5:09pm 3

Hi Thanks for the response.
Yes I have working OpenSearch and I am able to connect from AWS DMS Target endpoint with OpenSearch now. The resolution was to use non master internal user.