This guide has been updated and works with the latest version of Pentaho BI Server 3.7.
Pentaho 3.7 with MySQL, PostgreSQL, Oracle and SQL Server.
Posted under BI Server, News, Pentaho, Tips, Tutorials
Pentaho 3.6 with Microsoft SQL Server
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.
Pentaho 3.6 with MySQL, PostgreSQL & Oracle.
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.
Customising the Pentaho User Console – Part 4.
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:
- Login page and dialog
- Messages
- Main toolbar, menu bar and logo panel
- Launch page (covered in this post)
In this post I will show you how to customise the launch page.
Emailing Reports from the Pentaho User Console.
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).
Customising the Pentaho User Console – Part 3.
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:
- Login page and dialog
- Messages
- Main toolbar, menu bar and logo panel (covered in this post)
- Launch page
In this post I will show you how to customise the main-toolbar, menu-bar, logo-panel and other features for the PUC.
Customising the Pentaho User Console – Part 2.
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:
- Login page and dialog
- Messages (covered in this post)
- Main toolbar, menu bar and logo panel
- Launch page
In this post I will show you how to customise messages for the login dialog and PUC.
Customising the Pentaho User Console – Part 1.
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:
- Login page and dialog (covered in this post)
- Messages
- Main toolbar, menu bar and logo panel
- Launch page
In this post I will show you how to customise the default login dialog and how to create a new login page.
Pentaho and the R Project.
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.
Publishing Content with Pentaho 3.5.
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.