cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
Choose Language Hide Translation Bar
SaraGo
SaraGo
Level II

Automatically fill in data from external source

Created: Jan 13, 2022 03:33 AM  |  Last Modified: Jun 10, 2023 4:42 PM (997 views)

Is there a way to link a JMP database to an external source, and automatically fill in new data in the JMP table as the external source is updated?  

0 Kudos
1 ACCEPTED SOLUTION

Accepted Solutions
briancorcoran
Staff briancorcoran
Staff
Solution

Re: Automatically fill in data from external source

Created: Jan 13, 2022 08:25 AM  |  Last Modified: Jan 13, 2022 7:24 AM (978 views)  |  Posted in reply to message from SaraGo 01-13-2022

Hi Sara,

 

The short answer is yes, but there are many steps to getting a final solution. You must get access to the database from your IT administrators, and then install an appropriate ODBC driver to access the database.  Once you have that working outside of JMP, the steps are fairly straightforward.  You can form a query in Query Builder, or with the Open Table dialog.  When you get the JMP table the way you like it, there is an Update script created in the table properties by JMP that you can reference.  Take the JSL (script) out of there, and create a standalone file with it.  Then, use something like the Windows Task Scheduler or Mac Automator to run the script everyday.

 

I gave a talk at a Discovery conference that describes much of this.  You can reference it at Automated Report Creation: From Data Import to Publication ( 2019-EU-TUT-079 ) 

 

I hope this helps,

 

Brian Corcoran

JMP Development

View solution in original post

1 REPLY 1
briancorcoran
Staff briancorcoran
Staff
Solution

Re: Automatically fill in data from external source

Created: Jan 13, 2022 08:25 AM  |  Last Modified: Jan 13, 2022 7:24 AM (979 views)  |  Posted in reply to message from SaraGo 01-13-2022

Hi Sara,

 

The short answer is yes, but there are many steps to getting a final solution. You must get access to the database from your IT administrators, and then install an appropriate ODBC driver to access the database.  Once you have that working outside of JMP, the steps are fairly straightforward.  You can form a query in Query Builder, or with the Open Table dialog.  When you get the JMP table the way you like it, there is an Update script created in the table properties by JMP that you can reference.  Take the JSL (script) out of there, and create a standalone file with it.  Then, use something like the Windows Task Scheduler or Mac Automator to run the script everyday.

 

I gave a talk at a Discovery conference that describes much of this.  You can reference it at Automated Report Creation: From Data Import to Publication ( 2019-EU-TUT-079 ) 

 

I hope this helps,

 

Brian Corcoran

JMP Development