nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

JMP as a data transformer?

Florian_Vogt

Hi all,

a customer I talked to today is planning the future software landscape. They already use JMP in several countries and at an advanced level.

They now had an idea which I never heard of in a real world application, and asked for my comments/suggestions:

They want to use JMP as tool for transforming log-files from their machines and want JMP to write those on a database.

At the moment they are using other software for this, and JMP only for the data analysis. So they think they could replace the other software with JMP and use JMP for both tasks. Below is a schematic drawing of the current state.

JMP as data transformer.png

Does anybody have any thoughts, experiences or advice for me?

Thank you all in advance!

Best regards,

Florian

Accepted answers

martindemel

the import of the log file should then be almost straight forward. If there is a header you may need to adjust the process a bit, as you otherwise loose the automatically set column properties. But this can be figured out.

Writing to a database since the data is in JMP, this thread should help you with:

Saving-to-a-SQL-Database-from-a-JMP-Table-Does-the-Original-SQL

All comments

martindemel

Hi Florian,

before telling if JMP can do this, I believe the following is most important:

- will the log files have a similar pattern, so are there e.g. keywords to let you know where to extract the information necessary to be written into the database.

- will this be a 24/7 task to be fullfilled? This might lead into an operational risk when using JMP to do that.

If that's not the case my answer would be "maybe, but this is a huge effort and I doubt you would have fun going forward with this"

If there is a pattern and the log files might be in pdf, you could extract the information as tables. If it is text like csv or ASCII you could do similar things. After import you could use regexp and recode to extract the important information to be send to the db.

I have not seen that so far, but I can imagine it will work. However, this probably is a huge effort anyway if you are not experiences in extracting text from documents.

Florian_Vogt

Hi Martin,

thanks for responding.

The files are ".log" and in a text/csv-like shape; they can be imported equally.

Currently the data is analyzed once per day.

Thank you for your feedback!

Best regards

Florian

martindemel

Writing to a database since the data is in JMP, this thread should help you with:

Saving-to-a-SQL-Database-from-a-JMP-Table-Does-the-Original-SQL

Florian_Vogt

Thanks Martin!