Course Description
This instructor led two day Talend studio for data integration 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.
Course Outcomes
At the end of the course, learners 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
- 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
- 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
Course Summary
Next Public Course Dates | |
Prerequisites |
|
Duration |
|
Available Formats |
|
Course Modules
- 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