Use MongoDB connector to connect to an Atlas hosted database

[Eloy]

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

[PaoloMasiero]

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

[PaoloMasiero]

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