3.5 out of 5
3.5
188 reviews on Udemy

Data integration (ETL) with Talend Open Studio

Talend - from basics to advanced technics.
Instructor:
Andrejs Zaharovs
661 students enrolled
English [Auto-generated]
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
Make jobs more user-friendly for non technical users

If you want to simplify your data interactions than Talend Studio is the right product for you, but if you don't want to spend a fortune on training or books are not your preferred method than this course is exactly for you.

Within this course over the stretch of 8 hours you will learn how to install Talend how to navigate and use the interface efficiently. How to import data into Talend and then perform various transformation of data, cleansing, filtering, lookups, concatenations and much more. You will also learn some advanced features of Talend and how to work with different databases. Finally you will learn how to debug, log job information and monitor statistics of jobs that you build and schedule to run automatically.

This course will provide more than 8 hours of video material in 720p with full voice over and every example showcased will be available to you as a zip file attachment.

So if you want to quickly learn how to efficiently use Talend sign up.

Promise:

In addition to the 7 main sections of the course, each week a new video will be uploaded after the course is published for at list 13 weeks.

Those videos will cover advanced topics, obscure Talend features you might find useful and tips and tricks. For instance – How to inject other application functionality into Talend.

Talend Basics

1
Introduction

This is a quick introduction into the course.

Note: All materials of a section are attached to the first lesson.

2
Linux Installation

In this lesson we will be looking at how to install Talend on Linux.

For my example I am using Ubuntu, but you can use any other Linux flavour.

Note: All materials of a section are attached to the first lesson.

3
Windows Installation

In this lesson we will be looking at how to install Talend on Windows.

I will be using Windows 7 as an example.

Note: All materials of a section are attached to the first lesson.

4
Talend UI

We will go though the user interface of Talend.

Note: All materials of a section are attached to the first lesson.

5
Taking a look at the Repository Tab

In this lesson we will be looking at context variables and metadata.

Note: All materials of a section are attached to the first lesson.

6
Repository Tab in more detail

We are continuing our examination of context and metadata in Talend.

Note: All materials of a section are attached to the first lesson.

7
Context and Metadata

... and a bit more.

Note: All materials of a section are attached to the first lesson.

8
More on Context and Metadata

This is the final lesson on context and metadata. I promise.

Note: All materials of a section are attached to the first lesson.

9
Headers

In this lesson we will take a look at different ways of creating Headers.

Note: All materials of a section are attached to the first lesson.

Data Mapping

1
Mapping Data

In this lesson we will be looking at one of the most important components in Talend - tMap

Note: All materials of a section are attached to the first lesson.

2
Data Generation

In this lesson I will show you how to quickly generate dummy data.

Note: All materials of a section are attached to the first lesson.

3
Outputing tMap Rejects

Continuing with tMap component.

Note: All materials of a section are attached to the first lesson.

4
Filtering Mapped Data

A couple of more things on tMap.

Note: All materials of a section are attached to the first lesson.

5
Mapping Database Data

Looking at how tMap can be used with Databases.

Note: All materials of a section are attached to the first lesson.

Conversion, Extraction, Join

1
Regex Expressions

In this lesson we will look at ways we can use Regex expresions to extract required data from differnt types of files.

Note: All materials of a section are attached to the first lesson.

2
XML to CSV conversion

In this lesson we will look at how to convert XML to a CSV file.

Note: All materials of a section are attached to the first lesson.

3
CSV to XML conversion

In this lesson we will do the reverse and convert a csv file into an XML file.

Note: All materials of a section are attached to the first lesson.

4
Advanced XML

In this lesson we will take a look at some of the advanced XML features present in Talend.

Note: All materials of a section are attached to the first lesson.

5
Joining Data

In this lesson we will look at other ways of joining data.

Note: All materials of a section are attached to the first lesson.

6
Splitting Data

Here we will look at how we can split data.

Note: All materials of a section are attached to the first lesson.

7
Performing Advanced Data Lookups

This lesson will show you how to perform advanced data lookups.

Note: All materials of a section are attached to the first lesson.

8
Uniting Data

Here I will learn of another way to join data.

Note: All materials of a section are attached to the first lesson.

Helpful features

1
Retreating and working with File Properties

In this lesson we will look at how we can retrieve helpful file information.

Note: All materials of a section are attached to the first lesson.

2
Row Count

In this lesson I will show you how to perform the fastest possible row counts on a file.

Note: All materials of a section are attached to the first lesson.

3
Temp, Delete, Move, Rename

We will talk about how to use temp files, how to delete, move and rename files using Talend.

Note: All materials of a section are attached to the first lesson.

Java

1
Basics tJava component

In this lesson we will look at how to use tJava component in Talend.

