Forum Discussion

NickA01's avatar
NickA01
Icon for Resolver III rankResolver III
2 years ago
Solved

Fabric Data Engineering Cosmos Mongo DB source

Hi All:  I've started work on a project where the data is in a Cosmos Mongo DB ( RU) account.   I've managed to get connectivity working in synapse but I'd very much like to use Fabric Data pipel...
pipelines
Tips and Tricks
  • NickA01's avatar
    NickA01
    2 years ago

    I've just done this however, I had to put it under Synapse as FAbric is not an option. 

     

NickA01's avatar
NickA01
Icon for Resolver III rankResolver III
2 years ago

Anonymous Thanks but that dosen't answer my question. 
The fabric Cosmos connector is for the No-SQL version of Cosmos, not the Mongo version and the native mongo connectors will not connect to a Cosmos Mongo Analytics Store. 

I have managed to hack this but properly supported connection (in the same manner as Synapse)  would be more benificial. 
Here the start of my M query 
Blank Query 
let
Source = DocumentDB.Contents("https://<cosmosMongoAccountName>.documents.azure.com:443/", "<cosmosMongo DB Name>", "<collection name>"),
#"Expanded Document" = Table.ExpandRecordColumn(Source, "Document",<list out the fileds here> 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi NickA01 
    Currently Mongo DB connectors are not yet available in Fabric.

    Appreciate if you could share the feedback on our feedback channel, which would be open for the user community to upvote & comment on. This allows our product teams to effectively prioritize your request against our existing feature backlog and gives insight into the potential impact of implementing the suggested feature.

    Feedback Link:  https://ideas.fabric.microsoft.com/


    I hope this information is helpful. Please let me know if you have any other questions.

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi NickA01 
      We haven’t heard from you on the last response and was just checking back to see if you got a chance to create the idea. Otherwise, will respond back with the more details and we will try to help.
      Thanks

      • NickA01's avatar
        NickA01
        Icon for Resolver III rankResolver III
        2 years ago

        I've just done this however, I had to put it under Synapse as FAbric is not an option. 

         

  • BlindEye9's avatar
    BlindEye9
    Regular Visitor
    2 years ago

    I am having the same issue where I was able to use the MongoDB API in Data Factory and Synapse but it was not available in Fabric. Could you please post the instructions on what your hack was, or possibly make a video on it? It would be a great help

    • NickA01's avatar
      NickA01
      Icon for Resolver III rankResolver III
      2 years ago

      Hi .

      Its already in the above post.

      New DataFlow Gen2
      Blank Query
      Start with this...


      let
      Source = DocumentDB.Contents("https://<cosmosMongoAccountName>.documents.azure.com:443/", "<cosmosMongo DB Name>", "<collection name>"),
      #"Expanded Document" = Table.ExpandRecordColumn(Source, "Document",<list out the fileds here> 

      • BlindEye9's avatar
        BlindEye9
        Regular Visitor
        2 years ago

        Thanks NickA01 . Yesterday, I was playing around with this a bit and it turns out you can use the MongoDB default connector as well in Fabric, in place of the Azure CosmosDB for MongoDB connector that I have been using in Synapse and Data Factory, like you have