topic Re: Replacing Qlik Inbuilt Mongo DB Connector over Qlik Mongo DB Web Connector in Connectivity & Data Prep

Replacing Qlik Inbuilt Mongo DB Connector over Qlik Mongo DB Web Connector

rohitk1609 — Mon, 13 Dec 2021 17:27:21 GMT

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.

Re: Replacing Qlik Inbuilt Mongo DB Connector over Qlik Mongo DB Web Connector

Jay_Brown — Wed, 13 Mar 2019 20:52:25 GMT

Hello Rohit,

If you wish to use the Beta Connector in production, then it is important to understand the following:
1. Use of this software is governed solely by the early release license terms. The terms of any other agreement between you and Qlik for other software, products, or services are not applicable to beta connectors.
2. Qlik support may not be able to assist you with all issues for these connectors beyond a best-effort basis.

So if your concern is reliability and supportability, a beta connector may not be the best option.

I'd recommend the MongoDB ODBC drivers for your MongoDB version and configuring a System DSN, then having Qlik use that connection.

Re: Replacing Qlik Inbuilt Mongo DB Connector over Qlik Mongo DB Web Connector

rohitk1609 — Thu, 14 Mar 2019 05:21:47 GMT

Hey Jay,

Does MongoDB ODBC connector is free ? if yes can you suggest any site from where I can download and test it ?

Regards,
Rohit

Re: Replacing Qlik Inbuilt Mongo DB Connector over Qlik Mongo DB Web Connector

shemeel — Wed, 11 Mar 2020 14:54:41 GMT

You can use Mongo BI Connector http://docs.mongodb.com/bi-connector/master/

Re: Replacing Qlik Inbuilt Mongo DB Connector over Qlik Mongo DB Web Connector

rohitk1609 — Sun, 15 Mar 2020 08:35:36 GMT

Can you please guide me how to run this connect as service ?

Re: Replacing Qlik Inbuilt Mongo DB Connector over Qlik Mongo DB Web Connector

shemeel — Mon, 16 Mar 2020 14:38:11 GMT

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)

Re: Replacing Qlik Inbuilt Mongo DB Connector over Qlik Mongo DB Web Connector

fabdulazeez — Wed, 29 Dec 2021 06:38:16 GMT

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,