Tuesday, May 31, 2011

Configuring Pentaho to use LDAP

Before you Begin

The following tutorial should be used to setup a simple reference implementation of the Pentaho BI Server configured with LDAP authentication. The prerequisites needed in order to be successful with this tutorial include an existing installation and usage of the Pentaho BI Server and Enterprise Console, a simple understanding of LDAP and the ability to follow standard installation procedures using install wizards. The tutorial is represented from a Windows operating system perspective, but is applicable across multiple platforms. It is recommended that you get the reference implementation working successfully before configuring your Pentaho BI Server to use your own LDAP configuration.

The rest can be found here at the Pentaho Evaluation Sandbox.


Saturday, May 21, 2011

Spatial Reporting with Pentaho and Google Maps

Pentaho Experience Level: Medium to Advanced

Spatial or also known as Geographical Reporting, is a great way to answer the question: "Where are my....(fill in the blank here)?" It is a great way to visualize the spatial or location component of your data (Latitude, Longitude, Country, County, Region, City, State, Zip Code etc). It can also tell you where the lowest or highest concentration of a desired metric may lie with the use of color gradients or conditionally styled points. The ability to drill in even deeper, allows you to eliminate the surrounding areas and focus your attention on the areas that may need it most. The Pentaho BI Platform can take advantage of 3rd party visualization solutions such as the Google Maps API and integrate it as a component that can be used with the Pentaho User Console.

Read more and come see and example in action here: http://sandbox.pentaho.com/samples-and-examples/samples-and-examples/dynamic-google-maps-widget/


Michael Tarallo
Director of Sales Engineering

Monday, May 9, 2011

Unlocking Non-Relational Data with Ease

Pentaho Reporting can easily access data from many different sources; sources such as your traditional RDBMS, and even more advanced sources such as Java, XML, OLAP and our own Pentaho Data Integration transformations. Download these brief instructions (.doc) or watch the Techcast to learn how easily you can use a Pentaho Data Integration Transformation as a data source within the Pentaho Report Designer to unlock the power of non-relational data.

View the Techcast here.

Download document AND sample .ktr and .prpt files here.

To use the sample:

  • Unzip *.zip file

  • Copy Files to temporary folder

  • Use Report Designer and Open the PRPT file (the .ktr is already embedded in it)

  • Preview

  • Publish to Pentaho User Console as you would with any other Pentaho Report

  • Optional: Import .ktr file into PDI to see the simple transformation

Contributed by,

Wayne Johnson
Senior Sales Engineer

Originally posted on the Pentaho Evaluation Sandbox: