Mastering JMP^®

Expand Your Analytic Skills

On-Demand Webcast

Advanced Mastering JMP: Accessing Databases

JMP interactively accesses data from SAS® and all ODBC-compliant databases. See how to connect to databases and use the Query Builder to query, aggregate, join, save and update data.

Presenter: Chris Kirchberg

Part 1: Importing Files and Connecting to Databases

The presenter reviews how to import files and single tables. He demonstrates how to create a connection to a database, including how to locate drivers and connect to a user of machine data source (DSN). He reminds the users that the bitness (32- or 64-bit) of the ODBC driver must match that of the version of JMP being used.

Part 2: Using Query Builder to Query, Aggregate, Join, Save, and Update Data from Databases

The presenter demonstrates how to use the JMP interactive Query Builder to select tables, automatically join tables and turn off table auto join. He shows how to use selection boxes to define a query, aggregate data, sample data and filter data based on user-supplied values. He builds a saved query where the user is prompted to filter or order results each time the query is run and describes how to modify or update data when rerunning a query.