Pentaho is a really nice tool if opensource is the only option.  Please think about issues such as upgrade and disaster in the future. These operations are very easy in Pentaho. I can only suggest one thing for replication and that is Qlik. (ex-Attunity).