topic How can you connect to and query a Mongodb database? in QlikView

How can you connect to and query a Mongodb database?

Mon, 18 Oct 2010 15:02:07 GMT

Is there any easy way to get data out of a Mongodb database and into Qlikview directly?

The only things I can think of is have our application dump the data to a SQL based database or a CSV / flat file and then import it but that kind of defeats the purpose of the Mongodb database.

How can you connect to and query a Mongodb database?

Mon, 18 Oct 2010 15:31:00 GMT

Hi Chris,

is there the possibilty of a connection using ODBC or OLE DB. If not, I suppose you have to use the good old csv-interface. I know, that would be pretty poor.

Regards

Roland

How can you connect to and query a Mongodb database?

Anonymous — Tue, 19 Apr 2011 12:49:11 GMT

Hi, maybe QVX will be solution for that? What do you think about it?

Best regards

Przemek Zukowski

How can you connect to and query a Mongodb database?

Sat, 23 Apr 2011 17:02:39 GMT

Please consider checking out QVSource, a new application for connecting to APIs and other data sources which can sometimes be more tricky to load in QlikView.

http://www.qvsource.com/wiki/

We have connectors available already for FaceBook, LinkedIn, OData and are working on a connector for MongoDB (as well as a number of other sources and APIs) - I hope that the first beta of the MongoDB connector will be in the next release, likely sometime next week.

How can you connect to and query a Mongodb database?

Mon, 02 May 2011 15:18:47 GMT

Update: QVSource now has a MongoDB Connector:

http://www.qvsource.com/wiki/MongoDB-Connector.ashx

Re: How can you connect to and query a Mongodb database?

rbecher — Thu, 13 Oct 2011 19:50:30 GMT

You can use our application.

- Ralf

Uploaded a new and better version!

Re: How can you connect to and query a Mongodb database?

chrisbrain — Fri, 14 Mar 2014 10:16:38 GMT

Just a quick note to say that we have a brand new version of our QVSource MongoDB Connector for QlikView released today.

MongoDB Connector For QlikView - QVSource - The QlikView API Connector (Docs)

Re: How can you connect to and query a Mongodb database?

Anonymous — Sun, 16 Aug 2015 02:44:28 GMT

Hello Ralf,

What is the Module password?

Thank you!

Re: How can you connect to and query a Mongodb database?

rbecher — Sun, 16 Aug 2015 18:09:18 GMT

I've attached version without password..

- Ralf

Re: How can you connect to and query a Mongodb database?

Anonymous — Thu, 24 Sep 2015 20:25:08 GMT

Thanks a lot Ralf !

Can you attach the xml too?

If you have any documentation too, about this qvw, it would be great.

Best regards,

Wagner

Re: How can you connect to and query a Mongodb database?

rbecher — Fri, 25 Sep 2015 07:10:27 GMT

No docu there, we're programmers.. ;-)‌

The xml file is created during the load from the JSON data.

Re: How can you connect to and query a Mongodb database?

jujucts — Wed, 23 Dec 2015 08:34:33 GMT

Hi Ralph,

I read this thread and the qvw.

Do I have to understand the only way to connect to MongoDB is thru "_get_JSON_data" function

Even if I can guess how it works I could not find the sub _get_JSON_data() , so I can't really understandeverything

Can you precise how you do connect to MongoDB ? IS this QV script generared thru QV source ?

best regards

juju