topic Re: JMP to MongoDB connection. in Discussions

JMP to MongoDB connection.

fionaweston — Sun, 11 Jun 2023 12:19:11 GMT

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

Re: JMP to MongoDB connection.

briancorcoran — Mon, 08 Nov 2021 18:56:24 GMT

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

Re: JMP to MongoDB connection.

ih — Tue, 09 Nov 2021 20:13:44 GMT

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