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