Subscribe Bookmark RSS Feed

How do I sync a jmp datatable to a database?

chrisvanlang

Community Trekker

Joined:

Feb 3, 2016

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?

3 REPLIES
M_Anderson

Staff

Joined:

Nov 21, 2014

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

chrisvanlang

Community Trekker

Joined:

Feb 3, 2016

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

M_Anderson

Staff

Joined:

Nov 21, 2014

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