Talend Online Training

Talend Overview

What is Talend?

Talend is the first provider of open source data integration software. Its main product is Talend Open Studio. After three years of intense research and development investment the first version of that software was released in 2006. It is an Open Source project for data integration based on Eclipse RCP that primarily supports ETL-oriented implementations and is provided for on-premises deployment as well as in a software-as-a-service (SaaS) delivery model. Talend Open Studio is mainly used for integration between operational systems, as well as for ETL (Extract, Transform, Load) for Business Intelligence and Data Warehousing, and for migration. Talend offers a completely new vision, reflected in the way it utilizes technology, as well as in its business model. The company shatters the traditional proprietary model by supplying open, innovative and powerful software solutions with the flexibility to meet the data integration needs of all types of organizations.

Talend Open Studio is the most open, innovative and powerful data integration solution on the market today.

Main features and benefits of that solution:

• Business modeling
• Graphical development
• Metadata-driven design and execution
• Real-time debugging
• Robust execution

Provided as a packaged, out-of-the-box, ready-to-install platform, Talend Open Studio meets data integration requirements of all organizations - regardless of their size or level of data integration expertise.

There are also available Talend Open Studio extensions:

Talend Integration Suite - The first Open Source enterprise data integration solution, Talend Integration Suite supports the tough requirements of enterprise development, and scales to the highest levels of data volumes and process complexity.
Talend On Demand - The industry's first data integration Software as a Service (SaaS), Talend On Demand consolidates Talend Open Studio metadata and project information in an online, shared repository hosted by Talend.
Talend Open Profiler - The first open source data profiling tool, Talend Open Profiler, allows business users or data management staff to define a set of indicators for each data element that needs to be analyzed or monitored. It produces sophisticated reports and graphs that let users gauge at a glance the level of quality of the data, and the status of the indicators that were defined.
Talend Data Quality - The first open source data quality solution with enterprise-grade features and technical support, Talend Data Quality is a graphical data quality management environment that processes data, such as addresses, phone numbers, spellings, synonyms and abbreviations. Talend Data Quality includes both data profiling and data cleansing capabilities.

Introduction On Talend DI for Big Data:

• About Talend Corporation and Their Journey
• Products under Talend Platform?
• What is Talend?
• Advantages of using Talend over other competitor integration tools?
• Why Talend is getting popular in the current trend?
• Talend Installation System Requirements?
• Types of repository connections to connect Talend Studio?
• Use of workspace, Project?
• What is Big data!!! List of software platforms come under Big data?
• What is Hadoop and How it is different from traditional technologies?
• What are the advantages with using Hadoop? In cost and Architectural feasibility prospective.
• High level Hadoop cluster architecture and physical core components
• Hadoop eco system components.
• what are the challenges in Implementing a Big data project with conventional Hadoop framework?
• Pros and Cons in using Talend BD DI compared to conventional Hadoop eco system components?
• Talend Architecture and its components.
• Demo on Talend sample job design and execution.

Talend GUI and Internal Tools

• Main window
• Menu bar and tools
• Repository tree view
• Design Workspace
• Palette
• Configuration tabs
• Outline and code summary panels
• window — show view, preferences

Brief explanation on

• working with Projects – Create, open, import, delete, export project
• Job: Create job, Add desired components to job
• Types of component connection links
• Row connection: Main, Reject, Unique, Duplicate, Iterate connection
• Trigger connection: on subjob ok, on component ok, onsubjob error, on component error, run if
• How to change label format for components and component connections
• Component connection indicators
• How do I determine Job starting point?

Centralize Metadata and Schemas

• Database connection
• Flat file, Excel file, XML file
• Hadoop cluster
• FTP
• Schema types and difference between the schemas.

Data Validation:

• Roll of Die on error
• Enable & Disable reject flows
• Capture rejected data prior to job failure
• Input data validation against the schema object
• Lab practical

Pre-requisites to design and execute a Talend job

• How to determine and fix Talend job errors with the help of problems tab.
• Major and commonly using components
• File
• Database
• Logs & Errors
• Orchestration
• System
• Lab practical with combination of above components

Essential processing components:

• tConvertType
• tFilterRow
• tSortRow
• tJoin
• tMap
• tAggregateRow
• Comparison between tJoin and tMap components

Data Mapping:

• Basic mapping
• Expressions in tMap
• Conditional logic with ternary operator
• Variables, Filters usage in tMap expressions
• Row split into multiple routes
• Joins in tMap
• Reload at each row lookup
• Reject data handling in tMap
• Testing expressions
• Built in Functions
• Lab practical with tMap

More Practical on:

• File – Multi structure, Regex
• Orchestration — tFlowtoIterate, tLoop
• XML readers/writers — tXMLMap

Context Variables:

• what is globalMap variables and how to use globalMap variables
• Context group creation
• Add a context group to job
• Add contexts to context group
• tContextLoad, Implicit Load context from a file, tContextDump
• Context file location assignment with operating system environment variables
• Talend Job debugging

Custom Java in Talend

• Conditional logic implementation with tjava & tJavaRow
• Set context and globalMap variable values with tJava
• Code routines
• How to use external java classes
• Difference between tJavaRow and tJavaFlex

Talend with Database reader and writers: (S3)

• Read from database tables
• How to use context,glomapMap variables in sql override
• Print sql override query in output log
• Write to database table
• Database connection session management, Shared database connection
• Column selection for Update, Insert operation
• Rejects and error management – Bulk load

Logging and Testing

• Log console output to an operating system file
• Custom job killing using system.exit(<custom return code>)
• Code deployment & execution
• Compiled executables – JAR files
• Select desired context group from context group list
• Command line context parameters
• Job dependency management
• Return codes from child job without Die
• Parent & child job management

Miscellaneous

• Miscellaneous components — FixedFlowInput, tRowgenerator, tMemorizerows, tBufferInput, tBufferOutput
• CDC implementation in Talend
• SCD2 implementation in Talend
• Incremental Loading
• Unit testing
• Joblets
• Difference between Talend open studio and Talend Enterprise edition
• Jobs execution in parallel
• tParallelize vs Multi thread execution

Theory on Enterprise edition features

• Remote Repository connections
• Sandbox Project
• @Reference project
• SVN branches
• Lock Types – Checkin, Checkout
• Talend Administration center
• Talend Activity monitor console
• Talend SDLC – Job deployment process
• Job publishing into Artifact repository — From studio or command
• Difference between Job Server & Runtime server
• Talend products related to DI Prospective:
• Talend open studio – Data Integration edition, Bigdata edition
• Talend Subscription Solutions – DI, BD – Bigdata, Bigdata platform, Real-time Bigdata platform

Attend Live Demo Today!!
Contact Now!!
USAONLINETRAINING.COM
CALL : +91 9160401016
MAIL : [email protected]

No. of Days:	30
Total Hours:	30
No. of Participants:	5