Transcription
üPossible Pentaho Architecture:29 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 throughreporting, 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 anythingVarious Layers in Pentaho Architecture30 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 onserver and serves as middle layer. They are BA Server, Pentaho User Console and PentahoData Integration Server. We can deploy our report and dashboards and make it available tothe end user. User console is for the user role mapping, security and for configuring whichreport should be shown to which user. The Pentaho Data Integration server runs the jobs andtransformations.Client Layer – There are two types mainly:Thin Client – Runs on server. Examples include, Community Dashboard Editor and PentahoAnalyzer.Thick Client – Runs as a Standalone. Examples include, Schema workbench, Report Designerand Data Integration.The aggregation designer is for the purpose of having consolidated data for reporting. Themetadata editor is for mapping physical database and business logic. Report designer is fordesigning reports.31 P a g e
Some useful contents from following Some research on white papers ence-and-big-data-analytics-withpentaho1) Pentaho Stack32 P a g e
2) Pentaho ETL33 P a g e
34 P a g e
35 P a g e
36 P a g e
37 P a g e
3) Data Exploration Using Pentaho38 P a g e
39 P a g e
40 P a g e
4) Exploring Big Data with pentaho41 P a g e
42 P a g e
43 P a g e
44 P a g e
üBig data kettle Transformation :- Data IntegrationüInstall Data integration – Linux platformMajor steps:45 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.
