Import Data from a Database

You can import data from a database using ODBC (Open Database Connectivity) in the following ways:

• With JMP’s configurable and shareable data connectors.

• With a DSN using JMP’s Open Table feature.

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).