Opening the transformation

Once you have opened Spoon you will see a window like the one shown here:


From this window you can create a new transformation (File/New/Transformation). Each transformation can do many things, we will not explain all the possibilities here. There is a Pentaho Community Wiki and there are quite a few book and tutorial videos on this stuff.

Transformations are stored in .ktr files and will need connections to a database to run. I have a local connection which I use to develop and test before I run any transformation using live connections to the CiviCRM database and the datawarehouse.