It’s tricky but the short answer is yes, sorta. There are certain limitations, of course, but with some creative problem solving, you can do quite a bit with this ETL tool.
Pentaho
12 posts
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 are Mobile & Elastic Cloud Computing. Cloud is central to […]
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. Open the ftp_prpt_report_w_parm.xaction file in Design Studio (Eclipse). You will […]
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 a little intimidating at first glance. For this reason, we’ll […]
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 only work with HTML. Download, Setup, and Test on Pentaho […]
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 MSSQL 2008R2 with the standard Adventure Works example data loaded. […]
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 local log file. These directions will allow the log information […]
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 which is the next generation of the Pentaho Suite. The […]
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 additional notes as I come across them. Version compatibility Many […]
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 to married with any one particular vendor in their Business […]