For the latest version of JMP Help, visit JMP.com/help.

Publication date: 09/28/2021

Open the Selected Data

After you specify the columns and data to import from the SQL database, click Run Query to open the data in a data table. The SQL statements are saved as a table variable. The following scripts are available:

Source

Runs the query.

Modify Query

Opens the query in Query Builder, where you can change which columns and data are imported and further customize the query.

Update From Database

Connects to the database to refresh the data and then run the query. If the data table and database table contain the same number of columns, values in the existing data table are updated when the database is refreshed.

The existing data table is also updated when only formula columns follow the last column that is refreshed.

Otherwise, the updated data appears in a new data table.

Want more information? Have questions? Get answers in the JMP User Community (community.jmp.com).