Talend Open Studio Data Integration : Initiation + Advanced

bright idea

Goals


- Understand the data integration process

- Master the Talend Open Studio tool and the component library

Program

Data
integration issue Operational and Business Intelligence Integration
ETL (Extract Transform Load) tools available
Talend Open Studio: presentation, licenses, link with Eclipse
Support available: documentation, community, etc.

Workshop: Installation and presentation of the Talend Open Studio environment

Talend perspectives and views
Using the Business Modeler
Jobs: grid, palette of components
Main flows (main)
The notion of schema: types of columns
First components: input, output, flow generation

Practical workshop: creation and execution of a simple job, generation of content in a file

Input components (tFileInput, tMysqlInput,…)
Generation of content (tRowGenerator, tFixedFlowInput, …)
Outputs and display (tLogRow, tFileOutput, tMysqlOutput,…)
Logic and chaining of components
Step by step monitoring of execution traces of the Reject
management job
Simple transformations (filter, sort, replace, join)

Practical workshop: generation of content in a database, extraction and processing of data for display in console

Job versions and statuses
Metadata: properties and schemas.
Schema discovery for CSV files
Retrieving database schemas
Job updates from metadata

Practical workshop: inserting data sources and targets in the repository metadata

Use variables in a job (tSetGlobalVar)
Setting up a context local to the job
Context groups in the repository
Metadata as contexts

Practical workshop: use a variable in a job, contextualize the parameters of a metadata, create a test and production context

The ETL component par excellence
Managing inputs: main, secondary flows, naming of flows
Managing outputs: the integrated editor of tMap
Filtering data: input, output
Joint outputs, capture of output rejects, internal join
The expression editor
Performances

Practical workshop: multi-source, multi-destination extraction with a tMap, on a complete example

Parallel executions of sub-jobs
Talend triggers
Chaining of sub-jobs and components (OnSubjobOK, OnComponentOK)
Management of component errors, sub-job (OnComponentError, OnSubjobError)
Start and end component (tPreJob, tPostJob)
Catch and throw errors: tWarn, tDie, tLogCatcher

Practical workshop: assemble several jobs into one, factorize error management to generate a report file

Duration

5 days

Price

£ 2568

Audience

System administrators / BDD, Project managers, Developers

Prerequisites

Knowledge of Java

Reference

BUS305-F

Differentiate between main streams from iterate streams
Loops and programming via tLoop, tForeach
Switch from a main stream to an iterate stream, and vice versa (tFlowToIterate, tIterateToFlow) Job
synchronization with tWaitForFile, tWaitForSocket, tWaitForSQL

Lab: parallelize subjobs, synchronize jobs with external event

Use of advanced components: Java or regular expressions
The specificity of XML feeds in Talend
Code reuse: routines

Workshop: Using the tJavaRow, tJavaFlex components, using the embedded Java editor, deploying a custom routine

Reminders on debugging traces
Using the Java Debug mode: Debug perspective, step-by-step mode
Visualization and hot modification of variables

Workshop: Basic / advanced task debugging

Reminder on the contexts
Export of jobs for execution on a server
Passage of context between jobs, at runtime
Use of a file to load the context (tContextLoad)

Workshop: Deployment of tasks and dynamic loading of the context

Use of advanced components: Java or regular expressions
Creation of specific logs
Management of XML flows
Reuse of code

Workshop: Use of the tJavaRow, tJavaFlex components – creation of logs with tCatch, tDie … – use of the embedded Java editor

Essential concepts for extending Talend Open Studio
Creation of the component mockup with tJavaFlex / graphical interface
Discover the Talend forge and its community components
Integration into Talend Open Studio of the plugins created or downloaded

Workshop: Creation of a simple component via tJavaFlex, integration of components from the Talend forge

Sessions

Contact us for more informations about session date

I had been using Talend for a year without prior training. I had insisted with my management to follow this training and I do not regret it at all. Thanks to this, I will be able to immerse myself in all my achievements and review my way of coding, because there is really a way to do much better than what I was proposing until now.
Gilles D.
Gilles D.
Everything to get off to a good start on Talend and be able to put small jobs into production quickly. Very well constructed training. The exercises allow you to have a clear vision of what you can do with the Trainer tool : A bit fast flow which does not allow you to have a second of inattention otherwise you are quickly lost! Excellent training, very interesting.
Stéphane D.
Stéphane D.
The practicals are very well thought out and the logical continuation of the training is very relevant. I was surprised by the support left to the trainees: the Talend approved book. It's a change from paper course materials from a powerpoint that you then leave at the bottom of a drawer. Thanks for this book. The trainer's speech rate is a bit fast at times. But he takes the time to re-explain if necessary and his teaching skills are excellent. He never left us lost. Thank you for this excellent training!
Jean-baptiste M.
Jean-baptiste M.
Maybe a little intense. I would perhaps have appreciated that it went a little slower to have more time for personal note taking and to ensure a good understanding. I dread the application alone after the training a bit. I will be able to correct my errors in my already created Talend Jobs. I will also be able to configure and industrialize my work and thus save more time. Trainer who masters are subject. He is very educational and transmits his taste for the tool. Maybe just a bit fast but mostly due to the pace of the training which I found fast and dense for me. Very Good Training which corresponds exactly to my expectations. Very good and very nice trainer.
Karine C.
Karine C.
Ideal training room for a small group. Close to Lyon Part-Dieu train station. The course is wide and follows a very interesting progression for learning the subject. Perfect correspondence with my needs (initiation to techno and improvement in order to master design issues and / or Talend Open Studio DI projects) Listening trainer, relevant to these examples.
Brice S.
Brice S.
Many applications in prospect. Trainer: In Switzerland we have a slightly slower flow of words !! But we ended up getting used to it. Thank you.
Thomas A.
Thomas A.
An interesting internship allowed me to deepen my knowledge. Listening, competent, available trainer. I had the answers to my questions. it allowed me to progress in the use of Talend.
Aziza O.
Aziza O.
Trainer: friendly, speech a little too fast at times.
Loic B.
Loic B.
At the end of this training, Talend seems to be a reasoned choice for my work.
Frédéric D.
Frédéric D.
Perfect training. Nothing to say, on the contrary.
Serge G.
Serge G.
Précédent
Suivant