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.
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 […]
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 […]