Talend is THE open source data integration solution and rivals the market’s leading proprietary solutions. It’s powerful and open technology tools allow users to respond efficiently to a wide range of needs including: supplying datawarehouses, synchronizing databases, accessing Web services and transforming various file formats (XML, VSAM, delimeated, positional, etc.)

Using actual case studies throughout the course, this three-day training will allow students to obtain ‘Master User’ status for Talend Open Studio.

Talend Open Studio&Integration Suite

Talend is THE open source data integration solution and rivals the market’s leading proprietary solutions. It’s powerful and open technology tools allow users to respond efficiently to a wide range of needs including: supplying datawarehouses, synchronizing databases, accessing Web services and transforming various file formats (XML, VSAM, delimeated, positional, etc.)
Using actual case studies throughout the course, this three-day training will allow students to obtain ‘Master User’ status for Talend Open Studio.

Course objectives

  • Manage the environment
  • Modelize needs
  • Master the component library
  • Implement Jobs
  • Debug and deploy Jobs

Course

Introduction

  • ETL:An overview of proprietary and Open Source tools
  • Operational and business intelligence integration
  • Talend Open Studio

Modeling & documentation

  • Use the Business Modeler
  • Documentation management and version management
  • Organize the model links/Implementation: assignment

Job execution: files and databases

  • Generate data sets with tGenRow
  • Understand diagrams and metadata
  • Manage access to files (XML, positional, delineated, etc.)
  • Manage database access (native, ODBC access, etc.)
  • Use Mapper and transform the data
  • Look up simple, multiple and complex references
  • Manage shared code

Component concatenation

  • Use Before/After/First/Last triggers
  • Use conditional links
  • Use iteratives
  • Manage errors: Trigger IfOK, IfError

Talend Open Studio

  • Model a component using tPerlFlex
  • Create a simple component

Debugging, deployment and optimization

  • Debug quickly with tLogRow
  • Use the statistical mode
  • Execute step by step: trace mode
  • Use the internal debugger
  • Manage the context of executions
  • Optimize jobs (routines and snippets)

Talend Open Studio Advanced

This course will provide you with the skills to develop jobs using the software’s advanced functionality along with perl. You will learn to optimize your jobs and deploy them in a production environment. The class will also teach students how to create specific components and quickly roll-out the software’s functionality. This course has been created in conjunction with the Talend development team.
Using actual case studies throughout the course, this three-day training will allow students to obtain ‘Master User’ status for Talend Open Studio.

Course Objectives

  • Master the advanced components of Talend Open Studio Roll-out Talend Open Studio by creating specific components
  • Benefit from the power of perl in development
  • Learn to save time by federating codes
  • Debug, optimize and deploy your jobs
  • Roll-out Talend Open Studio by creating specific components

Course Presentation

  • Benefit from the power of perl: tPerlRow, tPerlFlex, etc.
  • Use regular expressions within the tFileRegex component
  • Create specific logs: tCatch, tDie, tWarn
  • Master the XML flow with tXMLInput/tXMLOutput components

Modeling & documentation

  • Use the embedded perl software (auto-completion, syntax verification, perldoc, error explanations, etc.)
  • Organize your perl functions with routines
  • Reuse your code tags via Snipnets

Job execution : files and databases

  • Install pre-requisite modules
  • Master the step-by-step mode (step in, step into, step over)
  • Visualize variables in real-time
  • Modify variables in memory on the fly

Component concatenation

  • Estimate performance of jobs
  • Optimize jobs

Roll out Talend Open Studio

  • Launch jobs on command line
  • Orchestrate job execution with a scheduler

Debugging, deployment and optimization

  • Understand the concepts of code generation using templates
  • Understand the 3 template files: start/main/end
  • Understand the components’ XML descriptions
  • Internationalize components

Participating in the Talend community

  • Package your own code
  • Package an existing CPAN module

Implement graphic interfaces dedicated to your specific components

  • Create an initial eclipse plugin
  • Integrate a new plugin into Talend Open Studio

Talend Integration Suite Development

Upon completion of this course, you will be able to develop your jobs by using the power of the Advanced Studio. You will be able to debug and optimize your jobs and execute them. Combining the FOUNDATION training to Talend Integration Suite specificities, this training helps you industrialize the script development.

Course objectives

  • Implement your jobs
  • Master the component library
  • Leverage the java power
  • Debug, optimize your jobs and deploy them
  • Industrialize the job development and maintenance

Course

  • Introducing Talend Integration Suite
  • Getting started with the Advanced Studio
  • The advanced features of TIS Studio
  • Centralizing and sharing your metadata in the Repository
  • Handling advanced components
  • Implementing an error management
  • Monitoring the job activity
  • Debugging your scripts
  • Working with various contexts and executing your jobs
  • Taking advantage of the Talend Community
  • Benefit from the professional support

Talend Integration Suite Administration

Upon completion of this course, you will be able to organize the collaborative development with your teams, manage projects and users; and schedule your job execution taking full advantage of the power of Talend Integration Suite.
You will be able to maintain several execution environments and make the most of hardware resources at your disposal.
Complementing the TLD201 course, this additional training day allows you to address the projects needs from the script development to the go-live.

Course objectives

  • Set the execution servers
  • Schedule your jobs
  • Deploy your jobs
  • Monitor the job execution and access the logs
  • Maintain the server part of the software

Course

  • Introducing Talend Integration Suite
  • Learning how to install Talend Integration Suite
  • Discovering Talend Administration Center
  • Discovering the Job Conductor
  • Discover the Dashboard
  • Making the most out of these resources
  • Learning how to use the CommandLine
  • Benefit from the Professional Support