How to connect MongoDB 4.0 to qlik?

[senciucserban]

Hello,

I have some troubles to connect mongodb 4.0 to qlik, from what I see in documentations qlik supports connections with versions: 3.0, 3.2, 3.4, 3.6.

https://help.qlik.com/en-US/connectors/Subsystems/ODBC_connector_help/Content/Connectors_ODBC/Mongo/...

I have a mongodb URI which stats with: mongodb+srv. I test the connection local using python and everything was good.

When I try to connect qlik with same mongodb and credentials it said: Check your host, port, username and password.

Thanks,

Serban

[senciucserban]

Hey mto‌, I hope I tag you good, I am with that question from YouTube video: What's New - Qlik Sense September 2018.

That connection I try to use:

Also I use: Qlik Sense Enterprise

[Michael_Tarallo]

OK great Serban - thank you - I have contacted our products team to see if there is a difference with the connector -

In the mean-time (if this is Qlik Sense Enterprise) have you tried the generic ODBC connector?

https://docs.mongodb.com/bi-connector/master/reference/odbc-driver/

icd‌ - should our Beta MongoDB Connector work with version 4.0 as stated above?

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

Regards,

Michael Tarallo

Qlik

[senciucserban]

I try to use ODBC connector, but I don't see mongodb in drivers?

P.S. I don't have installed mongodb on qlik server.

Thanks,

Serban

[Michael_Tarallo]

So if you want to try the developers ODBC driver and use our generic ODBC driver connector - youwould have to install the developers ODBC driver on the server and then configure a system DSN - once that is done - the ODBC driver would display with the Qlik Sense ODBC connector.

Hope that helps

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

Regards,

Michael Tarallo

Qlik

[senciucserban]

I already have installed, ODBC (32/64-bit) but when I go to Drivers Tab I can't find a driver for mongodb.

Thanks,

Serban

[Michael_Tarallo]

Bumping this for my friend Serban - it seems it should be simple - but he is not having any success. Has anyone successfully connected to MongoDB 4.0?

[Michael_Tarallo]

Still working on this.

[Michael_Tarallo]

Hi Serban - just got word that PM is working with Simba (driver people) to see if the driver we provide (which is still in beta it seems) is compatible with 4.0. If I hear anything I will let you know. Please check in with me periodically as I may lose track over time with other things going on.

Thanks
Mike

[vic]

Yes I just did using the MongoDB (beta) data source connector with MongodB Enterprise. No issues in creating the connection at all. However, my database includes variety of documents - it does not show all the "tables" somehow the metadata it generates misses some objects/arrays in my mongodb documents.