Talend Open Studio

User Guide.................................. i

Preface .........................................................................ix

Purpose ...................................................................ix

Audience .................................................................ix

Typographical conventions ....................................ix

History of changes ......................................................ix

Feedback and Support ................................................x2.6.1 Palette Settings ..............................................312.6.2 Version management ....................................332.6.3 Status management .......................................342.6.4 Job Settings ...................................................362.6.5 Stats & Logs ..................................................362.6.6 Context settings .............................................372.6.7 Project Settings use .......................................382.6.8 Status settings ................................................392.6.9 Security settings ............................................41CHAPTER 3

Designing a Business Model ......................43

3.1 What is a Business Model ...................................44

3.2 Opening or creating a Business Model ..............44

3.2.1 How to open a Business Model ....................44

3.2.2 How to create a Business Model ...................45

3.3 Modeling a Business Model ................................46

3.3.1 Shapes ...........................................................46

3.3.2 Connecting shapes ........................................47

3.3.3 How to comment and arrange a model .........49

How to add a note or free text ............................49

How to arrange the model view ..........................49

3.3.4 Business Models ...........................................50

Appearance tab ...................................................50

Rulers and Grid tab .............................................51

Assignment tab ...................................................51

3.4 Assigning repository elements to a Business Model

52

3.5 Editing a Business Model ....................................53

3.5.1 How to rename a Business Model ................54

3.5.2 How to copy and paste a Business Model ....54

3.5.3 How to move a Business Model ...................54

3.5.4 How to delete a Business Model ...................54

3.6 Saving a Business Model .....................................54CHAPTER 1 Data integration and Talend Open Studio 11.1 Data analytics ........................................................21.2 Operational integration ........................................21.3 Execution monitoring ...........................................3CHAPTER 2 Getting started with Talend Open Studio ..52.1 Important concepts in Talend Open Studio .......62.2 Launching Talend Open Studio ...........................62.2.1 How to access one or multiple Repositories 10How to connect to a local repository .................102.2.2 How to set up a project in the repository ......112.3 Working with different workspace directories 112.3.1 How to create a new workspace directory ....122.3.2 How to connect to a different workspace direc-tory ..............................................................................122.4 Working with projects ........................................132.4.1 How to create a project .................................14

2.4.2 How to import the Demo project ..................16

2.4.3 How to import a project ................................17

2.4.4 How to open a project ..................................18

2.4.5 How to delete a project .................................18

2.4.6 How to export a project ................................19

2.4.7 Migration tasks .............................................20

2.5 Setting Talend Open Studio preferences ..........21

2.5.1 Perl/Java Interpreter path ..............................21

2.5.2 External or User components .......................22

2.5.3 Language preferences ...................................23

2.5.4 Debug and job execution preferences ..........23

2.5.5 Designer preferences ....................................25

2.5.6 Adding code by default ................................25

2.5.7 Performance preferences ..............................26

2.5.8 Documentation preferences ..........................27

2.5.9 Displaying special characters for schema col-

umns ............................................................................27

2.5.10 SQL Builder preferences ............................28

2.5.11 Schema preferences ....................................28

2.5.12 Libraries preferences ..................................29

2.5.13 Type conversion .........................................30

2.6 Customizing project settings ..............................31CHAPTER 4 Designing a data integration Job ...............574.1 What is a job design .............................................584.2 Getting started with a basic job design ..............584.2.1 How to create a Job ......................................584.2.2 How to drop components to the workspace ..61How to drop components from the Palette .........61How to drop components from the Metadata node 624.2.3 How to search components in the Palette .....634.2.4 How to connect components together ...........644.2.5 How to define component properties ............65Basic Settings tab ...............................................65Advanced settings tab .........................................68Dynamic settings tab ..........................................68View tab ..............................................................70Documentation tab ..............................................704.2.6 How to run a Job ...........................................71How to run a Job in normal mode ......................71

Talend Open Studiov