topic Re: Use MongoDB connector to connect to an Atlas hosted database in Connectivity & Data Prep

Use MongoDB connector to connect to an Atlas hosted database

Eloy — Tue, 21 Dec 2021 14:37:45 GMT

Hi everyone,

I was able to connect my database using the MongoDB connector when I was hosted in Mlab but we have been obligated to migrate to Atlas.

Since then, I'm not able to connect to my database using the native MongoDB connector of Qlik Sense online and I don't know where I am wrong. There are 5 fields:

-Server: xxxx-xxxx.azure.mongodb.net

-Port: 27017

-Database, username and password have not changed.

Somebody had the same problem or knows how to solve it?

Thanks in advance

Re: Use MongoDB connector to connect to an Atlas hosted database

Sebs030 — Thu, 12 Nov 2020 11:55:11 GMT

I have the same issue when i want to connect from qlik cloud to a mongoDB Atlas cluster. The process described here https://docs.atlas.mongodb.com/tutorial/connect-bic-qlik/ only worked from Qlik Sense Desktop but not Qlik Cloud. I am getting an error: ERROR [HY000] [unixODBC][Qlik][MongoDBODBC] (110) Error from MongoDB Client: No suitable servers found (`serverSelectionTryOnce` set): [Invalid reply from server. calling ismaster on 'xxxx-biconnector.zzzzz.mongodb.net:27015'] (Error Code: 13053).

As said with Qlik Sense Desktop it worked

Re: Use MongoDB connector to connect to an Atlas hosted database

Eloy — Mon, 16 Nov 2020 08:57:50 GMT

Hi, in the latest version of Qlik online i was able to connect to the cluster, have you tried their new connector ? They dont have the srv yet, but it works

Re: Use MongoDB connector to connect to an Atlas hosted database

Sebs030 — Wed, 17 Mar 2021 15:45:38 GMT

@Eloy could you please kindly share how you connected from an MongoDB Atlas cluster to Qlik Sense Cloud using the native MongoDB Connector, i don´t get it working.

Do you use a MongoDB BI Connector ( wich connects on Port 27015 at XXX-biconnector.XXX.mongodb.net or a "normal" connection with port 27017? I always get 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 'XXX-biconnector.XXX.mongodb.net:27015'] (Error Code: 13053)

Thansks a lot

Re: Use MongoDB connector to connect to an Atlas hosted database

Eloy — Fri, 19 Mar 2021 07:53:00 GMT

Hello @Sebs030

This I what I did :

I don't have the MongoDB BI Connector. I use the native connection to MongoDB from Qlik :

I have a replica set with members

dbname-shard-00-0x-serverid.host.mongodb.net:port (example prod-shard-00-00-kljqd.aw3s.mongodb.net:27017)

-> Zone database properties

Server: serverid.host.mongodb.net (kljqd.aw3s.mongodb.net)

Port: port (27017)

Database: dbname (prod)

-> Authentication

Your user and password

-> SSL options

In my case I click on Enable SSL and Allow Self-signed Server Certificate and that's all

-> Replica Set

Replica Set Name: empty, i think it's optional

Secondary Servers: separated by comma, dbname-shard-00-00-serverid.host.mongodb.net:port,dbname-shard-00-01-serverid.host.mongodb.net:port... (prod-shard-00-00-kljqd.aw3s.mongodb.net:27017,prod-shard-00-01-kljqd.aw3s.mongodb.net:27017)

Tell me if you get it to work or not !

Regards

Re: Use MongoDB connector to connect to an Atlas hosted database

Sebs030 — Fri, 19 Mar 2021 08:26:24 GMT

@Eloy great thanks a lot, the "Allow Self-signed Server Certificate" and providing the secondary servers did the job! To find out the exact name of the secondary servers i connected using the mongoshell, because the shards started with 01 instead of 00, but now it works👍

Re: Use MongoDB connector to connect to an Atlas hosted database

Eloy — Fri, 19 Mar 2021 08:40:29 GMT

@Sebs030 can you write here the commands you used in the mongoshell for the people with the same problem in the future? Happy to know it worked

Re: Use MongoDB connector to connect to an Atlas hosted database

Sebs030 — Fri, 19 Mar 2021 09:50:54 GMT

yes, its just the normal mongo command to connect to a DB: "mongo mongodb+srv://serverid.host.mongodb.net/DB_NAME" --username USER_NAME"

The user is then prompted to provide his password and then mongo reveals to which shards the user is connected

Re: Use MongoDB connector to connect to an Atlas hosted database

galaplexus — Wed, 11 Aug 2021 09:57:43 GMT

Enabling SSL and Allowing self-signed Server Certificate makes Qlik crash with the message "Error connecting to the Sense service".

I am running the hosted Qlik Sense Business (not Entreprise) and a shared MongoDB M0 cluster version 4.4. I have tried with serverless cluster version 5.0.2 and I get the same results.

The connection works well with a self hosted mongodb on a VM on Azure.

Can you confirm that we don't need to specify a keyfile or a trusted certificate? Or any other ideas?

Thanks!

Re: Use MongoDB connector to connect to an Atlas hosted database

John_SM — Wed, 13 Apr 2022 10:29:40 GMT

Hello, where can I find in Qlik Sense the options for SSL and Replica Set (or is it available only in QlikView)?

Re: Use MongoDB connector to connect to an Atlas hosted database

PaoloMasiero — Fri, 07 Jun 2024 10:47:38 GMT

Hi, has anyone use Atlas SQL ODBC (https://www.mongodb.com/try/download/odbc-driver) with Qlik Sense Saas via Qlik Data Gateway or Qlik Sense on premise.

We have the error:

ERROR [01000] The driver returned invalid (or failed to return) SQL_DRIVER_ODBC_VER: 03.80

on creating the connection.

Thanks

Paolo Masiero

Re: Use MongoDB connector to connect to an Atlas hosted database

PaoloMasiero — Fri, 07 Jun 2024 10:57:39 GMT

Hi,

I added an ideation https://ideation.qlik.com/app/#/case/400529?currentProductId=9da99bc1-0dfb-4471-8e12-d23685578c43 to have a dedicated Connector for Mongo DB SQL ( https://www.mongodb.com/docs/atlas/data-federation/query/query-with-sql/ ) on Qlik Sense Saas.

Hope this idea could be usefull.

Thanks

Paolo Masiero

Re: Use MongoDB connector to connect to an Atlas hosted database

fabdulazeez — Sun, 14 Sep 2025 11:07:35 GMT

Does anyone know if Qlik Sense officially supports connecting to MongoDB Atlas using the native MongoDB connector in Qlik Sense? I am able to connect via method mentioned in the answer