While JMP® software offers the ability to import a variety of file types, JMP also implements a method for connecting to databases to extract the data needed for further analysis. The intent of this paper is to provide a general overview of how Open Database Connectivity (ODBC) works, explain how to connect to a database from within JMP, access database tables, create custom queries, save JMP data tables to databases, and use the JMP Scripting Language (JSL) to automate the process.
Connections: JMP and ODBC
