Dear all,
from another contribution by @JumpingAC I got the hint that there is a Connector for MongoDB:
and then I got the hint, that there should be a MongoDB Connector for BI
but:
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
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
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
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