I have a task to find out a way to deploy Pentaho BI CE server, Kettle jobs/transformation from testing to production environment servers.
It is pretty clear how to deploy Pentaho BI server, but the problem is that I do not have clear understanding how can I transfer all my data (Schemas, CDE dashboards, Saiku queries etc.) from one environment to another. Should I download all data and just upload to production server? But that does not seems to be viable solution.
For Kettle jobs/transformation the best approach would be to use repositories, but I still can not figure it out how it could be moved from testing to prod environments.
So my question is - what is the best approach to deploy Pentaho to different environments?
P.S. I am still very new to Pentaho and all BI stuff, so if I made some technical mistakes, please correct me.