Talend training, optimizing your data flows version 2022
Presentation
‘ETL Talend permet d’ajouter simplement de nouvelles fonctions et composants afin de réaliser des processus complexes. Ce cours vous permettra de prendre en main les fonctionnalités avancées de Talend Open Studio, afin d’aboutir à une mise en place optimisée et fiable des flux de données.
You want a training adapted to the specificities of your company and your teams?
Our experts build your customized training!
Pedagogical objectives
- Master the advanced components of TOS
- Create and use routines
- Monitor and optimize the performance of Talend jobs
- Debug and deploy jobs in production
- Know the Talend community and how to interact with it
- Handle complex data structures
Target public
- BI developers, senior BI consultants, database developers, BI research engineers, ETL consultants.
Requirements
- Know the basics of Talend Open Studio or have taken the "Talend Open Studio, implementing data integration" course
Price
- 2000€ HT per person.
Training program
- Talend Open Studio presentation.
- Reminder of the principles of ETL.
- Installation of TOS.
Java and routines
- Presentation of the principles of implementation in Java.
- View the Java code associated with a job.
- Talend Java components.
- Creation and use of routines.
- Anatomy and creation of a component.
- Connection - disconnection components.
- Transactions: commit and rollback management.
- Calling a stored procedure.
- Implement ELT components.
- Methods “Slowly Changing dimension”.
- Father / Son link: connection sharing, variable sharing and return values.
Handling of complex structures
- Interacting with Web Services
- Handle XML streams.
- Discover the JSON components.
- Use regular expressions.
- Debugging.
- Monitor job performance.
- Set up your own logging system.
- Optimize job performance.
Deployment in production
- The contexts and their management.
- Launch a job out of TOS.
- Schedule the execution of a job in Windows.
- Schedule the execution of a job under Linux.
- Talend Enterprise et la TAC.
To go further
- Good project practices. Data synchronization.
- Presentation of resources on Talend.
- Promote its development within the Talend community.
Pedagogical methods
Practical training: 70% Practical, 30% Theory.
Training material distributed in digital format to all participants.
Access to servers and databases as well as PCs are provided for practice.
Evaluation method
The evaluation of the objectives is done throughout the session through multiple exercises (70% of time).
Instructor
Our training is provided by Mohand LARABI, PhD in computer science and Talend expert.
Organization
Classes start at 9am until 12:30pm and then from 2pm until 5:30pm. That is 7 hours per day.