The latest version is [0.70] (April 2021). It seems like a promising ETL tool.
Links:
- Hop Blog: https://hop.apache.org/blog/
- User manual: https://hop.apache.org/manual/latest/
(Latest) Main features:
- Dark Mode
[Menu] Tools > Look & Feel Tab, click on ‘Dark Mode’ checkbox. Restart - Kettle Importer!
File > Import from Kettle/PDI
Browse to your Kettle folder for a .ktr file
Select in field ‘Import in Project’: default
Click on ‘import’
Open your workflow that should be on your ‘./hop’ folder as .hpl files - Git Diff on the HOP Gui
To run your own HOP:
- Use a Docker container:
$ docker run apache/incubator-hop - Or install HOP
Requirements: java 8, Java 11- Download page: https://hop.apache.org/download/
Binaries: https://www.apache.org/dyn/closer.cgi?filename=incubator/hop/0.70/apache-hop-client-0.70-incubating.zip&action=download [396MB]
Source: https://www.apache.org/dyn/closer.cgi?filename=incubator/hop/0.70/apache-hop-0.70-incubating.tar.gz&action=download [11.8MB] - Unzip
- Edit ./hop/hop-gui.sh (or \hop\hop-gui.bat) to increase memory
From:
if “%HOP_OPTIONS%”==”” set HOP_OPTIONS=-Xmx2048m
To:
if “%HOP_OPTIONS%”==”” set HOP_OPTIONS=”-Xmx3096m” - You may also need to set java version after :NormalStart :
SET JAVA_HOME=”D:\Software\jdk-11.0.11″
- Download page: https://hop.apache.org/download/
Start it with:
./hop/hop-gui.sh
- To see an example:
File > Open
Browse to: ./hop/config/projects/samples/transforms
Double click on on a file - To start a new ‘workflow’:
File > New > Pipeline
File > New > Workflow - The following is a Kettle transformation migration to a HOP pipeline:
Notes:
- It feels weird thatwindow dialogs are open on any click, it takes time to get used to.
- You can still edit the .hpl as an XML file like Kettle/PDI 🙂
- Files are stored in the default folder:
\hop\config\projects\default - In a transformation import, I lost fields information on Excel Step. It might be that config pages are set differently.
Interesting IT Tip's 