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.