[AUDIO] Integration Tools Podcast, Episode 16: Pervasive. Informatica. DataFlux.

Episode 16 of the Integration Tools Podcast is available. The podcast is on integration tools' product releases, research, and events. Episode 16 covers Pervasive, Informatica, DataFlux, Zencos.

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

Integration Tools Podcast Episode 16

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

Data Intake with DaaS

The ideal data source for a Data-as-a-Service (DaaS) implementation is a robust, automated, and well-documented interface. When data must be implemented manually, Excel may be the best option.

Vendor Neutral DaaS Architecture

Data-as-a-Service (DaaS) aggregates, cleans, normalizes, packages, secures, customizes, and formats data for use by customers.  This blog post presents a vendor-neutral design of a DaaS implementation.

Nested XML From an RDBMS with Talend Open Studio

If you have a simple XML document -- say one that closely mimics a database schema -- the example in the Talend Open Studio Users' Guide is sufficient.  However, if your XML document contains repeating groups of nested elements, you'll need a few extra steps.

Passing a Variable out of a tGroovy with Talend Open Studio

It's possible to pass a variable out of a tGroovy, but you'll need to use Java. Rather than binding and manipulating a a variable of the form "context.MYPARAM" or even globalMap, you'll need to create a Map for yourself in a tJava and pass _THAT_ as your parameter.

[TUTORIAL] iReport List Component

Tutorial on using a Jaspersoft iReport Designer List Component running a query on a Microsoft Access database; combined with a chart

[AUDIO] Integration Tools Podcast, Episode 15: SyncSort. Avnet. ALTIMATE.

Episode 15 of the Integration Tools Podcast is available. The podcast is on integration tools' product releases, research, and events. Episode 15 covers SyncSort, Avnet, and ALTIMATE..

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

Integration Tools Podcast Episode 15

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

[TUTORIAL] Introducing tRules for Talend Open Studio

Use the tRules component to add a reason code and message to the rejected output; write rules in Javascript-like expressions

A Few Notes About Installing Fedora 14

I just upgraded Bekwam's website and test lab to Fedora 14.  Here are a few problems I ran into and their simple resolutions.

[TUTORIAL] Creating a Pivot Table with iReport Designer

This is a tutorial on creating a pivot table with Jaspersoft's iReport Designer. The example is based on an Excel spreadsheet that uses an iReport crosstab wizard to create a pivot table. After the crosstab is created, the pivot table is customized with a label, new column widths, and a number format.

[AUDIO] Integration Tools Podcast, Episode 14: Queplix. Platform Computing. CDS Global. Pentaho.

Episode 14 of the Integration Tools Podcast is available. The podcast is on integration tools' product releases, research, and events. Episode 14 covers Queplix, Platform Computing, CDS Global, and Pentaho.

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

Integration Tools Podcast Episode 14

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

More COLUMN_LIST Component Fields in Talend Open Studio

In the XML descriptor for a Talend Open Studio custom component, COLUMN_LIST is used to present a list of the component schema's columns in a drop down on the Component View.  PREV_COLUMN_LIST and LOOKUP_COLUMN_LIST are variations.

A Class Constructor Argument to a Spring Bean using XML

Most example Spring config files I've seen deal with bean references or simple types.  This XML fragment is used to pass in a Class object to a Spring bean.

tRules 0.1-BETA Released for Talend Open Studio

tRules 0.1-BETA was uploaded to the Talend Exchange.  This is a component that filters on a set of rules written in Java and will output a reason code and message with each failed record.

See tRules Page for the component documentation.

Column Metadata in Talend Open Studio Components

Getting a list of columns in a Talend Open Studio custom component is a common task.  Use the getMetadataList() method on the Node to retrieve the schemas used for incoming and outgoing connections

Incoming Connections in Talend Open Studio Components

To work with data in your custom Talend Open Studio component, retrieve an IConnection.  IConnection provides the variable name for a row of data; "row1" is common in smaller jobs.

Three Error Handling Strategies in Talend Open Studio

You can recover from some errors.  Others, like system or network failures are fatal.  But even in the fatal case, your Talend Open Studio job should die gracefully, notifying the operations team and leaving the data in a good state.  This post presents three error handling strategies for your Talend jobs.

[AUDIO] Integration Tools Podcast, Episode 13: Jitterbit. EMC. Pervasive.

Episode 13 of the Integration Tools Podcast is available. The podcast is on integration tools' product releases, research, and events. Episode 13 covers Jitterbit 4.0, EMC/Greenplum, and Pervasive (Metamorphosis).

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

Integration Tools Podcast Episode 13

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

Component Field COLUMN_LIST in Talend Open Studio

If your Talend Open Studio custom component needs to select from a list of columns in an input or output schema, use the COLUMN_LIST field type.  By default, this will display fields from the FLOW schema.  To select columns from other schemas, define a different CONNECTOR and use the CONTEXT attribute.

[TUTORIAL] Pie Charts with Jaspersoft iReport Designer

This tutorial shows how to create a pie chart from an Excel spreadsheet in Jaspersoft's iReport Designer. If you've ever gotten a numeric Java compilation error when using charts, you'll want to watch this.

Embedding Expressions with JEXL in Talend Open Studio

If your custom Java Talend Open Studio component needs to evaluate script expressions, consider embedding the lightweight Commons JEXL library.

El Cid in Talend Open Studio Components

In order to prevent name collisions or duplicate variable definitions in custom Talend Open Studio components, append a component's unique name to variable definitions

[AUDIO] Integration Tools Podcast, Episode 12: DataStax. Workday. CloverETL.

Episode 12 of the Integration Tools Podcast is available. The podcast is on integration tools' product releases, research, and events. Episode 12 covers DataStax, Workday, and CloverETL.

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

Integration Tools Podcast Episode 12

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

Component Field TABLE in Talend Open Studio

A TABLE parameter provides a Talend custom component with a flexibile mechanism for retrieving repeated groups of information during configuration.

Component Field CLOSED_LIST in Talend Open Studio

If you're building a Talend Open Studio component that requires the user to select a value from a drop-down list, there are several PARAMETER FIELDS available.  One of the FIELDS, type CLOSED_LIST, will allow you to form a list of items using hardcoded strings.