Data Connectors

Data access is fundamental. It's the starting point for any analytic journey. That's why, with JMP, we make it easy to access your data from a variety of sources.

Data Source

Type

How to Connect

Amazon Aurora

Database

Database → Query Builder (ODBC 3.5 driver)

Amazon Redshift

Database

Database → Query Builder (ODBC 3.5 driver)

Azure SQL

Database

Database → Query Builder (ODBC 3.5 driver)

DB2

Database

Database → Query Builder (ODBC 3.5 driver)

Data Feed From Laboratory Instrument*

Data Feed

Open Datafeed();

Dynamic Linked Libraries (DLLs)*

Data Feed

Load DLL();

Excel Files (.xls,.xlsx,.xlsm)

Third Party Files

File → Open (Excel Import Wizard), Excel Add-In

FACS Files (.fcs)

Third Party Files

File → Open

Firebird

Database

Database → Query Builder (ODBC 3.5 driver)

Google Sheets

Cloud Source

Internet Open → Google Sheets

HDF5 Data File (.h5,.hdf5,.hdf)

Third Party Files

File → Open

HTML Files (.htm,.html)

Third Party Files

File → Open

Hive

Database

Database → Query Builder (ODBC 3.5 driver)

Impala

Database

Database → Query Builder (ODBC 3.5 driver)

JMP Application Files (.jmpappsource,.jmpapp)

Files

File → Open

JMP Customizations (Add-Ins, Menus)(.jmpaddin,.jmpaddindef,.def,.jmpcust)

Files

File → Open

JMP Data Tables (.jmp)

Files

File → Open

JMP Journals (.jrn)

Files

File → Open

JMP Live

Web API

New JMP Live (), File → Publish

JMP Projects (.jmpprj, .jmpprjarchive)

Files

File → Open

JMP Reports (.jrp)

Files

File → Open

JMP Scripts (.jsl)

Files

File → Open

JMP SQL Queries (.jmpquery)

Files

File → Open

MariaDB

Database

Database → Query Builder (ODBC 3.5 driver)

MATLAB Code (.m,.M)

Third Party Files

File → Open

MATLAB Environment**

Numeric Computing Platform

MATLAB Connect ();

Microsoft Access

Database

Database → Query Builder (ODBC 3.5 driver)

Microsoft SQL Server

Database

Database → Query Builder (ODBC 3.5 driver)

Minitab Portable Worksheet File (.mtp)

Third Party Files

File → Open

Multiple Files

Files

File → Open Multiple (Multiple File Open)

MySQL

Database

Database → Query Builder (ODBC 3.5 driver)

OAuth 2.0

Web API

New HTTP Request();

Oracle

Database

Database → Query Builder (ODBC 3.5 driver)

OSI PI Server

Data Historian

Database → Import from OSIsoft PI Server

Other ODBC 3.5 Compliant Database

Database

Database → Query Builder → New Connection

Other Source Code (.py,.PY,.c,.C,.cpp,.CPP,.sql,.SQL)

Third Party Files

File → Open

PDF Files (.pdf)

Third Party Files

File → Open (PDF Import Wizard)

PostgreSQL

Database

Database → Query Builder (ODBC 3.5 driver)

Python Environment**

Open Source Language

Python Connect();

R Code (.r,.R)

Third Party Files

File → Open

R Environment**

Open Source Language

R Connect();

REST APIs

Web API

New HTTP Request();

SAP Adaptive Server

Database

Database → Query Builder (ODBC 3.5 driver)

SAP Hana

Database

Database → Query Builder (ODBC 3.5 driver)

SAS 9.4

SAS

SAS → SAS Query Builder

SAS Cloud Analytics Services (CAS)

Web API

CAS Connect ();

SAS Data Sets (.sas7bdat,.xpt,.stx,.v8xpt,.xpt8)

Files

File → Open

SAS Program Files (.sas)

Files

File → Open

Shapefiles (.shp)

Third Party Files

File → Open

Sockets*

Data Feed

Socket ();

SPSS Files (.sav)

Third Party Files

File → Open

SQLite Database (.sqlite,.db,.sqlite3,.db3)

Database

File → Open (Query Builder)

Sybase

Database

Database → Query Builder (ODBC 3.5 driver)

Teradata

Database

Database → Query Builder (ODBC 3.5 driver)

Teradata Database (.trd)

Database

File → Open

Text Files (.csv,.tsv,.dat,.txt)

Third Party Files

File → Open (Text Import Wizard)

Triple-S Survey Data (.sss,.SSS,.xml,.XML)

Third Party Files

File → Open

Webpages

Webpages

Internet Open → Web Page

xBase Data Files (.dbf)

Third Party Files

File → Open

XML and JSON Data Files (.xml,.json)

Third Party Files

File → Open (XML Import Wizard)

* Windows operating systems only. See system requirements
** Software must be installed on same machine as JMP.