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

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

    • BlindEye9's avatar
      BlindEye9
      Regular Visitor
      2 years ago

      {"server":"<cosmosMongoAccountName>.mongo.cosmos.azure.com:<PortNumber>"}

      The <PortNumber> will be in the Connection Strings tab of your CosmosDB workspace on Azure.

      Mine was 10255, as you can see below.


       



      • Marusyk's avatar
        Marusyk
        Icon for Advocate II rankAdvocate II
        2 years ago

        works. thank you very much