Extending JMP

External Data Sources, Analytical Tools, and Automation

This chapter discusses scripting features that are particularly useful for production settings, such as the following:

• a data feed for capturing real-time data from a laboratory instrument

• using SAS, MATLAB, R, or Python through JMP Scripting Language (JSL)

• using JMP with Microsoft Excel

• connecting to databases

• controlling JMP externally by OLE automation

• parsing XML

• publishing to JMP Public or JMP Live

• communicating with REST web services

• communicating with web APIs

Some general JSL commands that might be of particular interest for use in a production setting include Caption, Speak, Print, Write, and Mail. These commands are described in Functions that Communicate with Users in the Programming Methods section.

Contents

Real-Time Data Capture on Windows

Create a Data Feed Object

Read in Real-Time Data

Manage a Data Feed with Messages

Examples of Data Feed

Dynamic Link Libraries (DLLs)

Using Sockets in JSL

Socket-Related Commands

Messages for Sockets

Database Access

Run Query Builder Queries

Open Database Function

Creating a Database Connection and Executing SQL

Writing a SQL Query

Working with SAS

Make a SAS DATA Step

Create SAS DATA Step Code for Formula Columns

SAS Variable Names

Connect to a SAS Metadata Server

Get the Values of SAS Macro Variables

Preferences

Sample Scripts

Working with MATLAB

Installing MATLAB

Working with R

Installing R

JMP to R Interfaces

R JSL Scriptable Object Interfaces

Conversion Between JMP Data Types and R Data Types

Troubleshooting

Examples

Working with Python

Install Python

How JMP Finds Python on Windows

JMP-to-Python Interfaces

Equivalent Data Types for Python Send()

Equivalent Data Types for Python Get()

JMP Scoping Operators and Python

Python Name() and Python Send() Examples

Additional Python Integration Examples

Working with Microsoft Excel

Parsing XML

OLE Automation

Communicate with REST Web Services

Examples of HTTP Requests

OAuth 2.0 for Web APIs

Security

Using Postman for Redirect URLs

Authorization Code Grant

Implicit Grant

Resource Owner Grant

Using a Token

OAuth 2.0 Resources

Communicate with SAS Cloud Analytic Services

About CAS Actions

Connect to the CAS Server

Create and Submit a CAS Action

Create a New CAS Server

Import Data

View Datasets

Get a List of Available CAS Libraries

Export Data

Convert a CAS Table to a Data Table

Delete a CAS Table

Remove a CAS Table

Verify the Connection

Get Details about the Current Connection

Disconnect from the CAS Server

Terminate All Sessions

Want more information? Have questions? Get answers in the JMP User Community (community.jmp.com).