Pentaho

You don't need the Pentaho Server to schedule the execution of jobs and transformations.

You can work with files, not the Pentaho Repository (a better option in my opinion, as you can have a git repository with version control for your jobs and transformations), and use the SO tool in your server (cron with Linux, whatever you have available in your case) to schedule the execution of jobs (using kitchen.sh/bat) and transformations (using pan.sh/bat) or set up the carte server (I don't use it, so I don't know how it works, look for information about it)

WebSpoon is quite stable and some people are already using it in production, take a look at it.

Regards

If you do decide to go with SO level and GIT(lab)... might worth take a look at CI/CD pipelines... you can garantee that your source in production is the same on the version control and separate snapshots from production by CI a specifi branch do deploy/execute. Also you get a nice web frontend and alot of extra features.

Thanks Ana - we will take a look at that option.

Thanks David, will discuss internally.

Hi Ana/Davice,

After taking a look at webspoon this seems to be a graphical design tool which is not what we want – we would just like to schedule, parameterise  and run the transformations and nothing else. Does PDI alone provide this – is it possible to just install PDI and will the necessary tools be deployed as part of this installation?   

Thanks for you support.

Kevin

Yes, Kevin, with the PDI installation, along with spoon.bat, you have kitchen.bat (to run jobs without the GUI that spoon provides) and pan.bat, to run transformations, you can call them from a script and they'll run the job automatically.

Regards

For reference:

https://help.pentaho.com/Documentation/8.0/Products/Data_Integration/Command_Line_Tools