Qlik Community

Ask a Question

Connectivity & Data Prep

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
virilo_tejedor
Contributor III
Contributor III

Connector for MongoDB Community

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

3 Replies
alexandrakfcosta
Contributor III
Contributor III

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

virilo_tejedor
Contributor III
Contributor III
Author

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

alexandrakfcosta
Contributor III
Contributor III

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!