Pentaho Community Edition 3.5.0

-

Pentaho Community Edition 3.5.0

The Pentaho BI Suite Community Edition [CE] is an open source business intelligence package that includes ETL, analysis, metadata, and reporting capabilities. The suite is composed of server components and client tools. The server components [also referred to as the BI Platform] consist of the BI Server, the administration console and the user console. The BI server is responsible for management and delivery of reports.


Some of the Pentaho client tools include:


Report Designer: Used to create formatted reports. Report Designer offers far more flexibility and functionality than the ad hoc reporting capabilities of the Pentaho User Console.


Design Studio : An Eclipse-based tool that enables you to hand-edit a report or analysis view xaction file. Generally, people use Design Studio to add modifications to an existing report that cannot be added with Report Designer. Design Studio is also required to enable report scheduling, e-mail distribution, dynamic and static prompting, and more.


Metadata Editor: Enables you to add a custom metadata layer to an existing data source.Usually you would do this for a data source that you intend to use for analysis or reporting; it's not required, but it makes it easier for business users to parse the database when building a query.


Pentaho Data Integration: Also known as Kettle. An extract, transform, and load (ETL) tool, which enables

you to access and prepare data sources for analysis, data mining, or reporting.


Schema Workbench : A graphical tool that helps you create ROLAP schemas for analysis



Required :
  1. version of Java JDK (1.5 or greater) installed on your computer/server.
  2. download SQL Script Pack (MySQL, Oracle 10g or 11g , PostgreSQL 8.x.x) database which you are setting up Pentaho link2 link1
  3. to download is the pentaho-ce-3.5.0.stable.zip
See also
  • http://forums.pentaho.com/showthread.php?72921-Pentaho-3.5-stable-is-now-available-on-SourceForge.

Comments

Post a Comment

Popular posts from this blog

Changing the Java VM Memory Limits in Pentaho BI

-
You can find docs biserver-ce\tomcat\webapps\pentaho\docs\ Changing the Java VM Memory Limits If you are running out of memory even though your server has a lot of RAM, you probably need to increase the resources allocated to the JRE instance that runs the Pentaho software you're trying to improve performance on. Adjusting the memory limit is an easy configuration change to make, but the instructions differ depending on the client tool or Web application server you're using. Refer only to the sections below that apply to your situation. Note: If you are running multiple Pentaho programs concurrently, the sum of their JVM maximum memory limits must not exceed the available RAM minus system overhead. Increasing Memory Limits on Microsoft Windows with a Graphical Installation By default, Tomcat has a relatively low memory allotment. This can cause out-of-memory errors in the BA Server fromtime to time. The below instructions will explain how to increase the mem
Read more

error in pentaho 5.0.1 - authentication via url parameters for iframe

-
After passing userid and password in URL and page load it ask for user and password, seems pentaho server does not recognize the parameters. check here for the workaround (it's on the comments):  http://jira.pentaho.com/browse/BISERVER-10708 Workaround is to edit the system/applicationContext-spring-security.xml file and change the parameters for the filterChainProxy. Lines 22 and 23 should be replaced by:         /api/**=securityContextHolderAwareRequestFilterForWS,httpSessionPentahoSessionContextIntegrationFilter,httpSessionContextIntegrationFilter,requestParameterProcessingFilter,basicProcessingFilter,anonymousProcessingFilter,exceptionTranslationFilterForWS,filterInvocationInterceptorForWS         /plugin/**=securityContextHolderAwareRequestFilterForWS,httpSessionPentahoSessionContextIntegrationFilter,httpSessionContextIntegrationFilter,requestParameterProcessingFilter,basicProcessingFilter,anonymousProcessingFilter,exceptionTranslationFilterForWS,filterInvocationInterce
Read more

CAS with Pentaho Community Edition

-
In this week I integrate one of the most useful feature i.e. CAS (Single Sign on) with the help my collegue and online user community . So with my boss’ blessing, I decided to document what I had to do to make this work in the spirit of giving back to the community. Plus with the rising awareness of the benefits of BI even for small to medium corporations, I have no doubt that this information would be useful for someone somewhere. The need 1) CAS Server 2) Pentaho BI 3.x server (Community Edition) 3) Install certificate IMPLEMENTATION OF CAS CLIENT IN PENTAHO BI SERVER 1) \biserver-ce\pentaho-solutions\system\applicationContext-spring-security.xml make changes in applicationContext file for CAS Client. and add following jars in biserver-ce\tomcat\webapps\pentaho\WEB-INF\lib folder 1) spring-security-cas-client-2.0.5.RELEASE.jar 2) cas-client-core-3.1.10.jar After added jars and configuration in applicationContext file then install certificate step-1) download
Read more