Posted under BI Server, Pentaho, Tutorials
Yep, you read right, I have now updated the guide so that it now includes Microsoft SQL Server 2005+. Big thanks goes out to Roland Bouman who sent me the necessary configurations files and drivers needed for this to work, so head over to his blog and give him a hug or just thank him.
You can grab a copy of the guide in Google Docs format and the SQL Script Pack at the projects page.
As always please let me know if you find any errors and also if you would like to see any further additions to guides and support for other databases.
Prashant.
Posted by
Prashant Raju on Aug 30, 2010 —
6 Comments
Posted under BI Server, Open Source, Pentaho, Tutorials
Updated 16/06/2010
This guide has been tested and works with the latest version of Pentaho BI Server 3.6.
Read the rest of this entry»
Posted under BI Server, Open Source, Pentaho, Tutorials, User Console
This post is part 4 of the series “Customising the Pentaho User Console (PUC)” Version 3.5.x. Here is a list of what I have covered in other parts:
In this post I will show you how to customise the launch page.
Read the rest of this entry»
Posted under BI Server, Open Source, Pentaho, Tutorials, User Console
With the recent release of Pentaho’s BI Server 3.5.2 and Tom Barber’s (aka magicaltrout) post I thought I would put together a quick tutorial on how to use a new feature of 3.5.2 which allows end users to email reports directly from the Pentaho User Console (PUC).
Read the rest of this entry»
Posted under BI Server, Open Source, Pentaho, Tutorials, User Console
This post is part 3 of the series “Customising the Pentaho User Console (PUC)” Version 3.5.x. Here is a list of what I have covered in other parts:
In this post I will show you how to customise the main-toolbar, menu-bar, logo-panel and other features for the PUC.
Read the rest of this entry»
Posted under BI Server, Open Source, Pentaho, Tutorials, User Console
This post is part 2 of the series “Customising the Pentaho User Console (PUC)” Version 3.5.x. Here is a list of what I have covered in other parts:
In this post I will show you how to customise messages for the login dialog and PUC.
Read the rest of this entry»
Posted under BI Server, Open Source, Pentaho, Tutorials, User Console
For the past couple of weeks I have been playing around with customising the Pentaho User Console (PUC) Version 3.5.x and to follow it up I thought I would put together a multi-part post on the topic. Each post will cover one aspect of customising the PUC, these include:
In this post I will show you how to customise the default login dialog and how to create a new login page.
Read the rest of this entry»
Posted by
Prashant Raju on Feb 14, 2010 —
9 Comments
Posted under BI Server, Open Source, Pentaho, R
I’m not sure if everyone is aware of this as the recording was released last year but the team at OpenBI have been able to integrate R and Pentaho Business Intelligence Server. The screen cast, which you can view here, was demoed with version 2.0 of the server but I don’t see why it wouldn’t work with version 3.5 (correct me if I’m wrong). The screen cast goes into detail on how the connection between Pentaho and R-Project works and what packages/libraries you will need to get it setup and running.
For those of you who don’t know:
R is a free software environment for statistical computing and graphics. It compiles and runs on a wide variety of UNIX platforms, Windows and MacOS
Along with Weka, R is definitely a tool that I believe all analysts should have handy when performing statistical related tasks.
Enjoy.
Posted by
Prashant Raju on Jan 27, 2010 —
2 Comments
Posted under BI Server, Open Source, Pentaho, Report Designer, Tutorials
For those starting out with Pentaho it can be confusing on how to publish content (reports, ETL jobs etc.) to Pentaho Business Intelligence (BI) server. I have put together a guide which outlines the steps you will need to enable publishing and also an example of how you can use Pentaho Report Designer (PRD) to publish reports.
Read the rest of this entry»
Posted under BI Server, Open Source, Pentaho, Report Designer
I was about to do a chapter by chapter review of Roland Bouman and Jos van Dangen‘s masterpiece “Pentaho Solutions – Business Intelligence and Data Warehousing with Pentaho and MySQL” but since I started reading it I haven’t been able to put it down. It is definitely a must for anyone who is interested or currently working with Pentaho.
Because this book just oozes with awesomeness I have been able to shorten my review to three words “buy it now“.
Enjoy.
Posted by
Prashant Raju on Jan 17, 2010 —
3 Comments