Try using Talend Part 1

Background

At the company, I heard that I might do a development project using Talend next time, and I felt like I wanted to touch it for a moment. We haven't decided on a specific job yet, so we are often told that we're gone, but everything is studying.

What is Talend in the first place?

An ETL tool that reads and processes data. There are many other ETL tools, but many are expensive, but Talend is free to use.

• There seems to be a paid version, but it seems that all the basic functions can be used free of charge, which is also one of the features. Even if you can't program, you can process data! That is the feature of this kind of tool. It seems that Talend runs on Java and you can also code and create components yourself.

This goal

Install Talend and create a simple job to confirm that it worked.

Development environment

PC：ThinkPad X1 Carbon 2017 OS：Windows 10 CPU：Core i7-7500U Memory: 16GB It doesn't seem to have much to do with anything other than the OS ...

Environment

[[Introduction to Talend Open Studio 01] Building a development environment. Let's install Talend](https://tasokori.net/%E3%80%90talend-open-studio-%E5%85%A5%E9%96%8001%E3%80%91%E9%96%8B% E7% 99% BA% E7% 92% B0% E5% A2% 83% E3% 82% 92% E6% A7% 8B% E7% AF% 89% E3% 81% 99% E3% 82% 8B /)

I basically referred to here. I will write mainly about things that didn't go well here.

1. 1. Download JDK 8

http://www.oracle.com/technetwork/java/javase/downloads/jdk8-downloads-2133151.html Get the JDK from oracle. The version is 8. I downloaded 7 on the reference site, but here it is 8.

2. Download Talend

https://www.talend.com/products/talend-open-studio/?qt-product_tos_download=3 Talend supports different Java versions depending on the version. 6.1? 6.2? It seems that Java 7 was supported until then.

• Since 5.6 is used on the reference site, 7

I'm Windows, so click on the red circle. If you look at the version of Talend downloaded here, 7.0 will drop. Java support here seems to be 8.

Also, as of August 2018, as shown in the image, the layout is such that the products are lined up in a list. There is a description that the tab is ..., but it seems that it is not possible to operate the tab and select the target product or version. Did the layout of the site change?

After that, I feel like I'm doing the same work one by one. Start Talend by answering to any folder If you have installed a JDK other than the one supported this time, you need to take action there as well.

Try to make a simple job

[[Introduction to Talend Open Studio 02] Convert CSV data. Let's start with how to use Talend. ](Https://tasokori.net/%E3%80%90talend-open-studio-%E5%85%A5%E9%96%8002%E3%80%91csv%E3%83%87%E3%83% BC% E3% 82% BF% E3% 82% 92% E5% A4% 89% E6% 8F% 9B% E3% 81% 99% E3% 82% 8B% E3% 80% 82% E3% 81% BE% E3% 81% 9A% E3% 81% AF% E3% 83% 95% E3% 82% A1% E3% 82% A4 /)

I made a job to get CSV, edit it, and output it. It's not the first time I've used an ETL tool, so I was able to do it smoothly. It runs on Java, so I thought it would be easier to handle if you knew Java.

Next schedule

In Part 2, I would like to build a DB or environment on a virtual server, and then take data from it and create something to do with it.