Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Creator
Creator

Connect Qlik Sense cloud to MongoDB Atlas BI connector

Hi everyone.

Is it possible to connect Qlik Sense Cloud to MongoDB hosted at Atlas with the BI Connector, running version 4.2?

When I add the hostname, port and user/password to Qlik Sense Cloud I always get this error:

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

 

I tried adding different databases, none, admin etc - but no matter what I get the above error.

I'm currently trying to make this work with a trial of Qlik Sense Cloud business.

Would be awesome to solve this issue,  because we are in need of some good BI 😅

3 Replies
Digital Support
Digital Support

@alexbjorlig it looks like the issue might be the DB version, as you mentioned 4.2, but the Help says 4.0 is the top supported version at the moment, so my hunch would be that might be the underlying issue on this one:

https://help.qlik.com/en-US/connectors/Subsystems/ODBC_connector_help/Content/Connectors_ODBC/Mongo/...

Look through the Help though, there might be some info that you might be able to try to see if you can get things working.

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
Creator
Creator

Yeah, you are correct about 4.2. It's a shame since MongoDB 4.2 was released August 2019 - not exactly yesterday 😕

 

Looking through the Help did not help 😢

Contributor
Contributor

We have the same issue. We will have to use Qlik Sense Desktop (configured ODBC connector) to reload the data from MongoDB. This seems to work but causes lot of pain.