![Page 1: ü Possible Pentaho Architecturecis.csuohio.edu/.../EnterpriseDatabaseSystems_Pentaho.pdf · 2016-08-30 · Data Layer – It can be used to connect to any data sources. Server Layer](https://reader034.vdocuments.us/reader034/viewer/2022050405/5f8295df16ec6b39d7681a08/html5/thumbnails/1.jpg)
29 | P a g e
ü Possible Pentaho Architecture:
![Page 2: ü Possible Pentaho Architecturecis.csuohio.edu/.../EnterpriseDatabaseSystems_Pentaho.pdf · 2016-08-30 · Data Layer – It can be used to connect to any data sources. Server Layer](https://reader034.vdocuments.us/reader034/viewer/2022050405/5f8295df16ec6b39d7681a08/html5/thumbnails/2.jpg)
30 | P a g e
The Pentaho Stack consists of 4 elements:
Presentation Layer – The data in Pentaho can be viewed either from a browser, portal,
office, and e-mail or web services. The data available in the presentation layer is through
reporting, analysis, dashboards and process management.
Business Intelligence Platform – It basically talks about security and repository.
Data and Application Integration – It is the integration layer of ETL.
Third Party Applications – Here the source database can be anything
Various Layers in Pentaho Architecture
![Page 3: ü Possible Pentaho Architecturecis.csuohio.edu/.../EnterpriseDatabaseSystems_Pentaho.pdf · 2016-08-30 · Data Layer – It can be used to connect to any data sources. Server Layer](https://reader034.vdocuments.us/reader034/viewer/2022050405/5f8295df16ec6b39d7681a08/html5/thumbnails/3.jpg)
31 | P a g e
Data Layer – It can be used to connect to any data sources.
Server Layer – it is the middle layer in Pentaho BI Architecture. The application runs on
server and serves as middle layer. They are BA Server, Pentaho User Console and Pentaho
Data Integration Server. We can deploy our report and dashboards and make it available to
the end user. User console is for the user role mapping, security and for configuring which
report should be shown to which user. The Pentaho Data Integration server runs the jobs and
transformations.
Client Layer – There are two types mainly:
Thin Client – Runs on server. Examples include, Community Dashboard Editor and Pentaho
Analyzer.
Thick Client – Runs as a Standalone. Examples include, Schema workbench, Report Designer
and Data Integration.
The aggregation designer is for the purpose of having consolidated data for reporting. The
metadata editor is for mapping physical database and business logic. Report designer is for
designing reports.
![Page 4: ü Possible Pentaho Architecturecis.csuohio.edu/.../EnterpriseDatabaseSystems_Pentaho.pdf · 2016-08-30 · Data Layer – It can be used to connect to any data sources. Server Layer](https://reader034.vdocuments.us/reader034/viewer/2022050405/5f8295df16ec6b39d7681a08/html5/thumbnails/4.jpg)
32 | P a g e
Some useful contents from following Some research on white papers :
http://www.slideshare.net/UdayK/business-intelligence-and-big-data-analytics-with-
pentaho
1) Pentaho Stack
![Page 5: ü Possible Pentaho Architecturecis.csuohio.edu/.../EnterpriseDatabaseSystems_Pentaho.pdf · 2016-08-30 · Data Layer – It can be used to connect to any data sources. Server Layer](https://reader034.vdocuments.us/reader034/viewer/2022050405/5f8295df16ec6b39d7681a08/html5/thumbnails/5.jpg)
33 | P a g e
2) Pentaho ETL
![Page 6: ü Possible Pentaho Architecturecis.csuohio.edu/.../EnterpriseDatabaseSystems_Pentaho.pdf · 2016-08-30 · Data Layer – It can be used to connect to any data sources. Server Layer](https://reader034.vdocuments.us/reader034/viewer/2022050405/5f8295df16ec6b39d7681a08/html5/thumbnails/6.jpg)
34 | P a g e
![Page 7: ü Possible Pentaho Architecturecis.csuohio.edu/.../EnterpriseDatabaseSystems_Pentaho.pdf · 2016-08-30 · Data Layer – It can be used to connect to any data sources. Server Layer](https://reader034.vdocuments.us/reader034/viewer/2022050405/5f8295df16ec6b39d7681a08/html5/thumbnails/7.jpg)
35 | P a g e
![Page 8: ü Possible Pentaho Architecturecis.csuohio.edu/.../EnterpriseDatabaseSystems_Pentaho.pdf · 2016-08-30 · Data Layer – It can be used to connect to any data sources. Server Layer](https://reader034.vdocuments.us/reader034/viewer/2022050405/5f8295df16ec6b39d7681a08/html5/thumbnails/8.jpg)
36 | P a g e
![Page 9: ü Possible Pentaho Architecturecis.csuohio.edu/.../EnterpriseDatabaseSystems_Pentaho.pdf · 2016-08-30 · Data Layer – It can be used to connect to any data sources. Server Layer](https://reader034.vdocuments.us/reader034/viewer/2022050405/5f8295df16ec6b39d7681a08/html5/thumbnails/9.jpg)
37 | P a g e
![Page 10: ü Possible Pentaho Architecturecis.csuohio.edu/.../EnterpriseDatabaseSystems_Pentaho.pdf · 2016-08-30 · Data Layer – It can be used to connect to any data sources. Server Layer](https://reader034.vdocuments.us/reader034/viewer/2022050405/5f8295df16ec6b39d7681a08/html5/thumbnails/10.jpg)
38 | P a g e
3) Data Exploration Using Pentaho
![Page 11: ü Possible Pentaho Architecturecis.csuohio.edu/.../EnterpriseDatabaseSystems_Pentaho.pdf · 2016-08-30 · Data Layer – It can be used to connect to any data sources. Server Layer](https://reader034.vdocuments.us/reader034/viewer/2022050405/5f8295df16ec6b39d7681a08/html5/thumbnails/11.jpg)
39 | P a g e
![Page 12: ü Possible Pentaho Architecturecis.csuohio.edu/.../EnterpriseDatabaseSystems_Pentaho.pdf · 2016-08-30 · Data Layer – It can be used to connect to any data sources. Server Layer](https://reader034.vdocuments.us/reader034/viewer/2022050405/5f8295df16ec6b39d7681a08/html5/thumbnails/12.jpg)
40 | P a g e
![Page 13: ü Possible Pentaho Architecturecis.csuohio.edu/.../EnterpriseDatabaseSystems_Pentaho.pdf · 2016-08-30 · Data Layer – It can be used to connect to any data sources. Server Layer](https://reader034.vdocuments.us/reader034/viewer/2022050405/5f8295df16ec6b39d7681a08/html5/thumbnails/13.jpg)
41 | P a g e
4) Exploring Big Data with pentaho
![Page 14: ü Possible Pentaho Architecturecis.csuohio.edu/.../EnterpriseDatabaseSystems_Pentaho.pdf · 2016-08-30 · Data Layer – It can be used to connect to any data sources. Server Layer](https://reader034.vdocuments.us/reader034/viewer/2022050405/5f8295df16ec6b39d7681a08/html5/thumbnails/14.jpg)
42 | P a g e
![Page 15: ü Possible Pentaho Architecturecis.csuohio.edu/.../EnterpriseDatabaseSystems_Pentaho.pdf · 2016-08-30 · Data Layer – It can be used to connect to any data sources. Server Layer](https://reader034.vdocuments.us/reader034/viewer/2022050405/5f8295df16ec6b39d7681a08/html5/thumbnails/15.jpg)
43 | P a g e
![Page 16: ü Possible Pentaho Architecturecis.csuohio.edu/.../EnterpriseDatabaseSystems_Pentaho.pdf · 2016-08-30 · Data Layer – It can be used to connect to any data sources. Server Layer](https://reader034.vdocuments.us/reader034/viewer/2022050405/5f8295df16ec6b39d7681a08/html5/thumbnails/16.jpg)
44 | P a g e
![Page 17: ü Possible Pentaho Architecturecis.csuohio.edu/.../EnterpriseDatabaseSystems_Pentaho.pdf · 2016-08-30 · Data Layer – It can be used to connect to any data sources. Server Layer](https://reader034.vdocuments.us/reader034/viewer/2022050405/5f8295df16ec6b39d7681a08/html5/thumbnails/17.jpg)
45 | P a g e
ü Big data kettle Transformation :- Data Integration
ü Install Data integration – Linux platform
Major steps: