Working with MySQL Databases using Talend Studio

Learn Creating Table, Eroor Handing, Schema defining, SCD Type 1 and SCD type 2

Talend Studio for Data Integration dramatically improves the efficiency of data integration Job design through an easy-to-use graphical development environment. With integrated connectors to source and target systems, it enables rapid deployment and reduces maintenance costs. It supports all types of data integration, migration, and synchronization.

What you’ll learn

  • Starting Talend Studio,.
  • Reading data from MySQL database tables.
  • Creating tables in MySQL databases.
  • Applying best practices.
  • Using database metadata.
  • Using generic schemas.
  • Updating metadata.
  • Error Handing.
  • SCD Type 1.
  • SCD Type 2.

Course Content

  • Introduction –> 5 lectures • 2hr 20min.

Auto Draft

Requirements

  • none.

Talend Studio for Data Integration dramatically improves the efficiency of data integration Job design through an easy-to-use graphical development environment. With integrated connectors to source and target systems, it enables rapid deployment and reduces maintenance costs. It supports all types of data integration, migration, and synchronization.

This course helps you use Talend Studio for Data Integration as quickly as possible. It focuses on the basic capabilities of Studio and how you can use it to build reliable, maintainable data integration tasks that solve practical problems, including extracting data from common database and file formats, transforming it, and integrating it into targets.

 

What you will Learn

  • Starting Talend Studio
  • Creating your first Job
  • Running a Job
  • Using the component help
  • Designing a Job using best practices
  • Creating and Reading Tables
  • SCD Type 1 and SCD Type 2
  • Error Handing
  • Working with delimited files
  • Working with hierarchical files
  • Creating tables in MySQL databases
  • Reading data from MySQL database tables
  • Applying best practices
  • Using database metadata
  • Using generic schemas
  • Updating metadata
  • Mapping data using tMap
  • Joining data using tMap
  • Capturing join rejects
  • Filtering data and capturing filtering rejects
  • Using other data processing components
  • Creating a built-in context variable
  • Connecting to databases using context variables
  • Creating a context group in the repository
  • Loading context variables from a flow
  • Building a stand-alone Job
  • Building a new version of the Job
  • Building a Docker image
  • Managing files
  • Processing files
  • Managing Job execution using a master Job
  • Detecting and handling basic errors
  • Raising a warning

 

Get Tutorial