A Simple Order Processing Web Service with Sparx Systems EA and Talend

This is a four-part video series that creates a simple web service using the modeling tool Enterprise Architect from Sparx Systems and the ESB version of Talend Open Studio.

[AUDIO] Integration Tools Podcast, Episode 63: Oakland Software (Interview). SnapLogic. Talend. Pentaho.

This week, the Integration Tools Podcast has a special interview with integration tool vendor Oakland Software.

Francis Upton is the President and CTO of Oakland Software.  Oakland Software makes the Oakland Data Transformer, or ODT, which includes an Eclipse-based designer and runtime that is integrated with Apache Camel (Talend ESB), the Mule ESB, and Java. 

For free downloads of ODT’s designer product and evaluation copies of the runtime, visit www.oaklandsoftware.com or email sales@oaklandsoftware.com

Spend a few minutes a week to keep on top of the data integration tools market. Episode 63 of the Integration Tools Podcast is available. The podcast is on integration tools' product releases, research, and events. This week covers Oakland Software, Talend, and SnapLogic, and Pentaho.

Integration Tools Podcast Episode 63

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

Your Own Exception Handler for Standard Talend Components

Many Talend Open Studio (TOS) components will allow you to specify whether or not processing should stop when an error is encountered.  Some do not, and this can be problematic when an error case is to be expected.  This post describes a technique for adding a custom exception handler to TOS components missing the "Die on error" option.

[AUDIO] Integration Tools Podcast, Episode 62: Informatica. Talend. Information Builders.

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

Integration Tools Podcast Episode 62

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

Manipulating a tHashOutput in Talend Open Studio

The Talend Open Studio tHashOutput and tHashInput allow you to save your input in RAM, offering potential performance gains.  The basic usage defines a single tHashOutput which gathers input and a tHashInput which will direct the input to a data flow.  This post describes two expanded configurations.

Talend Open Studio Tip: Naming a Subjob

When selecting a subjob in Talend Open Studio, the Basic Settings tab provides a text box that can display a title associated with the subjob.

[AUDIO] Integration Tools Podcast, Episode 61: DataFlux. Informatica. Jitterbit.

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

Integration Tools Podcast Episode 61

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

Efficient Lookups with Talend Open Studio's Hash Components

If you are using the same data source in several Talend Open Studio subjobs, consider loading the data data into an internal data structure for use throughout a job.

Handling Database Warnings with Talend Open Studio

To handle nonfatal database warnings with Talend Open Studio, use a Run If connector routed to a tWarn component.  Use a global exception handler pattern -- tLogCatcher -- to save off the error message and email it.

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

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

Integration Tools Podcast Episode 60

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

Outgoing Connections in Talend Open Studio Custom Components

When building a custom component for Talend Open Studio, start by defining the outgoing connections in the descriptor XML file packaged with the component.  Then, retrieve a handle to one or more outgoing connection objects which will provide you with a variable name to use in your JET code.

Validate XML Data with Talend Open Studio

With an XSD, you can validate the structure of an XML document.  To validate the contents of the document in Talend Open Studio, use a component like tFilterRow.