Pentaho

 View Only
  • 1.  pentaho server

    Posted 10-10-2023 10:43

    So i entered the pentaho server, and started to put from my local pentaho to the server, all my transformations and jobs. and i it was doing great! But in some way that in the next day i entered there, and all my transformations are gone, my jobs are there at least, but all my transformations is gone, could please someone help me, cause isn't normal, all the transformations be gone, without even ask me, or show me that those transformations are going be exclude. AND is not even in the trash- can, and also i don't know how to back up, all my transformations/jobs in the pentaho server to prevent it from happening again, so please someone, help me! 



    ------------------------------
    murilo henrique ferreira
    Administrative Assistant
    orit artigos de luxo
    ------------------------------


  • 2.  RE: pentaho server

    Posted 10-12-2023 12:55

    I hope you're able to find your transformations!

    It's very easy to end up importing or saving into a directory you did not mean to import to, so you might try using this API call to see if you can find your transformations (you should be able to run this via a web browser or use the curl command line program to run it):

    http://serverNameOrIP:8080/pentaho/api/repo/files/:/tree

    In the resulting XML, search for .ktr to see if your transformations are somewhere you did not expect. If you find them, move them using Spoon (Tools > Repository > Explore) or Pentaho User Console.

    Whether you find your transformations or not, I strongly recommend that within Spoon you use File > Export > To XML to save each transformation and job to an external file. This makes it much easier to make changes to individual elements of your ETL logic and save the versions in a revision control system (such as Git or, if you needs are pretty simple, perhaps Subversion). You'll also want to enable version tracking inside Spoon (see Pentaho documentation https://help.hitachivantara.com/Documentation/Pentaho/Data_Integration_and_Analytics/9.4/Setup/Set_PDI_version_control_and_comment_tracking_options)--the instructions are the same for any relatively recent version of Pentaho.

    You can back up your entire Pentaho repository using the import-export command line tool (https://help.hitachivantara.com/Documentation/Pentaho/Data_Integration_and_Analytics/9.4/Setup/Backup_and_restore_Pentaho_repositories).
    It's also possible to export entire repository folders from Spoon
    https://help.hitachivantara.com/Documentation/Pentaho/Data_Integration_and_Analytics/9.4/Setup/Import_and_export_PDI_content
    or using command line as described in the note above.

    I hope something here is useful!

    John



    ------------------------------
    John Craig
    Systems Engineer
    Henry Schein Practice Solutions
    ------------------------------