Category Archives: Pentaho

Big Data, What is it Exactly? Datamensional’s Take

Posted on July 11, 2012 by joseph

Joseph A. di Paolantonio Benjamin B. Goewey Much of the current hype in Data Management & Analytics today is around the concept of Big Data, and Hadoop is at the center of the hype storm. The other two hot areas … Continue reading →

Posted in Big Data, Business Analytics, Data Integration, ETL, Pentaho, Pentaho Data Integration | Leave a comment

Xaction Basics – FTPing a file

Posted on March 20, 2012 by Benjamin Goewey

Here is another little xaction that demonstrates the FTP capabilities of xactions. Just like the last one, make sure to save it in the workspace directory for Design Studio so that it displays properly when you try to edit it. … Continue reading →

Posted in BI Server, Pentaho | Leave a comment

Xaction Basics – Sending an Email

Posted on March 15, 2012 by Benjamin Goewey

There are moments when working with the BI server that you will desire functionality that isn’t necessarily available through the server itself or any plugin that is currently out there.  In these situations, you will need xactions, which can be … Continue reading →

Posted in BI Server, Business Intelligence, Pentaho | Leave a comment

Fusion Charts in Pentaho Report Designer

Posted on March 8, 2012 by Benjamin Goewey

For those of you looking to add a little something extra to your Pentaho Report Designer reports, here are some steps to allow FusionCharts to be inserted directly into the report.  Of course, this is very format specific, and will … Continue reading →

Posted in Pentaho Report Designer, Reporting | 5 Comments

Using XMLA in Pentaho Reporting

Posted on March 6, 2012 by Gerrit Goewey

Anyone who has ever actually attempted it may have noticed that Pentaho Report Designer does not natively accept XMLA as a datasource.  It is still possible, and this little guide will step you through how to do this.  We used … Continue reading →

Posted in Analysis Services (SSAS), Microsoft SQL Server, OLAP, Pentaho Data Integration, Pentaho Report Designer | Tagged , | 2 Comments

Setting Up Logging Tables for PDI both Locally and on Server

Posted on February 28, 2012 by Benjamin Goewey

When running an ETL in Pentaho Data Integration (Kettle), logging is normally done in a log file on the local system.  When running an ETL through Carte or the BI server, it will add the information to their own separate … Continue reading →

Posted in Data Integration, Pentaho, Pentaho Data Integration | 1 Comment

Differences in Private versus Public Schedules using Pentaho User Console

Posted on February 23, 2012 by Benjamin Goewey

We get a lot of questions about the scheduling mechanism within the Pentaho BI Server and the differences between Public and Private Schedules. Update: Michael D’Amour of Pentaho informed me that the scheduling mechanism will be completely re-written in the Sugar release … Continue reading →

Posted in BI Server, Business Intelligence, Pentaho | 1 Comment

Pentaho SSO with CAS and LDAP: Tips and Notes

Posted on February 20, 2012 by Gerrit Goewey

After hearing various comments and setting up some more production implementations, I figured I would share some tips beyond the straight setup here. I will reserve the other post for keeping the basic instructions and use this one for any … Continue reading →

Posted in BI Server, Pentaho | Tagged , | Leave a comment

How to Use MySQL and Microsoft PowerPivot Together

Posted on September 5, 2011 by Benjamin Goewey

Overview This document shows how an Open Source Database like MySQL can be used with Microsoft’s popular Excel plugin PoweverPivot.  Many clients enjoy the familiarity of Excel and ease of use that PowerPivot brings but the clients do not want … Continue reading →

Posted in Business Intelligence, Microsoft, Mondrian, MySQL, OLAP, Pentaho, PowerPivot, Reporting | Tagged , , , , , , | 7 Comments

Pentaho SSO Setup using CAS and LDAP

Posted on July 19, 2011 by Gerrit Goewey

Hello.  Today I’m going to be discussing how to go about setting up SSO (Single Sign On) support for Pentaho using CAS (Central Authentication Service) and an LDAP (Lightweight Directory Access Protocol) Server.  By doing this, you can allow Pentaho … Continue reading →

Posted in Business Intelligence, Pentaho | Tagged , | 37 Comments