Avoiding Circular References in the Play! Framework

If you're producing JSON in a Play! Framework app, watch for circular references caused by bi-directional JPA relationships.  Use a custom JsonSerializer to break the cycle.

[AUDIO] Integration Tools Podcast, Episode 33: Informatica. Queplix. SnapLogic. DataFlux.

Spend one or two minutes a week to keep on top of the data integration tools market. Episode 33 of the Integration Tools Podcast is available. The podcast is on integration tools' product releases, research, and events. Episode 33 covers Informatica, Queplix, SnapLogic, and DataFlux.

Integration Tools Podcast Episode 33

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

Inheritance in the Play! Framework

In the Play Framework, model classes inherit from GenericModel if they provide their own @Id, or Model (if they don't).  When your model classes share fields that are expected to be saved, use a mapped superclass (@MappedSuper class).

A List of DDL Statements with tFixedFlowInput

If you have a list of several DDL statements that you'd like to run as part of a Talend Open Studio job, use  tFixedFlowInput to define a list and feed the list into a database row component like tMysqlRow.

[AUDIO] Integration Tools Podcast, Episode 32: Fusesource. Queplix.

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

Integration Tools Podcast Episode 32

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

Controlling Row Output in Talend Open Studio Components

Most of the Talend Open Studio components I've read about support a one-to-one correspondence between input and output.  That is, for each input row, a single output row is written to an outgoing connection.  However, components like tSplitRow will write more than one output row to a connection.

Providing Your Own MySQL @Id Column in the Play! Framework

When you create Model entities in the Play! Framework, Play will provide a default id column.  If you need to use your own id column -- say if you are given a database schema to work with -- then you should extend a different Play class.

Three Levels XML Nesting in Talend Open Studio

To output a complex XML document with multiple nested structures, first write a denormalized query then route the main flow to Talend Open Studio's tAdvancedFileOutput component.

[AUDIO] Integration Tools Podcast, Episode 31: MUST LISTEN! Informatica Data Masking. expressor.

Spend one or two minutes a week to keep on top of the data integration tools market. Episode 31 of the Integration Tools Podcast is available. The podcast is on integration tools' product releases, research, and events. Episode 31 covers the Informatica's important Dynamic Data Masking product and expressor's systems integrator partner program.

Integration Tools Podcast Episode 31

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

[AUDIO] Integration Tools Podcast, Episode 30: expressor. Gartner Data Quality Tools Report.

Spend one or two minutes a week to keep on top of the data integration tools market. Episode 30 of the Integration Tools Podcast is available. The podcast is on integration tools' product releases, research, and events. Episode 30 covers expressor and the Gartner Magic Quadrant for Data Quality tools..

Integration Tools Podcast Episode 30

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

Deploying a Report to JasperReports Server - Web Client

Tutorial showing the deployment of a JasperReport created in iReport Designer to a JasperReports Server; admin notes for configuring DataSources

Upgrading Talend Open Studio

To upgrade Talend Open Studio, install the new copy and import the previous version's workspace.