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

Georg

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

gianpaolo

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