MongoDB: What is the best connector, is ODBC connector sufficient, or do I need BI Connector?

[#1]

Dear all,

from another contribution by @JumpingAC I got the hint that there is a Connector for MongoDB:

• https://docs.mongodb.com/bi-connector/master/
• it leads to a file "mongodb-connector-odbc-1.2.0-win-64-bit" for my system

and then I got the hint, that there should be a MongoDB Connector for BI

• https://www.mongodb.com/download-center/bi-connector

but:

• "The MongoDB Connector for BI is available as part of the MongoDB Enterprise Advanced subscription, which features the most comprehensive support for MongoDB and the best SLA"
• i.e. I have to buy it.

So what is the difference between both, does anyone have experience?

How to access the not table like content from MongoDB, is this possible with these connectors, or do I need a different way?

Thanks and best regards,

   Georg

[#2]

hi Georg,

just for your information, is also possible to query MongoDB without third part drivers:

by JSL script you can connect your local JMP to MONGO passing trough R or Python Interface.

i tested this funcionality with R and it works well.

// here a query sample with R 3.5 //

R Init( );

R Submit( "

library(mongolite)

mquery <- mongo(collection = \!"ProbeWafer\!", db = \!"DbProbe\!", url = \!"mongodb://27017/DbaProbe\!")

DataFrame <- mquery$find ('{\!"DATETIME\!": { \!"$gte\!" : { \!"$date\!" : \!"2018-11-30T23:30:00Z\!" }, \!"$lt\!" : { \!"$date\!": \!"2018-12-01T00:00:00Z\!" } }}')");

dt = R Get( DataFrame);

dt << New Data View;

dt << set name ("Mongo Table");

R Term();

// close R Session

ciao

Gianpaolo

[#3]

Hey Gianpaolo,

thanks for your hint, you're right.

I also did a connection to the mongoDB with python, it worked also.

But this would not be my preferred solution, as this would need a python installation for every user, that wants to use the script. So I would like to have a kind of connector, or native connect from JMP to mongoDB.

Best regards,

   Georg

[#4]

Unfortunately , currently there is not a native connection JMP for mongo-db.

this topic has been a my discussion with  Jmp15 developers, but seems that for now they dont have in plan to develop a native connection for no SQL sources

ciao

Gianpaolo

[#5]

Update: As of JMP 18, Python is embedded in JMP and you do not need a separate Python installation for every user anymore