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.
background-image
Style
blue-purple-gradient, background-image, text-light, button-light, text-large, text-66, section-padding-medium
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.