Extracting gz files

CloverDX Platform
1

Hi,

Are there any ways in Clover ETL to extract gz file and generate the extracted files? I went through some related topics, but didn’t see a working solutions. Please help.

Thanks,
Sreehareesh

2

Hi Sreehareesh,

there are basically two options.

  • Write your custom Java code that will extract gzip. It can be run using Reformat component.

  • Call some third party tool from SystemExecute component.

Hope this helps.

3

Hello Jan,

Thanks a lot for the prompt response. I’ll try the solutions, even though I’m a bit unclear about the 1st option (Reformat customization)

Thanks,
Sreehareesh

4

Hi All,

One additional question here.

How can I create and build a java class in Clover ETL?

Thanks,
Sreehareesh

5

Hi,

You can simply write the transformation in the Transform dialog of reformat component, where you can convert the CTL transformation to Java using button “Convert To Java”. In the newly opened Transform editor, you can modify the Java code as needed.
ConverToJavaButton.png
If you want to use the same transformation in multiple graphs, you can create your own class and put it into trans folder. Such a file can be used in another reformat components using Transform URL, or Transform class attributes.

Other information can be found in our documentation:

In order to compile your java class you need to work with JDK.

Hope this helps.

6

Hi Jan,

Thanks for the quick reply. It seems to be helpful, we will try this out.

Cheers,
Sreehareesh