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

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

Integration Tools Podcast Episode 29

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

Migrating Legacy Data with Talend Open Studio's tSplitRow

In the life of a database, columns are added to tables to support new data elements.  When a pattern of similar columns develops, it may be worthwhile to move the repeating group to a separate table.  Talend Open Studio's tSplitRow component turns each column into its own row.

[AUDIO] Integration Tools Podcast, Episode 28: Informatica / HCA License Dispute

Spend one or two minutes a week to keep on top of the data integration tools market. Episode 28 of the Integration Tools Podcast is available. The podcast is on integration tools' product releases, research, and events. Episode 28 covers an Informatica / HCA License Dispute.

Integration Tools Podcast Episode 28

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

JasperReports and Data Sources

JasperReports are very portable.  Create reports in iReport Designer and publish the JRXML to JasperReports Server.

XPath Loops in Talend Open Studio

When analyzing an XML document for processing, one tends to think top-down.  For example, "in a library, give me all the books" implies a <library><books><book> structure.  However, it may be easier to think from the innermost elements, outward: "give me all the books and their library".

XPath Functions in Talend Open Studio

XPath has standard functions like fn:name() that will retrieve the name of an XML element.  You can use these in Talend Open Studio when certain parts of your XML aren't known in advance.

[AUDIO] Integration Tools Podcast, Episode 27: Composite. Safe Software. Pervasive. Informatica. Microstrategy.

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

Headlines

1. New Composite adapters
2. Pervasive EDI service available on Azure
3. Microstrategy offering Informatica

Integration Tools Podcast Episode 27

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

Scanning an Input String in Talend Open Studio

Use Java's regular expressions packaged in a Talend Open Studio Routine to scan an input string and perform an advanced manipulation.

Complex Joins Out of tMap in Talend Open Studio

The tMap component in Talend Open Studio (TOS) is a productive and efficient way to combine a main data flow with lookups.  However, the tMap is limited to join conditions based on equality.  For a more complex expression -- such as comparing a range of dates -- adjust the data so that the range turns in to a something join-able via a tMap: convert a single record with range 1-3 into three records 1,2,3.

If adjusting the data isn't possible, then push the complex join to the input component by expanding the SQL statement of the input component.

[AUDIO] Integration Tools Podcast, Episode 26: Half Year Special. SnapLogic. iWay.

The Integration Tools Podcast is 1/2 Year Old!

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

Headlines 

• Assessment of emerging segment of integration tools market (at 1:45) 
• SnapLogic releases Summer Release 2011 with a new JSON Snap
• iWay CEP Enable deploys REST and sends out Tweets

Integration Tools Podcast Episode 26

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

Trim Your Talend tMaps with Java Varargs

Complex validation, conversion, and formatting logic in a Talend Open Studio tMap is difficult to maintain.  Don't cram lengthy and repeated Java expressions in a field mapping.  Use a Talend Routine to encapsulate the logic and apply it in a concise syntax across all your tMaps.  Java Varargs -- a Java 5 language feature -- will make these Routines general by accepting different call signatures (# of arguments).

BRules 1.1 Released for Talend Open Studio

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

BRules 1.1 adds functions for testing JSON.  isJSON() and hasJSONPath() examine JSON strings before running the tFileInputJSON component.

[AUDIO] Integration Tools Podcast, Episode 25: expressor. Pervasive. Platform Computing.

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

Headlines 

• Platform Computing's Platform MapReduce is available
• Pervasive Software releases TurboRush™  
• expressor DataScript is in release 3.3

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

Integration Tools Podcast Episode 25

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