Expanding a Crosstab in Jaspersoft iReport Designer

To create a crosstab report (sometimes called a "Pivot Table") in Jaspersoft's iReport Designer, simply drag a Crosstab component from the palette to a Summary band and configure through the wizard.  However, if you need more than 2 row or 2 column groups in the crosstab, you'll need additional configuration.

Handling an Empty JSON Object in Talend Open Studio

To input JSON into a flow using Talend Open Studio, use the tFileInputJSON component.  If the JSON input may be empty, use a guard condition that examines the structure beforehand.

[AUDIO] Integration Tools Podcast, Episode 24: Talend. IBM. Pentaho. Queplix. Oracle.

Episode 24 of the Integration Tools Podcast is available. The podcast is on integration tools' product releases, research, and events. Episode 24 covers Talend, IBM, Pentaho, Queplix, and Oracle.

Headlines

• Talend ESB Studio Released
• Pentaho BI 4 Enterprise Edition Released
• IBM Netezza High Capacity Appliance Available
• Queplix Data Quality Manager Released
• Oracle Datanomic Webcast Scheduled

Spend one or two minutes a week to keep on top of the data integration tools market.

Integration Tools Podcast Episode 24 

For more podcasts, visit http://www.bekwam.com.

Processing Files with Headers and Footers with Talend Open Studio

Talend Open Studio uses wizards to define schemas for text and Excel files.  However, the wizards aren't sufficient for processing a complex file containing a header or a footer.  Use Java to build a state table that will route the different sections of the file to the correct target.

Dynamic Schemas in Talend Open Studio

When working with input data from a source like a spreadsheet, which is subject to editing by users, you can't always count on a strict format.  For instance, the columns may be reordered.  But if the spreadsheet contains column headers that are still accurate, you can map it to a schema using Talend Open Studio.

Streaming a PDF Jasper Report Using JSP

To create a PDF report use Jaspersoft's iReport Designer to save off static content.  To parameterize and invoke the report on-the-fly, use a JSP container like Tomcat.

[AUDIO] Integration Tools Podcast, Episode 23: CloverETL. Pitney Bowes. Informatica. Progress Software. expressor. Kapow.

Episode 23 of the Integration Tools Podcast is available. The podcast is on integration tools' product releases, research, and events. Episode 23 covers CloverETL, Pitney Bowes, Informatica, Progress Software, expressor, and Kapow.

Spend one or two minutes a week to keep on top of the data integration tools market.

Integration Tools Podcast Episode 23

For more podcasts, visit http://www.bekwam.com.

Manipulating Oracle XMLType with Talend Open Studio

Use the Advanced settings for a tOracleOutput component in Talend Open Studio to issue XML commands like APPENDCHILDXML and DELETEXML

[AUDIO] Integration Tools Podcast, Episode 22: Talend. Informatica.

Episode 22 of the Integration Tools Podcast is available. The podcast is on integration tools' product releases, research, and events. Episode 22 covers Talend and Informatica.

Spend one or two minutes a week to keep on top of the data integration tools market.

Integration Tools Podcast Episode 22

For more podcasts, visit http://www.bekwam.com.

Validating XML with Talend Open Studio

Use the tXSDValidator component to check a local XML file against an XSD.  Or, specify "Flow Mode" to validate a flow-driven Column containing XML.

schemaLocation in Enterprise Architect

To set a schemaLocation in an XSD developed in Sparx Systems' Enterprise Architect, use the Tagged Value on an XSDSchema element.

BRules 1.0 Released for Talend Open Studio

BRules is a collection of routines for Talend Open Studio, that validates, converts, and shortens Java expressions.

Test-Driven Development of Talend Open Studio Routines

A Talend Open Studio Routine is a collection of functions used for expressions in components like tMap or tRowGenerator.  If you develop custom routines, consider a test-driven methodology for the best quality, especially if making the routines available to the community on the Talend Exchange.

[AUDIO] Integration Tools Podcast, Episode 21: Talend. Syncsort. Safe Software.

Episode 21 of the Integration Tools Podcast is available. The podcast is on integration tools' product releases, research, and events. Episode 21 covers Talend, Syncsort, Safe Software.
Spend one or two minutes a week to keep on top of the data integration tools market.

Integration Tools Podcast Episode 21

For more podcasts, visit http://www.bekwam.com.