Teachers

Hello Guys,

Here is a small document prepared on differentiating Pentaho Open source Vs Jasper Professional.

Based on the below information one can take decision on tool selection for BI needs.

I would like to present a clear picture with insight & readers of this document are encouraged to add your points in the comment box..

IMP NOTE:  Remember , I am comparing the Pentaho Open source(Community) 5.0.1 stable  with Jasper Professional(licensed) 5.5 

Dashboards :

Key feaute	Pentaho Open source Dashboard	Jasper Professional dashboard
Tool	Community Tools(C-Tools) – Server plug ins CDE(Community Dashboard Editor) CDF(Community Dashboard Framework) CDA(Community Data Access)	iReport/Jasper Studio Desktop stand alone tools
Development of Reports done at	Fly on the server itself	Depends on stand alone designing tools & need to publish to the server and again need to design the dashboard
Responsiveness /Mobile support	Responsiveness is achievable using bootstrap css framework	Lack of responsiveness even though there is Proprtional property of the dashboard designer
Dashboards output end view-able devices	Compatible with Mobile/iPad/laptop/Desktop/TV like big screens	Compatible with laptop/desktop
Charts	Protovis charts implemented, extend able to D3 charts.. can integrate fusion and HTML charts also.	Embedded charts engines – Jfree, Fusion & HTML5 charts. Can integrate protovis/D3 charts using html component of iReport/Jasper Studio
Loading of charts on the dashboard	Will take lesser time using Pentahos powerful caching mechanism	Will take longer time to load the charts on the dashboard
Embedding BI	Achievable using iframe tags	Achievable using iframe tags
Community support	Active	Active as it is a professional .. general community is not so active
Interactivity/Drill down/ Inter charts(frames) communication	Achievable	Achievable
Multi-tenancy	Need to check (will update on this)	Achievable
Customization	Developer friendly	Not developer friendly
Download here	Pentaho Maket Place or install using ctools-installer.sh http://community.pentaho.com/	Purchase license https://www.jaspersoft.com/jaspersoft-business-intelligence-software-trial

Key feature	Pentaho Open source Analysis	Jasper Opensource/Pro Analysis
Desktop Stand alone Development Tool	Pentaho Schema workbench	Schema Workbench
Front End tool to view the output	Pviot4J Analytics (or) Saiku Analytics (or) JPivot View (or) BTable (or) Ivy Schema Editor	JPivot View
Ad-hoc Reporting on Cube ouptut	Yes, using Saiku Analytics	Ad-hoc Editor (For jasper pro & enterprise it is an add-on feature. http://www.jaspersoft.com/editions
Query Language	MDX ( Multi Dimensional Expression)	MDX (Mullti Dimensional Expression)
Caching	Enabled – Very fast access of data	Enabled – some what less speed when compared with pentaho server
Community Support	Very Active – Quick Responses	Not so active as it is not a owned product of jasper/tibco
Documentation	Online documentation available with examples	Online pdf documentation is available with Examples

Key feature	Pentaho Open source Ad-hoc	Pentaho Enterprise Ad-hoc	Jasper Pro Ad-hoc
Source for ad-hoc reporting	Meta data layer creation	Meta data layer creation	Create topics OR Create Domains
Tool	Pentaho Meta Data Editor(PME) (Stand alone desktop tool) (OR ) Create JOINS on the fly on the server and use it for ad-hoc reporting	PME	No desktop tool.. directly in the server create Domains OR topics
Output Server tools	WAQR – Web Ad-hoc Query and Reporting (OR) Saiku Reporting compatible with 4.8 server as of now	Interactive Reporting - Advanced of WAQR But WAQR is not supported by any more Interactive reporting is an extension of WAQR in Enterprise Version of pentaho	Jasper Ad-hoc Editor
Support	Deprecated – No longer supported by penatho	On demand support	On demand – Need to be jasper customer
Visualization of Data in the form of charts	No	No	Yes .. using Ad-hoc report output visualization of data in the form of selected charts .

Hi Guys,

Below tip is used for disable Edit Mode of CDE dashboards ..

When this is useful ?
CASE 1 : 
If you are not going for Embedding BI to integrate the CDE dashboards.

CASE 2: 
If you dont want your end user to open the CDE file to view the CODE.. If you are using the Server itself in your end client location he/she also may not need all these except logging into the server and see the dashboards...

For doing this.. i.e., to disable the Edit mode of CDE dashboards, you just need to comment below code in plugin.xml file of pentaho-cdf-dd folder.

File location : /home/sadakar/softwares installed/Pentaho/biserver-ce/pentaho-solutions/system/pentaho-cdf-dd

<!--
                <operation>
                    <id>EDIT</id>
                    <perspective>wcdf.edit</perspective>
                </operation>
-->

Sample Image:


NOTE: As it is a configuration file, you need to restart the server once the changes done to it.

Another Imp NOTE: 
As C-Tools(CDE,CDF,CDA) are uneatable from Marketplace, and if you go for any upgrade of them then you might lost this configuration.. what itll do internally when you upgrade to new versions of C-Tools, internally itll uninstall the plug-ins and then download the new.. hence as you will get a fresh copy you there might be a chance of losing your settings.. This is not tested..

Thank you :-)

Sadakar
BI developer
Pentaho/Jasper/Talend ETL