AWS Glue Connector will not connect to mongoDB Atlas

0

I get the error "InvalidInputException: Unable to resolve any valid connection" when I test my AWS Glue connection to my mongDB Atlas database.

I can connect with an identical string, user and password from a different client. Strangely, I can also run a glue job that connects with the same connection details in a python script.

asked 7 months ago292 views
1 Answer
1

Hi Laurence

follow the below solution step by step to resolve your issue.

  • Check Connection Details: Ensure that the connection details in your AWS Glue connection configuration are accurate and match the connection string used successfully from a different client. Pay close attention to any typos, extra spaces, or incorrect characters in the connection string, username, password, or other parameters.
  • Network Configuration: Verify that the network configuration of your AWS Glue environment allows outbound connections to MongoDB Atlas. This includes checking security groups, network ACLs (Access Control Lists), and any other networking settings that might be blocking or restricting outbound connections.
  • Security Settings in MongoDB Atlas: Double-check the security settings in MongoDB Atlas to ensure that the IP address or range associated with your AWS Glue environment is whitelisted and allowed to connect to the MongoDB cluster. Also, confirm that the user credentials used in the connection configuration have the necessary permissions to access the database.
  • Test Connection from AWS Glue Console: Try testing the connection directly from the AWS Glue console to see if you encounter the same error. This can help isolate whether the issue is specific to the Glue job or if it's related to the connection configuration itself.
  • Review Glue Job Configuration: If you're able to run a Glue job successfully using the same connection details in a Python script, review the configuration of the Glue job to ensure that it's consistent with the connection configuration used in the test.
EXPERT
answered 7 months ago
profile picture
EXPERT
reviewed 5 months ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions