For the latest version of JMP Help, visit JMP.com/help.


Scripting Guide > Extending JMP
Publication date: 06/21/2023

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 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
Connect to a SAS Metadata Server
Get the Values of SAS Macro Variables
Get SAS Preferences
Sample Scripts

Work with MATLAB

Install MATLAB

Work with R

Install R
JMP to R Interfaces
R JSL Scriptable Object Interfaces
Conversion Between JMP Data Types and R Data Types
Troubleshoot Working with R
R Examples

Work with Python

Install Python
Troubleshoot the JMP Python Integration
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

Work with Microsoft Excel

Parse XML

OLE Automation

Share Reports on JMP Live

JMP Live Prerequisites
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).