Note: All materials of a section are attached to the first lesson.

2
More features of tJava component

In this lesson we will look at more examples on how to use tJava.

Note: All materials of a section are attached to the first lesson.

3
tJavaRow component

tJavaRow is another component in which you can write custom Java code and in this example we will look at how it can be used.

Note: All materials of a section are attached to the first lesson.

4
tJavaFlex component

Yet another Java custom code component.

Note: All materials of a section are attached to the first lesson.

5
Custom Routines

In this lesson we will look at how custom routines are created in Talend.

The example will showcase how to make a routine that will convert EPOCH time to human readable and vice versa.

Note: All materials of a section are attached to the first lesson.

Databases

1
Databases in Talend

In this lesson we will have a quick overview of different Database connectors that Talend offers out of the box.

Note: All materials of a section are attached to the first lesson.

2
Working with Hyper SQL (HSQL)

HSQL or Hyper SQL is a fully supported RDBMS database within Talend and in this lesson we will look at ways we can use it to quickly create a database without running any DB Servers locally or remotely.

Note: All materials of a section are attached to the first lesson.

3
Looking at Table Schema's

In this lesson we will look at how we can import Table Schemas in to Talend repository.

Note: All materials of a section are attached to the first lesson.

4
Importing Table Schema's

More on Table Schemas.

Note: All materials of a section are attached to the first lesson.

5
Reading Data from a Database

Here we will look at how read from a database.

Note: All materials of a section are attached to the first lesson.

6
Writing Data to a Database

Here we will look at how to write to a database.

Note: All materials of a section are attached to the first lesson.

Debugging, Logging, Building, Scheduling

1
Debugging

In this lesson we will examine the various ways we can debug our jobs when something goes wrong.

Note: All materials of a section are attached to the first lesson.

2
Reject Handling

This lesson will show you different ways of handling data rejects.

Note: All materials of a section are attached to the first lesson.

3
Reject Handling with tMsgbox component

This lesson will show you another way you can handle data rejects, which is more userfrandly.

Note: All materials of a section are attached to the first lesson.

4
Saving Console Log to a flat file

In this lesson we will look at how we can save the console log to a file.

Note: All materials of a section are attached to the first lesson.

5
tMap Input Reject Handling

In this lesson we will quickly go back to tMap component and look at how to capture input rejects.

Note: All materials of a section are attached to the first lesson.

6
Logging Job Information

In this lesson we will look at how to log job information.

Note: All materials of a section are attached to the first lesson.

7
Monitoring Jobs

In this lesson we will look at how to monitor parts of the job.

Note: All materials of a section are attached to the first lesson.

8
Building Talend Jobs

In this lesson we will finally take a look at how we can build a job in Talend so that it can work standalone.

Note: All materials of a section are attached to the first lesson.

9
Adding context from command line

In this lesson we will look at ways to add context values for a build job without using Talend Studio.

Note: All materials of a section are attached to the first lesson.

10
Additional context variable modifications

Here we will look at some other ways we can modify the context of a built job.

Note: All materials of a section are attached to the first lesson.

11
Scheduling Talend Jobs

In this lesson we will look at how we can schedule a job in windows using Task Scheduler.

Note: All materials of a section are attached to the first lesson.

Extras

1
Sub Jobs

In this lesson we will take a look at sub jobs and how you can link multiple jobs together. In addition we will take a quick look at another component called tRestClient with which you can make REST calls.

The example will show how to rerun the job with the previos context value without the need to save it manualy.

2
Custom Components

In this lesson we will take a look at custom components.

  • The lesson will cover how to:
  • Ways to install custom components;
  • How to delete custom components;
3
Creating a job with tFileExcel* (Custom Components)

In this lesson we will continue looking at custom components we installed in lesson 49 - Custom Components and take a closer look at tFileExcel* components created by Jan Lolling.

We will create a job based on these components using a client scenario that you might run into.

4
Using tSystem Component

In this lesson we will take a look at how you can inject other application functionality into Talend Open Studio using the standard tSystem component. The example will also require that you run this on a Windows machine and have PuTTY installed.

You can download PuTTY from thelink provided. Make sure you download "A Windows installer for everything except PuTTYtel".
5
Using tSCP* components

This lesson is a folow up lesson to "Using tSystem Component" and it will show a simpler way of uploading/downloading data between two computers.

You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
3.5
3.5 out of 5
188 Ratings

Detailed Rating

Stars 5
57
Stars 4
71
Stars 3
36
Stars 2
14
Stars 1
11
e932109111aa9134caf9fa34f1088f03
30-Day Money-Back Guarantee

Includes

9 hours on-demand video
Full lifetime access
Access on mobile and TV
Certificate of Completion