How to Automatically Refresh JMP Charts When SQL Data Updates

[#1]

I have connected JMP to my SQL database and created several charts based on this data. However, I would like to ensure that my charts always reflect the most up-to-date information from the database.

What is the best way to refresh or update the data in JMP so that my charts automatically reflect any new or updated records in the SQL database? I heard a custom scrip would help. But I do not know how to do it. Can someone educate me and share with me an example?

Thank you

[#2]

Does your data need to just perform full refresh, keep adding new rows on each update, update old rows or update old rows and add new rows?

[#3]

Thank you so much for helping! 

I have quality data for raw material, in process items and finish good since2020 for various products. The database keeps adding new records over time, so I would like JMP to append new rows without reloading the entire dataset. Existing records do not change.

[#4]

You can create a script for example, which will take latest id/date from your JMP table, run SQL query based on that and then concatenate the query result to original table. It might be beneficial to keep track of the last query interval as sometimes the query might not return any rows and you might end up repeating unnecessary queries.

[#5]

Did you connect to your database using a JMP Data Connector? 

Did you create your SQL query using the Query Builder? 

If you use the Query Builder, then your data table will automatically come with options to a) refresh the data by re-using the same query, or b) modify the query so you can pull new data.