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

Bass_Masri_0-1599785461442.png

 

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.