Use tSetGlobalVar to Record a Count

If you want to use one or more global variables set by an input flow like a tOracleInput throughout your Talend job, consider using tSetGlobalVar.  Convert the flow from the input component into an iterate and map a field to a key in the tSetGlobalVar component.

Talend to MS SQL with Windows Authentication

To connect a Talend integration job to MS SQL Server using Windows Authentication, use the tOleDbInput component rather than the tMSSqlInput.  You'll need to put some DLLs on the system running Talend.

Javajet Sample to Get List of Routines in a Talend Custom Component

This .javajet program uses the static class RoutinesUtil to retrieve a list of System Routines loaded in Talend Open Studio.

Collaborating on Talend Open Studio Routines: Part 5 - Metadata

Managing the Java code that makes up a Talend Open Studio Routine outside of Talend lets you use technologies like source code control and continuous integration to improve the maintenance of your Routine.  This blog post describes a publicly-available Maven Plugin called TalendRoutine that will bridge the gap between the standard artifacts produced by Maven and the deployable Routine needed by Talend Open Studio.

Collaborating on Talend Open Studio Routines: Part 4 - Assembly

Pulling Routine code development out of Talend Open Studio means that you can enlist supporting technologies like Git and Maven to foster collaboration.  This post describes how to assemble Java source into a zip file that can be imported into Talend Open Studio.