How do I sync a jmp datatable to a database?

Question

I can extract data from my database to my table but everytime I update the database, I will have to create a new table and import all of my old scripts. How do I automatically update the table rather than redo everything?

MikeD_Anderson · Answer

Indeed!  Query Builder is a new feature in JMP12 which came out earlier this year.  There are a lot of good reasons to upgrade to JMP12.  You should talk to your site admin about getting upgraded.

best,

M

chrisvanlang · Answer

Oh dear. Looking at Update a table from a database ? It seems like this is only possible with JMP 12.1. I am using JMP 10

MikeD_Anderson · Answer

Are you using JMP12?  If so then you can just use the "Update From Database" script that is placed in the data table by the query builder.

Best,

M