Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
JimPreschlack
Contributor
Contributor
‎2021-02-02 11:28 AM

Best Way to Connect to MongoDB in QLik

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

1,410 Views
0 Likes
1 Solution

Accepted Solutions
sandster
Contributor
Contributor
‎2021-05-11 02:04 AM

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

  1.  through Qlik Sense, you connect to a MongoDB database through the Add data dialog or the Data load editor.
  2. 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.

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

omegle azar shagle

View solution in original post

1,250 Views
0 Likes
3 Replies
Adam_Mayer
Employee
Employee
‎2021-02-04 09:01 AM

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

1,380 Views
0 Likes
sandster
Contributor
Contributor
‎2021-05-11 02:04 AM

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

  1.  through Qlik Sense, you connect to a MongoDB database through the Add data dialog or the Data load editor.
  2. 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.

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

omegle azar shagle
1,251 Views
0 Likes
John_stv
Contributor
Contributor
‎2022-04-13 06:18 AM

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?

930 Views
0 Likes