Qlik Community

QlikView Documents

Documents for QlikView related information.

QlikView App: MongoDB Prototype

MVP & Luminary
MVP & Luminary

QlikView App: MongoDB Prototype

This new demo shows how MongoDB can be queried from within QlikView via REST interface. In MondoDB v1.3.4+ this interface is disabled by default. You have to use --rest on the MongoDB command line to enable.

We have built a _get_JSON_data function which handles JSON data to persist into a XML file. The XML file can be loaded then into QlikView the regular way.

In the this QlikView MongoDB example you can configure variable parameters:

  • MongoDB Host
  • Database
  • Collection
  • Limit Rows
  • Filter (Where)

You can see the usage of these parameters in the load script.

The whole thing is a two-step approach (see the QlikView script):

  • Step 1: call _get_JSON_data(..) with the right params to get the JSON data and store into a XML file
  • Step 2: Take a look into the created XML file and build your own load script part to integrate the data from the XMLfile

Have fun with MongoDB! Any comment or feedback will be appreciated.

- Ralf

Labels (1)
Attachments
Comments
Not applicable

So there's no connector needed for this case?

0 Likes
Not applicable

Hi Ralf,

Do you mind to share zips.xml?

Thanks

0 Likes
Not applicable

Image 10.jpgHi Sara,

I have difficulties to enable --rest. Is there anything wrong with my script?

Thanks

0 Likes
MVP & Luminary
MVP & Luminary

This is what I start to run MongoDB:

c:\mongodb\bin\mongod --dbpath c:\mongodb --logpath c:\mongodb\log\mongodb.log --logappend --rest

0 Likes
Not applicable

Hi Ralf,

It works !! Thanks a lot

0 Likes
Not applicable

mongoimport.jpg

another problem ;(

when i try to import zips.json, it failed

but when i browse http://localhost:28017/listDatabases?text=1, I can see that I have scratch db

{ "name" : "scratch",

      "sizeOnDisk" : 1,

      "empty" : true } ]

0 Likes
MVP & Luminary
MVP & Luminary

Use --file parameter, not < sign.

http://docs.mongodb.org/manual/reference/program/mongoimport/

Btw., this is not a Mongo forum..

0 Likes
Not applicable

All fixed! Thanks a lot

0 Likes
Version history
Revision #:
1 of 1
Last update:
‎2013-06-09 11:10 AM
Updated by: