I am using PRD (Pentaho Report Designer) to build few PDF reports. So far I used to generate hundreds of reports manually from Pentaho BI server and that was my big time consuming task. I came across new transformation output step in kettle “Pentaho Reporting Output” which helps in automating the report generation.
Initially I was trying to integrate PRD 3.8.x prpt file with PDI (aka kettle) 4.3 and could not make it work. Later on with the help from pentaho forum, it is found that all the family are typically not inter-compatible with all versions, esp. backward compatibility can be issue sometime. The simple reason for this would be cost as it is community edition. When I created report with latest PRD 3.9, I could integrate it with Kettle without any hassle.
Jaspersoft and Pentaho are two leading open source BI solutions available in the market. But I found Pentaho family more matured as they have fantastic integration support with all the leading market solutions in this area like palo, hadoop, mongoDB, Cassendra just to name a few. Also its tools are grown organically like their ETL tool data integration aka Kettle.I think even though Pentaho does not have very good support for eclipse plugin, overall as a BI solution it has tremendous potential to become an enterprise level solution easily.
Manoj Patil Chief Architect, Big Data Analytics. Manoj comes in with 13+ years of well-rounded experience in architecting and implementing solutions for various enterprises across verticals such as Data Analytics, Supply Chain Management, BI, Payments, Life Sciences etc. He loves working on solutions for Big Data customers using different cloud services. Prior to joining Compassites, Manoj had worked in various roles including programmer, project manager, delivery manager with the organizations like Talentbea Inc, Persistent Systems and Vmoksha Technologies.