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
File → Connect To → Data Connectors (ODBC 3.5 driver)
Amazon Redshift
Database
File → Connect To → Data Connectors (ODBC 3.5 driver)
Amazon S3 [3]
Database
File → Connect To → Data Connectors … (Add-in configuration: aws_s3_dc.aws_s3) [4][5]
AspenTech IP.21
Data Historian
File → Connect To → Historian → AspenTech IP.21 Server
DB2
Database
File → Connect To → Data Connectors (ODBC 3.5 driver)
Data Feed From Laboratory Instrument [1]
Data Feed
Open Datafeed();
Dynamic Linked Libraries (DLLs) [1]
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 (versions 2.0 and 3.0 only)
Firebird
Database
File → Connect To → Data Connectors (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
File → Connect To → Data Connectors (ODBC 3.5 driver)
Impala
Database
File → Connect To → Data Connectors (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
File → Connect To → Data Connectors (ODBC 3.5 driver)
MongoDB [3]
Database
File → Connect To → Data Connectors … (Add-in configuration: mongodb_dc.mongodb) [4][5]
Microsoft Access
Database
File → Connect To → Data Connectors (ODBC 3.5 driver)
Microsoft SQL Server
Database
File → Connect To → Data Connectors (ODBC 3.5 driver)
Minitab Portable Worksheet File (.mtp)
Third Party Files
File → Open
Multiple Files
Files
File → Open Multiple (Multiple File Open)
MySQL [3]
Database
File → Connect To → Data Connectors (ODBC 3.5 driver)
OR
File → Connect To → Data Connectors … (Add-in configuration: mysql_dc.mysql) [4][5]
OAuth 2.0
Web API
New HTTP Request();
OneDrive [3]
Cloud Source
File → Connect To → Data Connectors … (Add-in configuration: sharepointdc.onedrive) [4][5]
Oracle
Database
File → Connect To → Data Connectors (ODBC 3.5 driver)
PI Server
Data Historian
File → Connect To → Historian → PI Server
Other ODBC 3.5 Compliant Database
Database
File → Connect To → ODBC → Query Builder
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 [3]
Database
File → Connect To → Data Connectors (ODBC 3.5 driver)
OR
File → Connect To → Data Connectors … (Add-in configuration: postgresql_dc.postgresql) [4][5]
Python Environment [2]
Open Source Language
Python Connect();
R Code (.r,.R)
Third Party Files
File → Open
R Environment [2]
Open Source Language
R Connect();
REST APIs
Web API
New HTTP Request();
SAP Adaptive Server
Database
File → Connect To → Data Connectors (ODBC 3.5 driver)
SAP Hana
Database
File → Connect To → Data Connectors (ODBC 3.5 driver)
SAS 9.4
SAS
File → Connect To → Data Connectors... (Base configuration: com.jmp.sas_remote)[5]
SAS Viya
SAS
File → Connect To → Data Connectors... (Base configuration: com.jmp.sas_viya)[5]
SAS Cloud Analytics Services (CAS)
Web API
CAS Connect ();
SAS Data Sets (.sas7bdat,.xpt,.stx,.v8xpt,.xpt8)
Files
File → Open
Shapefiles (.shp)
Third Party Files
File → Open
SharePoint [3]
Cloud Source
File → Connect To → Data Connectors … (Add-in configuration: sharepoint_dc.sharepoint_list or sharepoint_dc.sharepoint_site) [4][5]
Snowflake
Database
File → Connect To → Data Connectors... (Base configuration: com.jmp.snowflake_rest)[5]
Sockets [1]
Data Feed
Socket ();
SPSS Files (.sav)
Third Party Files
File → Open
SQLite Database (.sqlite,.db,.sqlite3,.db3)
Database
File → Open (Query Builder)
Sybase
Database
File → Connect To → Data Connectors (ODBC 3.5 driver)
TDMS [3]
Files
File → Connect To → Data Connectors … (Add-in configuration: tdms_connector.tdms_connector) [4][5]
Teradata
Database
File → Connect To → Data Connectors (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)
[1] Windows operating systems only. See system requirements (Windows, macOS)
[2] Software must be installed on same machine as JMP.
[3] Data connectors are accessible via the JMP Marketplace and are governed by the terms and conditions of add-ins. For further details, please refer to the provided information on the JMP Marketplace.
[4] The add-in configuration in the “How to Connect” section is available after downloading and installing the appropriate data connector from the JMP Marketplace.
[5] Click 'New Connection' and either:
- Select an existing configuration and click Connect, or
- Choose the base configuration for this data source (as described in the “How to Connect” section), click 'New', provide the settings, and click Connect.
If you save your settings, you can choose option 1 next time. JMP can also automatically convert many ODBC DSNs.