Forum Discussion

vivien57's avatar
vivien57
Super User
3 months ago

Error - Using the MongoDB Om-Premise Connector

Hello everyone, I'm trying to establish a connection between Fabric and an on-premises MongoDB server. https://learn.microsoft.com/en-us/fabric/data-factory/connector-mongodb-overview ...
General Question
Need Help
Tips and Tricks
vivien57's avatar
vivien57
Super User
3 months ago

Hello ABD128 ,

Thank for your help.

With the suggested connection string, I get this error (which already seems clearer and more specific).



I tried using a single-node setup, but it doesn’t work.

I’d say we’ve made some progress with the new errors, but for the moment I can’t find.

Thank in advance,

Have a nice day,

Vivien

 




ABD128's avatar
ABD128
Resolver II
3 months ago

Hi vivien57 

 

That’s useful feedback, because it confirms the issue is not related to the replica set syntax or multi-node configuration. The newer error also makes it clearer that Fabric is rejecting URI-style options in the Server field itself, so the connector is at least validating the input more specifically now.

 

At this stage, the key points to verify are:

Use only the host:port value in the Server field (no mongodb://, no authSource, no query parameters)

Configure authentication separately in the connection settings/gateway

Explicitly populate the Database field in the Copy activity with a valid MongoDB database name Validate that the MongoDB user has permissions on both the authentication database and the target database.

 

Since the single-node test also fails, this may now point more toward a limitation or compatibility issue between the Fabric MongoDB connector and your MongoDB authentication/topology configuration through the on-premises gateway.

 

Regards,

ABD

  • vivien57's avatar
    vivien57
    Super User
    3 months ago

    Hello ABD128 , v-karpurapud ,

    I have received your messages and thank you for them.

    I haven’t had time to make any progress on this issue, but it remains unresolved for the time being.

    I will keep you informed as soon as possible.

    Thank you again for your help,

    Have a good day,

    Vivien

    • v-karpurapud's avatar
      v-karpurapud
      Community Support
      3 months ago

      Hi vivien57 

      Thanks for the update. Hope your issue gets resolved soon. when it does, please share the insights with the community as it can be helpful to others.

      Regards,

      Microsoft Fabric Community Support Team.

    • vivien57's avatar
      vivien57
      Super User
      2 months ago

      Hello,

      Just to let you know, we still cannot resolve the issue.

      Have a nice day,

      Vivien

      • v-karpurapud's avatar
        v-karpurapud
        Community Support
        2 months ago

        Hi vivien57 

        Thanks for the update. Since the URI format and single-node configuration have already been tested, it would be helpful to know where the failure is occurring now and what the latest error message looks like. Specifically, does the error occur during connection validation, when selecting the database or collection, or only when the Copy activity is executed? That information can help narrow down whether the issue is related to connector validation, authentication, or the MongoDB connector's runtime execution.

        Regards,

        Microsoft Fabric Community Support Team.