fr
en
Talend Open Studio for Data Integration (ETL)
Your analyses depend on available, well-organised data. With Talend, connect data collection, transformation and delivery to structure your data flows. Strengthen your ability to design processing aligned with application and business needs.
- Duration
- 4 days 28 hours
- Code
- TOS1FR Code
Presentation
Talend is an open-source data integration solution for modelling, developing and implementing data migration, consolidation and integration projects within your information system.
Talend ETL lets you extract data from databases and common file formats, transform it and load it into various targets, or perform large-scale synchronisation between databases through a graphical interface.
Key strength: 60% of the course is devoted to practical exercises.
Objectives
By the end of this course, you will be able to:
- navigate the application;
- understand the main principles of job creation;
- master the main components;
- schedule jobs;
- handle errors;
- use parameters and variables;
- understand monitoring options;
- deploy jobs;
- connect different heterogeneous databases.
Program
Overview
- Introduction to data integration.
- Overview and positioning of Talend solutions.
- Talend Open Studio for Data Integration.
Project modelling and documentation
- Use the Business Modeler.
- Manage documentation and revisions.
- Connections between the Business Modeler and the Talend repository.
Create jobs
- Create your first job.
- Understand interactions between components and metadata.
- Read and write files: delimited, positional, Excel and others.
- Access databases: MySQL, Oracle, SQL Server, DB2 and others.
- Use tMap to transform and enrich data.
- Document jobs.
- Explore other palette components.
- Further topics:
- Focus on data types: Date, BigDecimal, Dynamic and others.
- Process XML streams.
- Reuse existing code and call it from Talend.
Chain components and handle errors
- Understand how components are instantiated.
- Use triggers, conditional links and iterations.
- Handle errors.
Deployment and monitoring
- Use execution contexts.
- Manage different types of traces: execution statistics, logs and data volumes.
- Adopt a policy for managing context variables and centralised traces.
- Deploy and run jobs independently.
- Use Debug mode.
Contribute to the Talend community
- Use community tools: Forum, Jira and Exchange.
- Import user-developed components.
Audience
This course is intended for:
- developers;
- DBAs;
- technical architects;
- solution integrators.
Prerequisites
No prerequisites are required. Knowledge of Java is an advantage.
Teaching and assessment methods
- Initial skills assessment
- Training materials provided to participants
- Continuous assessment throughout the course
- End-of-course feedback questionnaire
- Combination of theory and practical application
- Attendance records
- Post-course follow-up evaluation
Dates and sessions
Choose the date and delivery format that suit you.
No upcoming sessions are currently available.