Featured Post

Applying Email Validation to a JavaFX TextField Using Binding

This example uses the same controller as in a previous post but adds a use case to support email validation.  A Commons Validator object is ...

Saturday, December 31, 2011

Top Ten Timesaving Talend Tips of Two Thousand Eleven: Part 1

The end of the year is the season for lists and I just listened to the S's in the complete Beatle's catalog on the radio.  Here are 10 timesaving tips for Talend Open Studio for Data Integration that I used in 2011.

Wednesday, December 28, 2011

tMSSqlLastInsertId Returns 0

If you've built a Talend Open Studio job that inserts records into a multiple MS SQL Server tables, you can use the tMSSqlLastInsertId to retrieve the value of an auto-incremented IDENTITY column set in a prior insert.

Wednesday, December 21, 2011

NamespaceHandler Error Using Spring Batch

After running Spring Batch programs in an IDE (Eclipse, IBM RAD), you may notice a NamespaceHandler error when you attempt to run the programs from an exported Runnable JAR.

This error is caused by the archiving process which overwrites the /META-INF/spring.handlers file found in a number of the Spring JARs.  Through the IDE, these handlers are additive; each JAR's META-INF resources are added to the classpath.  However, the Runnable JAR process will put only a single spring.handlers file on the classpath which is the last one in the Order / Export window in the IDE.

The solution is to prepare a comprehensive spring.handlers file and update the JAR after all of the archiving is completed.  This can be done manually, with a script or Ant task, or by packaging your own JAR containing only your finalized /META-INF resources.  If you go the JAR route, make sure this JAR is last in the Order and Export window.

Sunday, December 18, 2011

Creating a SQL Server Identity Column with Talend Open Studio

Talend Open Studio for Data Integration will execute table-creating DDL as part of a data transformation.  When using Microsoft SQL Server as a target, use the "Specify identity field" to define the column with IDENTITY(1,1).

Saturday, December 17, 2011

[AUDIO] Integration Tools Podcast, Episode 49: Informatica, expressor, Melissa Data.

Spend a few minutes a week to keep on top of the data integration tools market. Episode 49 of the Integration Tools Podcast is available. The podcast is on integration tools' product releases, research, and events. Episode 49 covers Informatica, expressor, Melissa Data.

Integration Tools Podcast Episode 49

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

Tuesday, December 13, 2011

Exporting Oracle XML to a File with Talend Open Studio

Oracle stores XML in a database column using a proprietary data type called XMLType.  XMLType is a CLOB that can be exported to a file as a block of text using Talend Open Studio.

Saturday, December 10, 2011

[AUDIO] Integration Tools Podcast, Episode 48: Integration Tools Incursion into App Infrastructure

Integration tool vendors with an MDM product offer to replace custom coding of a CRUD application with an off-the-shelf solution, just as these vendors replace custom data-loading code with a tool.

Spend a few minutes a week to keep on top of the data integration tools market. Episode 48 of the Integration Tools Podcast is available. The podcast is on integration tools' product releases, research, and events. Episode 48 covers SnapLogic, Talend, expressor, Melissa Data, Pentaho, Extol.


Integration Tools Podcast Episode 48

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

Tuesday, December 6, 2011

[VIDEO] Coded to Last with Talend Open Studio

Create a Talend Open Studio for Data Integration job configured by a flexible properties file and supporting environment-specific actions for easy development.

Sunday, December 4, 2011

[AUDIO] Integration Tools Podcast, Episode 47: Talend. CloverETL. DataFlux.

Spend a few minutes a week to keep on top of the data integration tools market. Episode 47 of the Integration Tools Podcast is available. The podcast is on integration tools' product releases, research, and events. Episode 47 covers Talend, DataFlux, and CloverETL.

Integration Tools Podcast Episode 47

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

64-bit Microsoft Access with Talend Open Studio Data Integrator

If you have trouble connecting to Microsoft Access with Talend Open Studio Data Integrator on a 64-bit machine, the problem may be that 64-bit ODBC drivers are missing.

Saturday, December 3, 2011

[VIDEO] Versatile File Processing with Talend Open Studio

Process your files in directories with Talend Open Studio. Remember to parameterize EVERYTHING in TOS as a context variable.