Training Partner

Talend

Talend is the first provider of open source data integration software. After three years of intense research and development, and with solid financial backing from leading investment firms, Talend revolutionized the world of data integration when it released the first version of Talend Open Studio in 2006. Talend's solutions are used primarily for migration and integration between operational systems, as well as for ETL (Extract, Transform, Load) for Business Intelligence and Data Warehousing. Unlike proprietary, closed solutions, which can only be afforded by the largest organizations, Talend makes enterprise-class data integration solutions affordable to organizations of all sizes.

 
TLD101 - Talend Open Studio

TLD101 - Talend Open Studio

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

Syllabus

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)

Participating in the Talend community

  • Use the community tools (Forum, BugTracker)
  • Exchange with community members

Audience

Talend Open Studio and Talen Integration Suite users

Prerequisites

None

Class training

  • Duration : 3 day(s)
  • Price : 1895 $CAD
  • Register : Calendar