1
Open Source Business Intelligence
Overhyp
ed or
Underva
Web: www.tholis.com Email: jos<at>tholis.com Phone: +31-(0)6-51169606 Skype: tholis.jos
LinkedIn: jvdongen
Jos van Dongen
> 20 yrs BI
Principal Consultant
Author/Speaker/Analyst Proud member of #BBBT
OpenFlashCharts
JFreeReports
JPivot
Mondrian Java Server Pages
MySQL
7
The Industry Radar Screens
Forrester Wave for BI, Q4 2010
9
”
Open Source Everywhere
By 2012, 80 percent of all
commercial software will include elements of open-source
technology
Many open-source technologies are mature, stable and well supported. They provide significant opportunities for vendors and users to lower their total cost of ownership and increase returns on investment.
Ignoring this will put companies at a serious competitive disadvantage. Embedded open source strategies will become the minimal level of
investment that most large software vendors will find necessary to maintain competitive advantages during the next five years.
Gartner Group, 2008
What Customers Want Perceived as a Toy Overkill Disr uption Time
Open Source Disrupts the Market
Source: The Innovators Dilemma, Clayton Christensen
High demanding customers
What is Open Source? Formal:
1. Free Redistribution 2. Source Code
3. Derived Works
4. Integrity of The Author's Source Code
5. No Discrimination Against Persons or Groups 6. No Discrimination Against Fields of Endeavor 7. Distribution of License
8. License Must Not Be Specific to a Product 9. License Must Not Restrict Other Software 10. License Must Be Technology-Neutral
Informal:
13 Levels of Freedom Closed Commerial license Reciprocal Licenses 'Freeware' licences Academic Licenses
Licensing issues?
A:GPL B:BSD AB:GPL C:Closed AC:GPL BC:Closed15
Why Open Source?
Source:
Open Source Adoption in the BI Market
16% 18% 19% 21% 25% 28% 29% 32% 34% 72%
Lack of vendor service or support Higher costs than anticipated
Interoperability problems Lack of available consulting Reliability problems Difficulty finding available solutions Difficulty integrating into current environment Required more internal expertise than expected Scalability problems Missing or incomplete features
Problems Reported by Respondents
...And Why Not?
The biggest reason is maturity of the software. Source:
Open Source Adoption in the BI Market
19
Open Source Cheap? It depends...
Open Source BI Stack Maturity
Operating Systems, Application Servers, Programming languages
Information Integration Information Integration EII EAI ETL Data Management Data Management
DBMS Profiling Data Quality Modeling MDM (Advanced) Analytics
(Advanced) Analytics
Text Mining
Data Mining Statistics Visualization Information Delivery & Presentation
Information Delivery & Presentation
Office
Portals GIS Search
Reporting & Analysis
Reporting & Analysis
21
#BigData, the new frontier
23
The 'BIG 4'
⇨ Palo, Jaspersoft & Pentaho: Community &
Professional/Enterprise Editions
⇨ SpagoBI only real FOSS platform
⇨ Is licensed under LGPL (Yes, that's LGPL)
⇨ Has integrated DTAP migration tools
25
End to End BI Reporting Operational, Production Embedded Web-based Ad-hoc Analysis
Interactive slice, dice, and drill Web-based or Excel
Dashboards
KPIs
Mash-ups
Data Integration / ETL Data Mining
BI Platform
Scheduling & bursting Notification
Content sharing Security integration
27
29
31
33
Palo OS Ecosystem
PALO Jpalo client Jpalo web client PalOOCa plugin35
Antonius Intelligence & Open Source BI Staging Area CSV Files ETL ERP DBMS
Sources ETL Process Data Warehouse EUL
MySQL Files ETL: Kettle Data Vault Frame work Central DWH & Data Marts MySQL Data Vault ETL
DWH Data Mart ODS End user Virtual Data Mart
Type 1 Type 2 Type 4 Type 5 Type 6
Staging
Data Mart
MetaData Layer (ad hoc/standard reports) or cube (analysis) (Self service) Reporting, PDF's etc..
Type 3
LotX data
Post ICU poli Cardio. BRS Benchmarks ... OK / SEH iSoft KPI Dashboard
Tailor-made information delivery
37
Data modeling & ETL
Power*Architect
Pentaho Data Integration (Kettle)
Antonius Intelligence KPI's Dashboards: C** tools
39
Is Open Source BI for you? ⇨ Business Case ⇨ BI Maturity ⇨ Internal Skills ⇨ Culture ⇨ Infrastructure ⇨ Applications ⇨ Vendors Support Partners CSF No 1! OR ?
41
Recommendations
1.Don't focus solely on cost savings.
People did not mention as up-front reasons many of the benefits they discovered later.
2.Plan to augment, not replace,
existing software with open source.
Rather than trying to saving money by replacing software, look at gaps in the BI portfolio or data warehouse stack and use open source to supplement your systems.
Recommendations
3.Consider developing open source
policies. Most organizations are
adopting open source in an ad-hoc fashion, project by project.
4.Evaluate open source like any
other software. It doesn't matter if
the software is free if it takes longer to build, manage and deploy
solutions to end users, if it is unstable, or if it is missing a key feature
5.Make open source the default
option. When there are no internal
tools, open source should be the first alternative.
