AWS DMS Neptune target endpoint error
According to the following documentation for creating a target endpoint using AWS DMS https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Target.Neptune.html
The setup looks like as follows: 1. A Neptune DB cluster(without Notebook) 2. A DMS replication instance 3. A source endpoint (S3) 4. A role that has full access to S3, Neptune and RDS 5. A target endpoint (AWS Neptune) <-- This is the point of failure
After configuring the target endpoint when I click on "Run test" I see following error:
arn:aws:iam::12xxxxxx2:role/xxxx-dms-role role should be associated with xxx-cluster-xxx-neptune cluster.
Is there something missing?
The role is configured with policies that provide full access to all resources(especially Neptune and S3)
{
"Version": "2012-10-17",
"Statement": [
{
"Effect": "Allow",
"Action": [
"s3:*"
],
"Resource": "*"
},
{
"Effect": "Allow",
"Action": "neptune-db:*",
"Resource": "*"
},
{
"Effect": "Allow",
"Action": "rds:*",
"Resource": "*"
}
]
}
It is likely that the role needs to be added to the Neptune cluster, such that the cluster can use this role for reading data from the S3 bucket used as intermediate storage for the transformed data. https://docs.aws.amazon.com/neptune/latest/userguide/bulk-load-tutorial-IAM.html#bulk-load-tutorial-IAM-add-role-cluster
If trying out the above suggestion doesn't work, to answer your question, we require details that are non-public information. Please open a support case with AWS using the following link -> https://aws.amazon.com/contact-us/, after which you can select Technical Support. Thanks.
Relevant questions
How to create DMS migration endpoint for redshift serverless.
Accepted Answerasked 2 months agoCan't connect to S3 target endpoint
asked 2 years agoDMS charges for target S3 Bucket PUTs
Accepted Answerasked 2 years agoDMS - Elasticsearch as target - Failed to connect to database.
asked 10 months agoIssue when creating DMS endpoint to connect with MSK using Mutual TLS authentication
asked 5 months agoCreating AWS DMS endpoint for PostgreSQL version 14.0 and 14.1?
asked 2 months agoAWS DMS - Endpoint target Redshift with user provided S3 bucket name
asked 15 days agoAWS DMS Neptune target endpoint error
asked a month agoError using Aurora Postgres version 11.8 as DMS source endpoint
asked 2 years agoValidationSettings are not supported for 's3' endpoint
asked 3 months ago