Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

Load data from MongoDB

Hi All,

What is right way to load data from MongoDB?

Currently mi Stack is:

MongoDB - QVSource (MongoDB Connector V2) - Qlik Sense Desktop


What im doing right now,

In Qlik Sense,

  1. Created a new App 'Test'
  2. Added a Web File with URL from QVSource 'mongo'.
  3. Written Load script in Qlik Sense from above created web file as this
    1. LOAD
      1. linking_id as Name,
      2. "timestamp" as "Time",
      3. value as Value
    2. FROM [lib://mongo]
    3. (qvx);

Sometimes it doesn't load thought it loads by url in browser.

Thanks in Advance.

Tags (2)
13 Replies
sagarkharpude
Contributor III

Re: Load data from MongoDB

Hi Prasad,

Do you have any information on how to load this data.

I am also facing the same issue.

Thanks

Sagar

vlad_komarov
Valued Contributor II

Re: Load data from MongoDB

As far as I know the QVSource components are no longer supported. Qlik has purchased these components last year and have integrated them into QlikConnectors package.

You might need to check your license....

VK

MVP
MVP

Re: Load data from MongoDB

You have at least these three options:

  1. Use the Qlik Web Connector for MongoDB (premium) - it has a yearly license cost
    Qlik MongoDB Connector ‒ Qlik Connectors
  2. Use the MongoDB BI Connector which lets you connect with an ODBC-driver as part of the MongoDB Enterprise Advanced subscription:
    https://www.mongodb.com/download-center?jmp=nav#bi-connector
  3. Open Source Apache Drill, you can install as a Drill-bit and use the MongoDB-plugin for Drill:
    MongoDB Plugin for Apache Drill - Apache Drill
sagarkharpude
Contributor III

Re: Load data from MongoDB

Hi Petter,

I am using MongoDB connector. But it's not working. I have done the connection using MongoDB and download the data to XML. But XML is throwing an error.

Thanks

MVP
MVP

Re: Load data from MongoDB

So how does the error message look like? Could you explain or share a screenshot? Is it version 1 or version 2 of the MongoDB BI Connector you are using?

sagarkharpude
Contributor III

Re: Load data from MongoDB

Hi Petter,

Thanks for the reply. I am using version 3.2 of MongoDB connector.

I have exported the data to XML. And used this xml data in Qlikview. But it's giving attached error message. I tried qvx file as well.

Capture.JPG

Thanks

MVP
MVP

Re: Load data from MongoDB

MongoDB (the company) has not released any 3.2 version of the "MongoDB BI Connector". Could you inform us on which vendors MongoDB-connector you are using? How did you export your result to XML?

I would advise you to use the newest MongoDB BI Connector version 2.02 for Windows x64 that is available from MongoDB's homepage under the download area as you see below. This is a validated driver that would work well with the latest versions of MongoDB databases.

2017-02-23 09_26_52-MongoDB Download Center _ MongoDB.png

sagarkharpude
Contributor III

Re: Load data from MongoDB

Hi Petter,

Sorry 3.2 is the version of MongoDB. We are using MongoDB web connector. We have selected collection then clicked on Parameter button. Then we have provided details like host, database name, user id and password.  Then we ran the report and in the right side window we have selected the download to XML.

Thanks

MVP
MVP

Re: Load data from MongoDB

Would you be able to share the XML-file?

It seems to me that you are perfectly able to connect to MongoDB with the Qlik Web Connector right? And you download the result as a file to the filesystem. Then you try to read the resulting XML-file from the filesystem and you get the error message you gave us a screenshot of - right?