i try to add Cosmos DB Linked service in Azure Data Factory to copy documents from NoSQL API database to MongoDB API (vCore) database.
In ADF we have default connectors to Cosmos DB NoSQL API but not for MongoDB vCore option. Thats why i decided to go with MongoDB connector.
But when i copy connection string from my CosmosDB and fill gaps:
mongodb+srv://<user>:<password>@XYZ-cluster.mongocluster.cosmos.azure.com/?tls=true&authMechanism=SCRAM-SHA-256&retrywrites=false&maxIdleTimeMS=120000
It does not work with ADF connector:
The same connection string works in Azure Data Studio:
The question is, how to prepare connection string to MongoDB placed in vCore CosmosDB option?
DB and collection is empty