topic Re: Connect Qlik Sense to MongoDB Atlas in Connectivity & Data Prep

Connect Qlik Sense to MongoDB Atlas

panchuparayil — Wed, 22 Dec 2021 15:42:49 GMT

Trying to connect Qlik Sense cloud to MongoDB Atlas DB 4.2 and running out of options.

Getting the following error:

ERROR [HY000] [Qlik][MongoDBODBC] (110) Error from MongoDB Client: No suitable servers found (`serverSelectionTryOnce` set): [Invalid reply from server. calling ismaster on 'xxxx-biconnector.xxx.mongodb.net:27015'] (Error Code: 13053)

I have whitelisted the US IPs in Atlas https://community.qlik.com/t5/Knowledge-Base/Qlik-Sense-SaaS-editions-IP-addresses-and-DNS-names/ta-p/1716745

I have tried using username/password with the MongoDB Atlas credentials. Also tried with the BI connector specific credentials which you get after enabling BI feature on the cluster.

No joy. Is this supposed to work, are there any documentation around this?

Help

Re: Connect Qlik Sense to MongoDB Atlas

gourav4938 — Wed, 13 Jul 2022 06:50:51 GMT

Any update on the above error?

Re: Connect Qlik Sense to MongoDB Atlas

Vinay_B — Wed, 13 Jul 2022 20:05:09 GMT

Hi @panchuparayil and @gourav4938,

Mongo DB 4.2 is a supported version and below is the documentation:

https://help.qlik.com/en-US/cloud-services/Subsystems/ODBC_Connector_help/Content/Connectors_ODBC/Mongo/Mongo-connector.htm

Also, please check the below post to see if that helps: https://community.qlik.com/t5/Connectivity-Data-Prep/Use-MongoDB-connector-to-connect-to-an-Atlas-hosted-database/td-p/1705292