topic Mongo DB in QlikView

Mongo DB

Tue, 19 Jul 2016 07:39:11 GMT

I have port, address for mongo db .

I want to connect to Mongo DB database from Qlikview. I have created DSN, but when i select ODBC from Qlikview and select DSN name, I do not hav any username and password.

How should i connect in that case?

Re: Mongo DB

er_mohit — Tue, 19 Jul 2016 08:11:34 GMT

Hi,

Have a look into this

http://www.easysoft.com/products/data_access/odbc-mongodb-driver/getting-started.html#qlikview

Hope it helps.

Re: Mongo DB

Anil_Babu_Samineni — Tue, 19 Jul 2016 08:17:40 GMT

Did you install the MongoDB ODBC Driver.

If not, use this to download

MongoDB ODBC Driver

Re: Mongo DB

Tue, 19 Jul 2016 12:07:54 GMT

Yes I have installed driver from this site only, I am able to create DSN also , test succeeded.(screenshot attached)

But from Qlikview when i try to create ODBC , selecting created DSN and keeping username and password empty. I am getting attached error. Do I have to use license version than it will work?

Re: Mongo DB

gargi_bardhan — Tue, 27 Sep 2016 14:32:57 GMT

Hi Roisha ,

I am facing below error message while establishing connection :

I downloaded the trial version of ODBC DriveSimba License (Windows) from www.simba.com .

Can anyone please suggest how to resolve this error ?

Thanks,

Gargi

Re: Mongo DB

Fri, 07 Oct 2016 14:42:02 GMT

Here is an example of connecting MongoDB with QlikView using the MongoDB ODBC Driver from CData: https://www.cdata.com/kb/tech/mongodb-odbc-qlikview-chart.rst

Re: Mongo DB

gargi_bardhan — Tue, 18 Oct 2016 10:26:24 GMT

Thanks Eric for your time and help, but I am facing issues while creating ODBC connection, getting the below error message :

[Simba][MongoDBODBC] (110) Error from MongoDB Client: No suitable servers found (`serverselectiontryonce` set): [connection timeout calling ismaster on 'server name:37017'] (Error Code: 13053)

Thanks,

Gargi

Re: Mongo DB

Tue, 18 Oct 2016 14:07:13 GMT

It appears that you are using a different ODBC Driver. The article that I sent you uses the MongoDB driver from http://www.cdata.com/drivers/mongodb/odbc/.