Database Migration Service - Atlas MongoDB

Rafael Carinha 0 Reputation points
2023-07-23T00:05:26.5966667+00:00

Hi,

I cannot use Atlas MongoDB as a source for a database migration.

The connection fails with the following message:

{ "resourceId":"/subscriptions/resourceeId/resourceGroups/cosmos-resource-group/providers/Microsoft.DataMigration/services/dms-mongo-to-cosmos-v2", "errorType":"Failed to connect, please check error details", "errorDetail":"The connection failed.Only 'authSource' and 'replicaSet' are allowed in a TXT record." }

The same issue happens if i try to connect via Azure Data Factory.

Thanks

Azure Database Migration service
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,026 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Vinodh247 12,741 Reputation points
    2023-07-23T04:56:41.97+00:00

    Hi Rafael Carinha,

    Thanks for reaching out to Microsoft Q&A.

    This error is from MongoDB, not from ADF or Azure DMS. There is a previously solved answer including one from MongoDB community forum which can help you resolve this.

    https://www.mongodb.com/community/forums/t/atlas-serverless-and-dns-txt-record/117967/9

    https://stackoverflow.com/questions/68608923/atlas-mongodb-serverless-and-aws-lambda-connection-issue

    Please Upvote and Accept as answer if the reply was helpful, this will be benefitting the other community members who go through the same issue.

  2. ShaktiSingh-MSFT 14,281 Reputation points Microsoft Employee
    2023-07-24T04:20:40.23+00:00

    Hi Rafael Carinha •,

    Welcome to Microsoft Q&A forum and thanks for using Azure Services.

    As I understand, you are getting error when connecting to Atlas MongoDB with error "The connection failed.Only 'authSource' and 'replicaSet' are allowed in a TXT record".

    Please refer to https://video2.skills-academy.com/en-us/azure/data-factory/connector-mongodb-atlas?tabs=data-factory and Specify the driver version to 2.19.0 which supports MongoDB version 3.6 and higher. For more information, go to this article.

    If you have already referred to the below articles and could not get solution, I would request you to let us know so that we could for other options to unblock you:

    https://www.mongodb.com/community/forums/t/atlas-serverless-and-dns-txt-record/117967

    https://intellij-support.jetbrains.com/hc/en-us/community/posts/4831340877202-Can-t-connect-to-MongoDB-atlas-serverless-instance

    https://stackoverflow.com/questions/68608923/atlas-mongodb-serverless-and-aws-lambda-connection-issue

    Awaiting your reply. Thanks