Thursday, August 21, 2014

Optimizing the Value of Information Technology Investments

Recently, a client ask me if I consider using Open Source software for support “Business Intelligence” needs, which question I answer: it’s possible, but the Open Source system provides less functionalities to specific problems. 

As it’s well known, OBIEE is, for me, the Flagship of Flagships that continues its strong growth year over year. So, thanks to acquisition of Siebel, Oracle provides a friendly and high quality application that stay on top of “Business Intelligence” technologies.
 

Anyway, needless to say that the licensing is an intangible cost involved in commercial products. In this way, I focus on reaching ways of cutting costs, ensuring that information system is efficient according business requirements.
 

The usage of Open Source software as alternative for commercial products may cause nightmare, not only because of support that you can expect after buying a license, but also because of software requirements of businesses.
 

Notice that a solution could be combining  commercial  software with open-source applications. So, “Pentaho Report Design” (OpenSource) allows create custom reports using Oracle Database (commercial product).

In this way, within “Pentaho Report Design” include the SELECT statement, such as in the screenshot below:



Once is included and customized, click on “Print” > “PDF” and you could save the Report as PDF, just as in the screenshot below.


Best wishes.
Joan Martí Peraire.