Wednesday, January 25, 2012
Utilize existing SQL Code for your Report Generation with Pentaho
I often get asked if developers can utilize SQL that they already use in their legacy reports within Pentaho and the answer is always a resounding YES! There are hardly if any companies out there that have not leveraged some type of Business Intelligence, even if it is generating csv files from a SQL query within a database. So there is a common concern when making any switch in technology, especially Business Intelligence/Analytics, and that is leveraging the work you have already done. here is a short video demonstration that show how easy it is to leverage Pentaho Report Designer to simply cut and paste your existing SQL code and how to extend that by parameterizing the report. Enjoy the video!