BookmarkSubscribeRSS Feed
chrisvanlang

Community Trekker

Joined:

Feb 3, 2016

How do I sync a jmp datatable to a database?

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
MikeD_Anderson

Joined:

Nov 21, 2014

Re: How do I sync a jmp datatable to a database?

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

Re: How do I sync a jmp datatable to a database?

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

Joined:

Nov 21, 2014

Re: How do I sync a jmp datatable to a database?

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