This instructor led two day Talend Open Studio course enables you to use Talend Open Studio for Data Integration for project work as quickly as possible. It focuses on the basic functionality of the Studio and how it can be used to build reliable, maintainable data integration tasks that solve practical problems: extracting data from common database and file formats, transforming it, and integrating it into targets. The skills learned in this course are applicable to the entire Talend product line. This course serves as the basis for all Talend training and is the prerequisite for many of the other courses.

After completing this class, you will be able to:

  • Start Talend Open Studio for Data Integration
  • Link Talend Studio to your Talend account, registering a new account if necessary
  • Create a Talend project to contain tasks
  • Create a Talend Job to perform a specific task
  • Add and configure components to handle data input, data transformation, and data

Output

  • Run a Talend Job and examine the results
  • Build a visual model of a Talend Job or project
  • Copy an existing Job as the basis for a new Job
  • Store configuration information centrally for use in multiple components
  • Extend data from one source with data extracted from a second source
  • Log data rows in the console rather than storing them
  • Troubleshoot a join by examining failed lookups
  • Use components to filter data
  • Generate sample data rows
  • Execute Job sections conditionally
  • Duplicate output flows
  • Create a schema for use in multiple components
  • Create variables for component configuration parameters
  • Run a Job to access specific values for the variables
  • Employ mechanisms to kill a Job under specific circumstances
  • Include Job elements that change the behavior based on the success or

Failure of individual components or subjobs

  • Connect to a database from a Talend Job
  • Use a component to create a database table
  • Write to and read from a database table from a Talend Job
  • Filter unique data rows
  • Perform aggregate calculations on rows
  • Write data to an XML file from a Talend Job
  • Use components to create an archive and delete files
  • Use a Talend component to access a Web Service method
  • Extract specific elements from a Web Service reply
  • Store Web Service access information for use in multiple Jobs
  • Write an XML document to a file
  • Add comments to document a Job and its components
  • Generate HTML documentation for a Job
  • Export a Job
  • Run an exported Job independently of Talend Open Studio
  • Create a new version of an existing Job

Day 1:

  • Starting Talend Open Studio
  • Creating a Job
  • Reading Input
  • Transforming Data
  • Running a Job
  • Combining Columns
  • Building a Business Model
  • Duplicating a Job
  • Creating Metadata
  • Creating a Join
  • Capturing Join Failures
  • Correcting the Lookup
  • Updating the Business Model
  • Generating Rows
  • Creating the Join
  • Adding Constraints
  • Replicating Output
  • Using Context Variables
  • Using Repository Context Variables
  • Handling Errors

Day 2:

  • Working with Databases
  • Creating a New Project
  • Creating Customer Metadata
  • Creating the Customer Table
  • Creating the Product Table
  • Setting up Sales Files
  • Setting Up the Shop Staging Table
  • Joining the Data
  • Finalizing the Job
  • Working with Web Services
  • Accessing a Web Service
  • Using Advanced WSDL Processing
  • Documenting the Job
  • Running Jobs Standalone
  • Exporting a Job
Print Friendly, PDF & Email