Connection String to Mongodb

[fabdulazeez]

Our database team provided the following connection string for connecting to the MongoDB database

mongodb://dbhost:27017/Dbase?maxPoolSize=50&appName=app1;

While I am able to establish a connection to the database from Qlik Sense by providing the server details, I am unable to include the appName connection option. They mentioned that this parameter is used to track queries in logs. Is there a way to specify this parameter from Qlik Sense?

[Sebastian_Linser]

Hello,

have you tried to include the appName like that?

If you are using the On Prem Version of Qlik Sense you might be able to setup a ODBC driver which supports that link directly, appName was listed as a parameter here https://www.mongodb.com/docs/manual/reference/connection-string/

best regards

Sebastian

[fabdulazeez]

Yes, I tried the advanced option, but it did not reflect in the query. Could you provide details on the ODBC driver you mentioned? If you are referring to the MongoDB BI Connector ODBC Driver, my understanding is that it can only be used with MongoDB Enterprise in a production environment. If there are any other stable, free ODBC drivers available, please let me know.