Visão Geral

Curso Talend Data Integration Visão Geral, é uma ferramenta ETL de código aberto, que habilita pequenas empresas ou negócios que podem usar essa ferramenta para realizar Extrair Transformar e Carregar seus dados em Bancos de Dados ou qualquer Formato de Arquivo. O Talend suporta diversos formatos de arquivos e fornecedores de Banco de Dados.

Objetivo

Ao concluir este Curso Talend Data Integration Visão Geral, você será capaz de realizar

• Conhecendo os conceitos básicos de ETL
  
• Saber usar o Talend Open Studio for Data Integration para trabalho real o mais rápido possível.
• Certificação de consultor Write Talend Open Studio for Data Integration 6.0

Publico Alvo

• Qualquer pessoa que esteja disposta a aprender sobre a ferramenta ETL
• Qualquer pessoa que esteja disposta a usar o Talend Studio para realizar tarefas de integração e gerenciamento de dados.

Pre-Requisitos

• Conhecimento de nível básico em ETL.
• Ter familiaridade com Java ou SQL (Não obrigatório).
• Conhecer os conceitos gerais de bases de dados.

Materiais

Conteúdo Programatico

Introduction

1. Introduction to Talend
2. Why Talend?
3. Talend Editions and Features
4. Talend Data Integration Overview

Talend Environment

1. Talend Environment – Overview
2. Repository and Pallate
3. Talend Design and Views

Talend Jobs Designing

1. Start Talend Open Studio for Data Integration
2. Create a Talend project to contain tasks
3. Create a Talend Job to perform a specific task
4. Add and configure components to handle data input, data transformation, and data output
5. Run a Talend Job and examine the results

Working with files

1. Process different types of files using Talend
2. Connect to a database from a Talend Job
3. Use a component to create a database table
4. Write to and read from a database table from a Talend Job
5. Write data to an XML file from a Talend Job
6. Write an XML document to a file
7. Use components to create an archive and delete files

Assignments

1. Assignment #1
2. Assignment #2
3. Assignment #3

Working with Database

1. Connect to a database from a Talend Job
2. Retrieve Schema from a database
3. Read data from database table
4. Load data to database table
5. Use of ETL & ELT components, understand difference
6. Transaction Management in Talend
7. Implement SCD
8. Use of Uitility & row components

 Transformations

1. Troubleshoot a join by examining failed lookups
2. Use components to filter data
3. Generate sample data rows
4. Duplicate output flows
5. Filter unique data rows
6. Perform aggregate calculations on rows
7. Extend data from one source with data extracted from a second source

Talend Context Variables

1. How to define context variables for a Job
2. How to centralize context variables in the Repository
3. How to apply context variables to a Job
4. How to use variables in a Job
5. How to run a Job in a selected context

Logs & Error Handling

1. Log data rows in the console rather than storing them
2. Employ mechanisms to kill a Job under specific circumstances
3. Include Job elements that change the behavior based on the success or failure of individual components or subjobs

Assignments

1. Assignment #1
2. Assignment #2
3. Assignment #3

Orchestration Components

1. Use components to filter data
2. Generate sample data rows
3. Duplicate output flows
4. Employ mechanisms to kill a Job under specific circumstances
5. Include Job elements that change the behavior based on the success or failure of individual components or subjobs
6. How to use tRunJob component
7. How to design Joblets and use them in Talend Job
8. Configure an individual component to use parallel execution
9. Use a Talend component to run subjobs in parallel
10. Loop through a job execution - different methods
11. Pre-Job & Post-Job activities

Managing routines ( Custom Code )

1. What are routines
2. Accessing the System Routines
3. Customizing the system routines
4. Managing user routines
5. How to create user routines
6. How to edit user routines
7. How to edit user routine libraries
8. Calling a routine from a Job
9. Use Case #1
10. Use Case #2

Talend Administration Center

1. Create a new user with design privileges
2. Create a project
3. Create a project that can be referenced by other projects
4. Assign user access privileges to projects
5. Create an SVN branch for a given project
6. Create an execution task that runs a Job
7. Generate, deploy, and run a task as a single operation
8. Generate, deploy, and run a task as three separate operations
9. Execute a task repeatedly at specified times
10. Copy a Job from one branch to another
11. Compare the differences between two versions of the same Job
12. Configure the TAC Activity Monitoring Console (AMC) to access the stored Job monitoring data