Hello Wen,
If your MySQL DB is hosting the jackrabbit database, then the jobs and transformations are stored in that database (not as hidden files). That database is quite opaque though. All the info in it is serialized into binary so it's not very workable to use that directly.
Use the PDI Client/Spoon for examining the imported jobs and transformations--that's also the easiest way to see the directory structure.
Or use the API calls to display the directory tree of the Pentaho repository:
http://10.208.120.103:8080/pentaho/api/repo/files/tree
Check out the documentation related to these API calls (use whatever version number is correct--although these have been stable for some time):
https://help.hitachivantara.com/Documentation/Pentaho/9.1/Developer_center/REST_API_Reference/File_Management
Unfortunately, if there are API calls to pull out the XML definition of a given job or transformation, I don't know how to make them work.
------------------------------
John Craig
Systems Engineer
Henry Schein Practice Solutions
------------------------------
Original Message:
Sent: 04-26-2023 02:17
From: wen maoyu
Subject: Where are the transctions and jobs importing?
My environment is deploying pentaho-server community 9.1 version,and set mysql as backgroud databse.
when i import the jobs through http://10.208.120.103:8080/pentaho,i could not find where is ?
i want to know the jobs and transforms , save to wich library and which table?
------------------------------
wen maoyu
IT Support Manager
CCTV
------------------------------