Talend training, implementing data integration version 2022
Presentation
Talend Open Studio (TOS) is an open source ETL application that enables massive synchronization of information from one database to another. This course will teach you how to design, model and develop TOS jobs in order to deal with various issues.
You want a training adapted to the specificities of your company and your teams?
Our experts build your customized training!
Pedagogical objectives
- Design and develop jobs in the Talend ETL application
- Optimize the jobs developed by using contexts and data sets
- Perform more complex transformations using variables, expressions and joins
- Run and debug a job, trace execution statistics
Target public
Requirements
Price
- 2000€ HT per person.
- Good knowledge of RDBMS and SQL. Knowledge of Java is a plus.
Training program
- Data integration. ETL solutions.
- TOS: installation, user preferences. Reference documentation.
- Product philosophy. Job design.
Model the need, design a first job
- Business Modeler. Job Designer.
- Main connections. CSV and XML components.
- Simple transformation components.
- View generated code, run a job.
- Configure reusable connections using metadata.
- Update metadata and propagate it to jobs, import/export metadata.
- Set up jobs with contexts.
- Externalize context variables in ".properties" and ".ini" files.
- Create and manage your own variables.
- Generate data sets for testing.
Working with databases
- Supported databases and main components.
- Settings of the operations on the tables.
- Metadata and connection context to a database schema.
- Connection sharing and transaction management.
- Create queries using SQLBuilder.
- Presentation of the tMap component.
- Configuration of input streams, creation of joins.
- Perform transformations using variables, expressions and joins.
- Qualify the data using filters.
- Generate multiple outputs, manage rejects.
Supplements
- Break down a job into sub-jobs, use of tRunJob. Launching jobs from the command line. Periodic execution.
- Debugging a job, tracing execution statistics.
- Reporting tJasperOutput.
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.