topic Re: Best Way to Connect to MongoDB in QLik in Connectivity & Data Prep

Best Way to Connect to MongoDB in QLik

JimPreschlack — Thu, 23 Dec 2021 12:52:00 GMT

Hi Everyone,

We just spun up a trial account with Qlik and connected to our MongoDB and it displays the collections in Mongo as "tables" in Qlik, but it also adds additional tables for collections that have objects in them, which is odd.

For example, we have a collection called ballotHistory, but it also shows tables for ballotHistory_castBallots, ballotHistory_earlyBallots, ballotHistory_primaryBallots when those are not actual collections, they are just subparts of the main ballotHistory collection. It's almost like they are taking the top-level Mongo objects and breaking them up into some type of joined SQL structure, which kind of defeats the purpose.

Is there a better way to connect to Mongo? Thank you, Jim

Re: Best Way to Connect to MongoDB in QLik

Adam_Mayer — Thu, 04 Feb 2021 14:01:19 GMT

Hi @JimPreschlack

Thank you for posting your question, I am not sure if this is the correct forum for your issue though.

Please can you clarify if you are asking about MongoDB connection into Qlik Sense?

This would be the correct forum if your issue relates to a Qlik Replicate Task for MongoDB managed in Qlik Enterprise Manager.

Many Thanks

Kind Regards

Adam

Re: Best Way to Connect to MongoDB in QLik

sandster — Tue, 11 May 2021 06:04:29 GMT

There are two methods through which you can easily connect MongoDB in QLik

through Qlik Sense, you connect to a MongoDB database through the Add data dialog or the Data load editor.
And, QlikView you connect to a MongoDB database through the Edit Script dialog.

You will need to know the server and database name that you want to connect to, and you must have access credentials. Once you have created a connection to a MongoDB database, you can select data from the available tables and then load that data into your app or document.

Re: Best Way to Connect to MongoDB in QLik

John_stv — Wed, 13 Apr 2022 10:18:38 GMT

Don't worry, you wont be able to connect to the MongoDB because Qlik doesn't upgrade its product in years it seems. How do you connect if you are using a higher version of MongoDB 4.2?