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:

• Capturing a real-time data feed from a laboratory instrument

• Using SAS, MATLAB, or R 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 functions are described in “Functions that Communicate with Users”.

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 Scripts

Dynamic Link Libraries (DLLs)

Use Sockets in JSL

Socket-Related Commands

Messages for Sockets

Database Access

Run Query Builder Queries

Open Database Function

Create a Database Connection and Execute SQL

Write a SQL Query

Work with SAS

Make a SAS DATA Step

Create SAS DATA Step Code for Formula Columns

SAS Variable Names

Work with MATLAB

Install MATLAB

Work with R

Install R

Install jmpex

How JMP Finds R

RPY2

Conversion Between JMP Data Types and R Data Types

Troubleshoot Working with R

R Examples

Work with Microsoft Excel

Parse XML

OLE Automation

Share Content on JMP Live

Establish a Default Connection to JMP Live

JMP Live Result Objects

JMP Live Folder Objects

Create a New Folder in JMP Live

Publish Reports or Data to JMP Live

Replace a JMP Live Report

Update Data in JMP Live

Communicate with REST Web Service

Examples of HTTP Requests

OAuth 2.0 for Web APIs

OAuth Security

Postman for Redirect URLs

Authorization Code Grant

Implicit Grant

Resource Owner Grant

Specify 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 and Submit a CAS DATA Step Action

Create a New CAS Server

Import Data from the CAS Server

View a CAS Dataset

Get a List of Available CAS Libraries

Export Data from a Data Table to a CAS Server

Convert a CAS Table to a Data Table

Delete a CAS Table

Remove a CAS Table

Verify the CAS Server Connection

Get Details about the Current Connection

Disconnect from the CAS Server

Terminate All CAS Sessions

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