Lorem ipsum dolor sit amet, conse ctetur adip elit, pellentesque turpis.

  • No products in the cart.

Image Alt

Enterprise Data Integration using Talend

  /    /  Enterprise Data Integration using Talend

Enterprise Data Integration using Talend

Categories:
Other Key Trainings
Reviews:

Course Overview:

Talend is a leader in cloud and big data integration software that fosters organizations to become data driven by making data more accessible, improving its quality and quickly moving it where it’s needed for real-time decision making.

First and only open source company in Leaders quadrant in Gartner Report – Unified platform, Big Data and Cloud Integration, Batch and Real time data integration.

Talend Open Studio for Data Integration is an open Source ETL Tool, which means businesses can use this tool to perform Extract, Transform and Load their data into various data sinks like RDBMS etc.

Course Structure

The program is focused on enhancing data handling and integration capabilities. Create ETL jobs that connect to almost any data source, Filter, Modify, unite data, Build standalone jobs that run on a schedule or based on an event and Make jobs more user-friendly for non-technical users. This course also covers Talend Big Data integration aspects (Hortonworks Distribution)

Productivity Objectives:  

Upon completion of this course, you should be able to:

  • Learn about Talend as a ETL tool
  • Compare Talend with other Key ETL tools
  • Learn about Talend Studio
  • Work with Talend Open Studio
  • Perform Data Integration of lot of data sources
  • Learn Best Practices, troubleshooting
  • How to perform CI/CD with Talend

The intended audience for this course

  • Developers
  • Bigdata Developers
  • Data Engineers
  • Integration Engineers
  • Architects
  • Data Steward
Overview
  • Introduction To Talend
  • Why Talend?
  • Talend Vs Other Tools
  • Logical Architecture
  • More On Data Integration Aspects
  • Talend Open Studio Walkthrough
  • Key Components In Palette
  • Installation
  • Conclusion
Managing Metadata
  • Introduction
  • Working with Built-In Schema
  • What are Generic Schemas?
  • Advantages of Generic Schemas
  • Generating Generic Schema
  • More on Working with Schemas
Data Validation
  • Introduction
  • Enabling And Disabling Reject Flows
  • Validating Against The Schema
  • Rejecting Rows Using tMap
  • Checking A Column Against A List Of Allowed Values
  • Checking A Column Against A Lookup
  • Creating Validation Rules For More Complex Requirements
Data Transformation
  • Introduction
  • Mapping Data
  • Working with tMap Expressions
  • Filtering Input Data
  • Joining Data Using tMap
Managing Context Variables
  • Introduction
  • Working with A Context Group
  • Linking Context Group with Job
  • Adding Contexts To A Context Group
  • Integrating Context with OS variables
Working With Databases
  • Introduction
  • Setup Connection
  • Importing Schemas
  • Reading Tables
  • Dynamic parameters to query
  • Debugging and Printing your input query
  • Storing results in Database Table
  • Dealing with Database Sessions
  • Working with Child Job
  • Error Handling
Integration with Enterprise apps via XML, Webservices etc.
  • Introduction
  • Consuming CSV data
  • Consuming XML data
  • Writing XML data
  • Working with Nested data
  • Invoking Web Services
  • Reading And Writing To A Queue
Troubleshooting and Testing
  • Introduction
  • How to troubleshoot?
  • Debugging errors
  • Logging
  • Building Test Cases
  • Generating Test Data
Software Development Lifecycle
  • Working With Git And Talend
  • How To Perform Ci/Cd With Jenkins And Talend?
  • Job Monitoring Using Resource Manager Ui
  • Unit Testing
  • Best Practices
  • Joblets
  • Parallelization
  • Reusing Jobs (Child Jobs)
  • Joblets
  • Context Variables
  • Using Repository

Participants should preferably have basic knowledge of a programming language like Java. The participants must be familiar with RDBMS and SQL language.

Course Information

Duration

3 Days

Mode of Delivery

Instructor led/Virtual

Reach out to us..Our representative will get back to you!



Post a Comment