JMP and MongoDB

[#1]

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 ) || ""
);

[#2]

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/...

among others.

[#3]

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.