BRules 0.2 Released for Talend Open Studio

BRules is a collection of routines that validates data elements in Talend Open Studio. Version 0.2, which includes the new shorthand validation routines "all()" and "xor()", was uploaded to the Talend Exchange

Screenshot of New Talend BRules 0.2 Routines

Styling the Component View in Talend Open Studio

When you build a custom component in Talend Open Studio, you add UI controls in the component's XML descriptor. The controls can be positioned, grouped, and labeled to help with usability.

Component Field CHECK in Talend Open Studio

To retrieve a boolean value (true, false) from the user for configuring a custom component in Talend Open Studio, define a PARAMETER with a FIELD attribute of CHECK.

Component Field TEXT in Talend Open Studio

A textbox is a versatile way to gather parameters for a custom component in Talend Open Studio.  To create a textbox for the custom component, specify a PARAMETER element with a FIELD of "TEXT".

[AUDIO] Integration Tools Podcast, Episode 11: Pitney Bowes. iWay.

Episode 11 of the Integration Tools Podcast is available. The podcast is on integration tools' product releases, research, and events. Episode 11 covers Pitney Bowes and iWay.

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

Integration Tools Podcast Episode 11

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

[TUTORIAL] Component Designer in Talend Open Studio

This tutorial is essential for new Talend Open Studio component developers. It shows how to use Open Studio's Component Perspective to rapidly build and test custom components.

Talend Open Studio Widgets for Component Configuration: Part 1

If you write a custom component for Talend Open Studio, your users will interact with the new component using the Components View.  You'll set up the Components View in the XML descriptor using the PARAMETERS and ADVANCED_PARAMETERS elements.

Organizing Custom Components in Talend Open Studio

When you create a custom component in Talend Open Studio, you control its display in the Pallete using the FAMILIES element in the component's XML descriptor.  The FAMILIES element follows the HEADER element and precedes the DOCUMENTATION element.  FAMILIES is a container for FAMILY elements.

BRules 0.1 Released for Talend Open Studio

BRules is a collection of routines that validate data elements in Talend Open Studio.  Version 0.1 which validates phone numbers using Google's libphonenumber library was uploaded to Talend Exchange.

[AUDIO] Integration Tools Podcast, Episode 10: Pentaho. Progress. Extol.

Episode 10 of the Integration Tools Podcast is available. The podcast is on integration tools' product releases, research, and events. Episode 10 covers Pentaho, Progress, and Extol.

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

Integration Tools Podcast Episode 10

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

Closures in pre-JDK 8 Java

Closures are a widely used technique for writing functions in languages like Groovy and JavaScript. Oracle's JDK Roadmap add a convenient syntax for closures to Java in JDK 8 (some time in the future).  This post describes how to use closures with the current JDK.

A List of Talend Tutorials and Examples

There is a Google Site accompaniment for this blog to help navigate related topics.  For a list of the Talend tutorials and examples, visit this link

Bekwam DaaS Wiki - Talend

The home page for the site (right now, only a Talend page exists), visit

Bekwam DaaS Wiki

Talend Open Studio Calling: Clean Up Your Phone Numbers

Google's library for working with phone numbers -- libphonenumber -- is available at Google code.  The power of the library is apparent when you read that it has support for 228 countries or regions.  Bringing this library into Talend Open Studio helps you standardize your phone numbers.

Yes, Oui, and Si: Boolean Handling with Talend Open Studio

Databases usually handle boolean values with a small integer where 0 is false and 1 is true.  However, the presentation layer usually prefers something human-readable like "Yes" or "True".  Commons Lang BooleanUtils provides a way of converting boolean strings without writing the same repetitive logic.

The Regex Lookup Table with Talend Open Studio

 In Talend Open Studio, most matching and joining will be done using well-defined keys like integers (surrogate keys) or business keys (username) using equality.  Sometimes, it's useful to match on regular expressions.  Instead of embedding regular expressions in your tMaps, consider using a more general solution based on java.util.HashMap.

Copying a Table in MySQL

To copy a table in MySQL, issue two commands: CREATE TABLE to create the table and an INSERT statement to copy the data.

[AUDIO] Integration Tools Podcast, Episode 9: Pitney Bowes. Oracle. iWay. SAS.

Episode 9 of the Integration Tools Podcast is available. The podcast is on integration tools' product releases, research, and events. Episode 9 covers Pitney Bowes, Oracle, iWay, and SAS.

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

Integration Tools Podcast Episode 9

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

[TUTORIAL] Subtotaling with Jaspersoft iReport Designer

This tutorial shows how to create a subtotal on a group using Jaspersoft iReport Designer.

[TUTORIAL] Grand Totals with Jaspersoft iReport Designer

This tutorial shows how to add a grand total to a report using Jaspersoft iReport Designer.

Negative Numbers in Jaspersoft iReport Designer

In Jaspersoft iReport Designer, you can specify the format of a numeric field like a Double (floating point number) using a Pattern.  One format is currency.  The default currency format uses U.S.-style commas and a period (the decimal point).  Negative numbers are displayed with a dash ('-').

Combining Excel Spreadsheets with tUnite in Talend Open Studio

When you need to combine several Excel workbooks or sheets inside a workbook, use Talend Open Studio's tUnite component.

Adding a Parameter to a Jasper Report WHERE Clause with iReport Designer

Adding a parameter to a Jasper report and using the parameter in the WHERE clause of a query is a simple three-step operation.

[TUTORIAL] A Jasper Report in Under 9 Minutes

In under 9 minutes, you can create a Jasper report using iReport. This tutorial shows how to build a report using a MySQL Datasource.

Deleting Ruler Guidelines in Jasper iReport

To delete a ruler guideline in Jasper iReport, drag the guideline off the screen: left for a vertical ruler, up for a horizontal.

Setting up a MySQL Datasource in Jasper iReport

Jasper's iReport supports many different Datasource types to provide data for its reports.  One of these Datasources is "Database JDBC connection" which is used to write reports against MySQL.

[AUDIO] Integration Tools Podcast, Episode 8: Expressor. DataFlux. Informatica. Talend. Progress. Astera.

Episode 8 of the Integration Tools Podcast is available. The podcast is on integration tools' product releases, research, and events. Episode 8 covers Expressor, DataFlux, Informatica, Talend, Progress, and Astera.

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

Integration Tools Podcast Episode 8

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

Five Date Formats in Talend Open Studio

It's best to standardize on one date format throughout your application.  The date format for the RDBMS is a good candidate, like "dd-MM-yy" for Oracle.  But dates can come from other sources, so you'll occasionally need to format a date.

Excel 2007 Dates in Talend Open Studio

Talend Open Studio builds metadata from Excel 2007.  When dates are used in Excel 2007, Talend Open Studio ignores the formatting that may have been put in the spreadsheet, even if the schema is specified to handle strings rather than date objects.

MySQL Fact Tables with Talend Open Studio

Once the dimensions are loaded in your data mart, load the fact tables.  In Talend Open Studio, this is implemented using several tMysqlInput components, a tMap, and a tMysqlOutput component for a physical model built on MySQL.

1,000 Upload Views on the Bekwam Channel

Thank you for all the views, retweets, hits, and comments.  The Bekwam Channel on YouTube reached 1,000 upload views today.

Look for more videos on Talend and CloverETL.  I'm wrapping up the ETL part of the School Revenues Data Mart, so I'll post an overall design and error handling before I start gathering and processing the remaining data sets.

The videos will move into BI once the data is loaded.  I'm starting with Jasper which I plan to integrate with Talend.

http://www.youtube.com/user/bekwam

-Carl