Mastering JMP®

Accessing Databases

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.

Watch Now 14:13

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.

Watch Now 32:48

Back to Top