topic Re: Connector for MongoDB Community in Connectivity & Data Prep

Connector for MongoDB Community

virilo_tejedor — Tue, 29 Nov 2016 16:31:45 GMT

Hi,

I’m interested on a connector to feed a QlikSense application from a MongoDB Community Server.

Data stored on mongo is not vital, but appreciated.

I’ve seen that QlikSense includes its own connector, but unfortunately it has an uncertain future. According to chage log note in http://wiki.qvsource.com/MongoDB-Connector-For-QlikView.ashx#Change_Log_14:

“Please note that as a new official BI Connector (https://docs.mongodb.org/manual/products/bi-connector/) is now available for MongoDB 3.2 and later you may wish to first consider this. Because of this we are also now considering retiring this connector if it does not offer any advantages over this.”

The problem is that Mongo BI connector is only available for MongoDB Enterprise.

Both connectors have very different approaches. Even when Qlik Conector uses JSON Queries, Mongo’s one is using a reduced SQL.

Has Qlik done a more recent announcement about their strategy for MongoDB connector?

What alternatives do we have to MongoDB Enterprise?

Thanks in advance,

Virilo

Re: Connector for MongoDB Community

alexandrakfcosta — Tue, 29 Nov 2016 18:16:52 GMT

Hi Virilo,

The alternative solution for me was to export MongoDB data to a json document and use one of the Qlik Sense embedded connector, called REST Connector.

This way, you can publish the exported json document in a web environment and access the document using the supported connector.

In my case, I have a daily task to export the data to a specific path and a scheduled reload in Qlik Sense.

Does that make sense?

Best,

Alexandra

Re: Connector for MongoDB Community

virilo_tejedor — Wed, 30 Nov 2016 08:42:16 GMT

Hi Alexandra,

Thanks for your response.

On this way we should expose a REST service everytime we had a new “table”

We were looking for any “plug and play” solution, allowing us to connect and use like other datasources.

I have no great expectations, since we’re treating a documental database as it were a ER database. As far as I have read, MongoDB connector is not too much “plug and play”, since you have to configure and maintain its DRDL https://docs.mongodb.com/bi-connector/v1.1/schema-configuration/

Any suggestions?

Best regards

Re: Connector for MongoDB Community

alexandrakfcosta — Thu, 01 Dec 2016 16:22:53 GMT

Hi Virilo,

Unfortunately I can't help you with that.
We are planning to test the MongoDB Connector soon and if something comes up I will let you know.

Sorry to not be able to solve your problem.

Good luck!