How to run a Job in Java Debug mode ..............72

How to run a Job in Traces Debug mode ...........73

How to set advanced execution settings ............75

4.2.7 How to customize your workspace ..............77

How to change the Palette layout and settings ...77

How to change panels positions .........................80

How to display job configuration tabs/views .....81

4.3 Using connections ................................................81

4.3.1 Connection types ..........................................81

Row connection ..................................................82

Iterate connection ...............................................84

Trigger connections ............................................84

Link connection ..................................................85

4.3.2 How to define connection settings ...............86

Row connection settings ....................................86

Iterate connection settings ..................................87

Trigger connection settings ................................88

4.4 Using the Metadata Manager .............................88

4.4.1 How to centralize the Metadata items ..........88

4.4.2 How to centralize contexts and variables .....89

How to use variables in a Job .............................89

How to use variables in the Contexts view ........90

How to configure contexts .................................93

How to define variables from the Component view

95

How to store contexts in the repository .............96

How to apply context variables to a Job from the re-

pository ........................................................................98

How to run a Job in a selected context .............100

4.4.3 How to use the SQL Templates ..................101

4.5 Handling Jobs: advanced subjects ...................101

4.5.1 How to map data flows ...............................102

4.5.2 How to create queries using the SQLBuilder ...

102

How to compare database structures ................103

How to build a query ........................................104

How to store a query in the repository .............106

4.5.3 How to download external community compo-

nents ..........................................................................106

How to install community components from Talend

Exchange ...................................................................107

How to manage installed components .............107

4.5.4 How to install external modules .................108

4.5.5 How to launch a Job periodically ...............110

4.5.6 How to use the tPrejob and tPostjob components

112

4.6 Handling Jobs: miscellaneous subjects ...........113

4.6.1 How to share a database connection ...........113

4.6.2 How to define the Start component ............114

4.6.3 How to handle error icons on components or

Jobs ............................................................................115

Warnings and error icons on components ........115

Error icons on Jobs ...........................................115

4.6.4 How to add notes to a Job design ...............116

4.6.5 How to display the code or the outline of your

Job .............................................................................117

Outline ..............................................................117

viCode viewer ......................................................1184.6.6 How to manage the subjob display .............118How to format subjobs .....................................119How to collapse the subjobs .............................119How to remove the subjob background color ...1194.6.7 How to define options on the Job view .......120How to automate the use of statistics & logs ...120How to use the features in the Extra tab ...........1214.6.8 How to find components in Jobs .................122CHAPTER 5 Managing data integration Jobs .............1255.1 Activating/Deactivating a Job or a sub-job .....1265.1.1 How to disable a Start component ..............1265.1.2 How to disable a non-Start component .......1265.2 Importing/exporting items or Jobs ..................1275.2.1 How to import items ...................................1275.2.2 How to export Jobs in Java .........................129How to export Jobs as Autonomous Job ..........131How to export Jobs as Webservice ...................132An example of exporting a Job as a Web service ...132How to export Jobs as JBoss ESB ....................136How to export Jobs as Petals ESB ....................1375.2.3 How to export Jobs in Perl ..........................1405.2.4 How to export items ....................................1425.2.5 How to change context parameters in Jobs .1445.3 Managing repository items ...............................1455.3.1 How to handle updates in repository items .145How to modify a repository item ......................145How to update impacted Jobs automatically ....146How to update impacted Jobs manually ...........1475.4 Searching a Job in the repository .....................1475.5 Managing Job versions ......................................1495.6 Documenting a Job ............................................1505.6.1 How to generate HTML documentation .....1505.6.2 How to update the documentation on the spot ..1515.7 Handling job execution .....................................1515.7.1 How to deploy a Job on SpagoBI server .....151How to create a SpagoBI server entry ..............151How to edit or remove a SpagoBI server entry 153How to deploy your jobs on a SpagoBI server .153CHAPTER 6 Mapping data flows ..................................1556.1 tMap operation overview ..................................1566.2 tMap interface ....................................................1576.3 Setting the input flow in the Map Editor ........1596.3.1 How to fill in Input tables with a schema ...159Main and Lookup table content ........................159Variables ...........................................................1596.3.2 How to use Explicit Join .............................160Unique Match ...................................................162Talend Open Studio