JMP to MongoDB connection.

[#1]

I am reading back to posts from 2019 that say there is not a native connection in JMP for mongo-db. Is this still the case?

Our ERP system runs Mongo DB and we'd like to connect to JMP (16). Is it possible yet?

Thanks

[#2 · Accepted solution]

Hi Fiona,

Access to Mongo through JMP will require an ODBC driver.  There are a variety out there, some of which you must pay for.  Once you set up the driver with your Mongo connection information you can use the JMP Query Builder or Database Open Table capabilities.  Most databases like Oracle or SQL Server require the same kind of preparation prior to importing data into JMP.

Brian Corcoran

JMP Development

[#3 · Accepted solution]

You can also utilize R or python for this:

Names Default To Here( 1 );
R Init();
R Submit("
library(mongolite)
connection_string = 'mongodb+srv://<username>:<password>@<cluster-name>.mongodb.net/sample_training'
trips_collection = mongo(collection=\!"trips\!", db=\!"sample_training\!", url=connection_string)
trips_collection = mongo(collection=\!"trips\!", db=\!"sample_training\!", url=connection_string)
user_types = trips_collection$aggregate('[{\!"$group\!":{\!"_id\!":\!"$usertype\!", \!"Count\!": {\!"$sum\!":1}}}]')
df <- as.data.frame(user_types)
");

dt = R Get(df);
R Term();

Example R Syntax is from: https://www.mongodb.com/languages/mongodb-and-r-example