PDA

View Full Version : Data Integration Output File Content w/ Xaction BI Platform



dhartford
04-27-2007, 10:16 AM
Reference: http://forums.pentaho.org/showthread.php?p=159491

A fixed-width data file, already in place and created in Data Integration (kettle). Unable to send that file back out through as Xaction output.

dhartford
05-21-2007, 11:15 AM
2nd note after more testing - the requirement is for fixed-width report from a datastream (identified errors during scrubbing/validation report on a fixed-width file in a defined way...not the Kettle errors, but ModJS defined error codes).

Using a Kettle result-set with an XACTION to create a fixed-width report has been challenging. JfreeReport finds it very challening to do fixed-width, but is feasible with careful deliberation outside of the Designer. BIRT also can do fixed-width supposedly, but I personally would be going through a new learning curve and choose not to go down that route.

In the end, just wrote the fixed-width file from Kettle to a disk location by convention, and read the file and just sent the stream back through the browser with a servlet.

Hopefully in the future problem/challenges like this can become easier.