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.

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.

キャプチャ.PNG

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.

Recommended Posts

Try using Talend Part 2
Try using Talend Part 1
Try using libGDX
Try using powermock-mockito2-2.0.2
Try using GraalVM
Try using jmockit 1.48
Try using sql-migrate
Try using SwiftLint
Try using Log4j 2.0
Try using Axon Framework
Try using JobScheduler's REST-API
Try using java.lang.Math methods
Try using PowerMock's WhiteBox
Beginners try using android studio Part 1 (Hello World)
Try using F # list
Try using each_with_index method
Try using Spring JDBC
Using Flutter on Ubuntu (Part 2)
Try using RocksDB in Java
Try using GloVe with Deeplearning4j
Try using view_component with rails
Try using Cocoa from Ruby
Try using letter_opener_web for inquiries
DB programming using EclipseLink part1
Try using IntelliJ IDEA once
Try using Spring Boot Security
Try using gRPC in Ruby
[Rails] Try using Faraday middleware
[Processing] Try using GT Force.
[Programming Encyclopedia] §2 Try using Ruby
People using docker Try using docker-compose
Try using Redmine on Mac docker
Part 1: Try using OAuth 2.0 Login supported by Spring Security 5 with Spring Boot
Try using Redis with Java (jar)
[Java] Try to implement using generics
Try using the messaging system Pulsar
Try using IBM Java method tracing
Try using Hyperledger Iroha's Java SDK
[Java] Where did you try using java?
Try using the service on Android Oreo
Try using the Stream API in Java
Study Java Try using Scanner or Map
Try using JSON format API in Java
Try using Spring Boot with VS Code
Try using Reladomo's MT Loader (Multi-Threaded Matcher Loader)
Try using JobScheduler's REST-API --Java RestClient implementation--
Try using Kong + Konga with Docker Compose.
Write Ruby methods using C ++ (Part 2) Benchmark
Try using the Emotion API from Android
Try using the Wii remote with Java
Try using simple_form / edit even child models
Try implementing GraphQL server using grahpql-java-tools (+ kotlin)