For the latest version of JMP Help, visit JMP.com/help.


Using JMP > Import Your Data > Import Data from a Database
Publication date: 05/05/2023

Import Data from a Database

You can import data from a database if you have an ODBC (Open Database Connectivity) driver for the database and then save the data back to the database.

You can use Structured Query Language (SQL) statements to control what you import from an external database. When you open a database file in JMP, you are actually sending a SQL statement to the database. By default, this statement gets all columns and records in the database table. See Build SQL Queries in Query Builder for more information about interactively building queries. See Write SQL Statements to Query a Database for more information about writing queries yourself.

This section describes how to connect to a database and import the data.

Notes:

Database table names that contain the characters $# -+/%()&|;? are not supported.

Multiple connections to a datasource are not permitted.

Use a 64-bit version of the ODBC driver to match the bitness of JMP.

SQL Native 11 and ODBC for SQL Server 17 don’t return the column length. When a driver does not return a column length, the limit is 4MB.

Want more information? Have questions? Get answers in the JMP User Community (community.jmp.com).