CODEWITHSUNDEEP
pentahodata-integration
Malavika
Malavika

Reputation: 87

Where are the transformations saved in Pentaho Data Integration

This maybe a basic question but I would like to know where are the transformations saved in Pentaho Data Integration. Currently, I am connecting to a repository and all my jobs and transformations are saved there.I would like to be able to say email a particular transformation to another person. I checked on the server if there are any .ktr files but could not find any. How can I save a transformation to my local desktop.

Thanks in advance for your help.

Upvotes: 4

Views: 6849

Answers (3)

Codek
Codek

Reputation: 5164

Take a look at the open source tool called krex. It is written by Roland and very useful as it will export part or all of a database repo to Ktr and kjb files.

Best of all its a pdi job itself!

Upvotes: 1

FremenFreedom
FremenFreedom

Reputation: 519

Open from repository, then export to XML (under File menu). Name the exported file the same as the transformation name in the repository. The .ktr files are just XML.

To clarify: the .ktr files actually are XML. If you export the file as XML, but name it .ktr, you will be able to open and edit it with PDI/Spoon, etc.

Upvotes: 2

RFVoltolini
RFVoltolini

Reputation: 390

If you have a file based repository: when choosing which repository to connect to, press the edit button (a small pencil) and that will show you the "base directory". That's where your jobs/transformations reside. Be careful not to mess with those files.

If you have a database based repository, then for things like sending a couple of tranformations via email, then you should follow @FremenFreedom advice.

Upvotes: 1

Related Questions