Monday, 19 August 2013 16:45

Implementing Open Source BI

Written by 
Rate this item
(0 votes)

Implementing open source BI solutions

In current situation all the organization are moving from traditional business management processed to more informed, data based decision making system. This has helped several organizations to optimize their product, solutions or services and cut out unnecessary fat from expenses. A rupee saved is a rupee earned!!

Implementing open source BI solutions

 

In current situation all the organization are moving from traditional business management processed to more informed, data based decision making system. This has helped several organizations to optimize their product, solutions or services and cut out unnecessary fat from expenses. A rupee saved is a rupee earned!!

For having a more informed data based d{jcomments on}ecision making system, Organizations needs to strengthen their IT with Business Intelligence set up.

Today, in market there are several BI solutions available with known name as below:

  1. SAP solution with BODS, BOXI, BW
  2. ORACLE with Informatica, Oracle database
  3. IBM solutions with Data Stage, Cognos, DB2
  4. Microsoft Solutions

and many more to the list.

The above solutions are tried and tested but with a limitation for small or mid level organizations as the initial investments goes high and the profitability after application of solution is vague in the start.

The solution for the above limitation can be to start with Open Source tools as it can absorb the initial investment cost and provide a near equivalent environment to test the BI architecture and profitability for the organization.

The list of tools that can be used for the same can be as below:

  1. Database – MySQL
  2. ETL tool – Talend Forge TOS DI
  3. Reporting tool – iReport
  4. Report publisher – JasperServer

The above tools are just indicative and the solution can vary from time to time.

There can be two different strategies for using Open Source tools:

  1. Total Open Source implementation.
  2. Mid way solution

The mid way solution might be most effective for most organizations as they may be already having the database with them or the other essential tools to develop a BI solution.

Pros of using the Open Source tool:

  1. Provide a low investment start up
  2. Can be used for POC purpose and realize the real cost benefit of the investment.
  3. Can be continued for a longer run as well, until some real irresolvable or limitations are found.
  4. As open source tools can be modified as according to needs of organization makes them more robust.

Cons of using Open Source tool:

  1. Most of the cases no vendor support is available. However the fact of powerful open source community minimizes the risk.
Read 1745 times Last modified on Tuesday, 20 August 2013 11:24

Leave a comment

Make sure you enter the (*) required information where indicated. HTML code is not allowed.