The Java library I'll be working with is the Commons Lang library: Commons Lang. Here is the Javadoc.
This is an image of Open Studio. An input Excel file is mapped directly to an output Excel file. However, since some of the fields in the source are empty, some null/empty string checks are required to make sure that the output spreadsheet's columns are aligned.
|Talend Open Studio Job with tLibraryLoad Component|
Then, in the tMap component, add a Java expression that makes the StringUtils.isBlank call.
|tMap with a Commons Lang StringUtils Call|
When you use tLoadLibrary, the JAR file is copied in the Talend internals. This makes it eligible to be exported along with a job. Don't try to adjust the IDE's or another classpath to find your JAR.
There are many possibilities for integration with this kind of flexibility. This example focused on some useful string handling routines from a popular Java library. But with Java, there is so much code out there that more capable libraries like Hibernate or JUnit could find their way into integration scenarios.