topic Re: JMP and MongoDB in Discussions

JMP and MongoDB

JumpingAC — Wed, 19 Sep 2018 14:23:40 GMT

Our database team is moving us from a T-SQL framework to a MongoDB framework. Currently much of our team has extensive JMP scripts and tools for automated queries / processing / analysis that rely on JMP's ability to connect/pull through the OBDC drivers.

What does JMP / MongoDB integration look like? Below is a 'sample' of how we interact currently. Is this functionality still avaliable with the MongoDB system?

S=evalinsert("SELECT
.
.
.
.
);
dt1 =       Open Database(
"DSN=SQL;Description=SQL;UID=;Trusted_Connection=Yes;APP=JMP;WSID="||user||";DATABASE=SQL",
     S,
     "Results from " || Char( startdate ) || " to " || Char( enddate ) || ""
);

Re: JMP and MongoDB

Phil_Brown — Wed, 19 Sep 2018 16:26:22 GMT

Hi JumpingAC,

I too am on a similar path. Haven't actually integrated yet fully. But as far as I know once there's an ODBC driver available, JMP can use it. There are other options as well where no DSN is required.

Also with JMP 14's new parsing functions, building JSON and XML expression are much easier.
See: https://community.jmp.com/t5/Discussions/Efficient-Construction-of-XML-and-JSON/m-p/53875/highlight/true#M30434

among others.

Re: JMP and MongoDB

JumpingAC — Wed, 19 Sep 2018 16:33:02 GMT

That looks very helpful. I was also just infomed we'll be taking adjantage of the MongoDB Connector ( https://docs.mongodb.com/bi-connector/master/ ) which will provide the JMP / SQL / Database connections.

I was hoping there was a way to easily parse a MongoDB native JavaScript bit of code within a JMP script.