topic Re: Connect to MongoDb from Data Pipeline in Microsoft Fabric in Pipelines

Connect to MongoDb from Data Pipeline in Microsoft Fabric

Marusyk — Fri, 14 Jun 2024 13:22:58 GMT

I'm trying to connect to MongoDb and got this error

Failure happened on 'Source' side. ErrorCode=MongoDbUnsupportedUuidType,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=The wrong representation type of UUID in Binary JSON.,Source=Microsoft.DataTransfer.Runtime.MongoDbV2Connector,''Type=System.FormatException,Message=The GuidRepresentation for the reader is CSharpLegacy, which requires the binary sub type to be UuidLegacy, not UuidStandard.,Source=MongoDB.Bson,'

Here I found that to fix it, I need to add the uuidRepresentation=standard option in the MongoDB connection string.

But how to do that in Microsoft Fabric if there is no place where put extra options?

Please advice

Re: Connect to MongoDb from Data Pipeline in Microsoft Fabric

Anonymous — Fri, 14 Jun 2024 17:49:22 GMT

Hi Marusyk
Thanks for using Fabric Community.
At this time, we are reaching out to the internal team to get some help on this. We will update you once we hear back from them.
Thanks

Re: Connect to MongoDb from Data Pipeline in Microsoft Fabric

Marusyk — Tue, 18 Jun 2024 09:39:58 GMT

It is critical one, so here is the support ticket TrackingID#2406140050003006

Re: Connect to MongoDb from Data Pipeline in Microsoft Fabric

Marusyk — Tue, 13 Aug 2024 12:17:45 GMT

The support ticket remains unresolved, and it has been more than 2 months.

However, I've discovered an interesting case: the error occurs specifically in the Germany West Central region. When I provision the capacity in the West Europe region, for example, everything works fine.

The problem is that all my production workloads are in the Germany West Central region, so I need to use that region for various reasons