Share your ideas for the JMP Scripting Unsession at Discovery Summit by September 17th. We hope to see you there!
Choose Language Hide Translation Bar
Application Development - Accessing Databases

Learn how to quickly create a new connection to a database and access, query and subset data using the ‘Query Builder’:
- Accessing
- Querying
- Sub setting
- Saving
- Updating



Situation: As the production manager, you need to access product, customer and address information to release product from the warehouse.


Task: The problem is that the critical parameter information along with address details for the driver are in multiple tables within a database.


Action: You use the Query Builder to access the database, query the data that you need subset it and save the information to a data table for analysis.


Result: You create multiple reports that demonstrate your product is stable and capable of meeting specifications for the critical parameter.


Next Steps: Your query and analysis is saved along with an Add-in that you and your team can quickly run the next time you need the information.


Article Labels

    There are no labels assigned to this post.