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.