Azure Data Factory, Mongo DB Connectionstring has special character

Question

I have to connect MongoDB in azure data factory, the password of the mongoDB has '@' sign in it, which seems to be causing some issue. is there any way to escape that character?

the connection string is some thing look alike given below,

mongodb://username:p@ssword@abc.company.com:1800/db_name

Answer 1

Actually,

I got the answer,

I have to use '%40' instead of '@'

so the connectionstring will go like this

mongodb://username:p%40ssword@abc.company.com:1800/db_name

Answer 2

Please reference this tutorial: Copy data from MongoDB using Azure Data Factory.

The MongoDB connection string format is look like this:

mongodb://[username:password@]host[:port][/[database][?options]]

Hope this helps.