Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
There are two methods through which you can easily connect MongoDB in QLik
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.
Read More - https://help.qlik.com/en-US/connectors/Subsystems/ODBC_connector_help/Content/Connectors_ODBC/Mongo/...
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
There are two methods through which you can easily connect MongoDB in QLik
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.
Read More - https://help.qlik.com/en-US/connectors/Subsystems/ODBC_connector_help/Content/Connectors_ODBC/Mongo/...
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?