Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
We were using Qlik Mongo DB web connector but we have got to know that Qlik has introduced Qlik MongoDB_(Beta) inbuilt connector, so we are trying to replace web connector mongo db connector by Qlik inbuilt MongoDB_(Beta) connector.
Its an production environment so we don't take any risk, so we are looking all aspects to use Qlik inbuilt mongo db connector.
We are expecting Qlik inbuilt mongo db connector work as wen connector mongo db connector.
data is extracting but as beta is written with mongo db connector name so we are in confusion over its reliability.
I used same credentials which we are using in web connector mongo db and data is extracted.
You can use Mongo BI Connector http://docs.mongodb.com/bi-connector/master/
Can you please guide me how to run this connect as service ?
This is mentioned in the article itself. I went through the article along with DBA and we were able to set this up in an hour
http://docs.mongodb.com/bi-connector/master/launch/#launching-mongosqld
To install and run mongosqld as a system service, run the following commands:
"C:\Program Files\MongoDB\Connector for BI\2.4\bin\mongosqld.exe" install --config "<pathToConfigFile>\mongosqld.conf" net start mongosql
Once started as a service use ODBC driver from
https://github.com/mongodb/mongo-odbc-driver/releases/
You can change the port in config file if it is being used by any other process
you can leave the host in ODBC blank or use localhost ( This is assuming you are using same machine for BI connector, or you may have to update binding IP in the config file as well)
The BI Connector is part of the Enterprise version. We can use the BI Connector as an evaluation. Details are in the LICENSE file when you install the BI Connector. When we download we receive a mail like below
As a reminder, the MongoDB Connector for BI is free for evaluation. It is available as part of the MongoDB Enterprise Advanced subscription, which includes MongoDB Enterprise Server, comprehensive management platforms, enterprise-grade support,