conect MongoDB to DWH on Azure

Reut Cohen 6 Reputation points
2023-01-05T12:39:27.227+00:00

I'm trying to connect MongoDB to my DWH in the Azure

I'm using this MongoDB on Azure and inserting my string connection from the MongoDB compass
276407-image.png

I'm also using integration runtime
but once I'm testing the connection I'm getting this error message :

Failed to operate data via MongoDB client.
Unable to authenticate using sasl protocol mechanism SCRAM-SHA-1.
Command saslContinue failed: Authentication failed..

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,623 questions
{count} votes

1 answer

Sort by: Most helpful
  1. HimanshuSinha-msft 19,486 Reputation points Microsoft Employee Moderator
    2023-01-05T21:52:25.277+00:00

    Hello @Reut Cohen ,
    Thanks for the question and using MS Q&A platform.
    As we understand the ask here is how to connect to MongoDB from ADF , please do let us know if its not accurate.
    I just troed out and it worked fine for me . Since the MongDB is in Azure , make sure that Integration Runtime is selected as "AutoResolveIntegrationRuntime"

    276659-image.png

    Please do let me if you have any queries.
    Thanks
    Himanshu


    • Please don't forget to click on 130616-image.png or upvote 130671-image.png button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
    • Want a reminder to come back and check responses? Here is how to subscribe to a notification
      • If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators
    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.