Choose Language Hide Translation Bar
Highlighted
eadekanmbi
Community Member

How to extract realtime data from constant-changing database using JSL

I have a database that keep updating itself every 2 hours and I want to find a way to get the updated table without having to keep going to the database to obtain new tables each time the database is updated. Please, how do I about this in JMP?

0 Kudos
3 REPLIES 3
Highlighted
guillaumebugnon
Community Trekker

Re: How to extract realtime data from constant-changing database using JSL

Pour intérroger les données il faut soumettre une requête SQL.

Hormis requêter la table toutes les 2 heures pour avoir les dernières données fraîches, je ne vois pas trop comment faire.

Highlighted
Craige_Hales
Staff (Retired)

Re: How to extract realtime data from constant-changing database using JSL

If there are time stamps, the query might only need to fetch data more recent than the last time.

Craige
Highlighted
guillaumebugnon
Community Trekker

Re: How to extract realtime data from constant-changing database using JSL

Yes, one solution could be to :

 

 - query the table (SQL)

 - save the data into jmp datatable

 - keep the max(timestamp) and store it into jmp table for example

 

Next query :

 - query the table (SQL) from max(timestamp) to now()

 - then concatenate to previous data extraction

 

Then loop :)