Trouble connection string in mongosqld config files when setting up BI connector

I have a standard connection string that works fine on compass but does not work in the mongosql config file, as it keep producing “–mongo-uri may not contain any authentication information”.

My connection string looks like this mongodb://myusername:mypassword@:27017/?authMechanism=SCRAM-SHA-256&authSource=myusername.
I have tried authsource=admin as well, still does not work.

Am I missing some specific configurations?

If using a configuration file check the example:
https://mongodb.prakticum-team.ru/docs/bi-connector/current/reference/mongosqld/#mongodb-host-options

The auth: section is where that information is added.

If using command line options:
--mongo-username <username>, -u <username>
--mongo-password <password>, -p <password>
--mongo-authenticationSource <auth-db-name>
--mongo-authenticationMechanism <authMechanism>

Still does not work, is the BI connector working for MongoDB 4.4.27 Community? Do I need to upgrade for the enterprise version?

Yes it an enterprise tool that required MongoDB Enterprise and a subscription agreement.

Some limited use is available without an subscription agreement.

This topic was automatically closed 5 days after the last reply. New replies are no longer allowed.