Accessing Databases

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.

Resources related to the information in these videos

• Query Builder: The New JMP® 12 Tool For Getting Your SQL Data by Eric Hill, JMP Software Developer.  Presented at JMP Discovery Summit Europe 2015.
• SQL data types
• SQL keys
• Indexes
• Database terminology (including inner and outer join)
• Basic SQL commands
• JMP Journal used in this presentation
• See also Using JMP to Harness the Full Power of SAS