Description

Talend ETL makes it easy to add new functions and components to carry out complex processes. This internship will allow you to master the advanced features of Talend Open Studio, in order to achieve optimized and reliable implementation of data flows.

Who is this training for ?

For whom ?

Prerequisites

Training objectives

Master the advanced components of TOS Know how to integrate Java into Talend jobs Know how to create custom components Know how to optimize the performance of Talend jobs Know how to debug and deploy jobs in production Know the community around Talend and know how to interact with it

Training program

• Introduction
  • - Presentation of Talend Open Studio.
  • - Reminder of ETL principles.
  • - TOS installation.
• Advanced use of Talend
  • - Contexts and their management.
  • - Implement complex transformations.
  • - Manipulate XML feeds.
  • - Implement ELT components.
  • - Use regular expressions.
  • - Exercise: Associate a group of contexts to a job, use transformation components, create XML files from a flat file , use ELT MySQL components.
• Java and component creation
  • - Presentation of the principles of implementation in Java.
  • - Consult the Java code associated with a job.
  • - Talend Java components.
  • - Use routines.
  • - Anatomy and creation of a component.
  • - Export a component to the palette.
  • - Internationalize its components.
  • - Exercise: Using tMemorizeRows, tJavaFlex, tJava.
  • - Write a routine and use it in a job.
  • - Create a first component.
  • - Edit javajet files to extend functionality.
• Performance optimization and debugging
  • - Monitor job performance.
  • - Set up your own logging system.
  • - Optimize job performance.
  • - Debugging.
  • - Modify variables in memory on the fly.
  • - Exercise: Add monitoring components to a job, set up your log system, use buffers.
• Production deployment
  • - Run a job outside TOS.
  • - Schedule the execution of a job under Windows.
  • - Schedule the execution of a job under Linux.
  • - Talend Enterprise and the TAC.
  • - Exercise: Export the first job created outside TOS, schedule the execution of the exported job via the Windows Task Scheduler.
• For further
  • - Good development practices.
  • - Create an Eclipse plug-in.
  • - Integrate an Eclipse plug-in into Talend Open Studio.
  • - Presentation of Talend ESB.
  • - Presentation of Talend Big Data.
  • - Exercise: Sharing connections, using Rollback.
• Conclusion
  • - Presentation of resources on Talend.
  • - Promote your development within the Talend community.