1

I am trying to figure out how to create a job/transformation to uncompress and load a .tar.gz file. Does anyone have any advice for getting this to work?

analyticsPierce
  • 2,979
  • 9
  • 57
  • 81

2 Answers2

3

you want to read a text file that is compressed?

Just specify the file in the text file input step in the transformation - and specify the compression (GZip). Kettle can read directly from compressed files.

If you do need the file uncompressed then use a job step - not sure if there is a native uncompress, but if not just use a shell script step.

Codek
  • 5,114
  • 3
  • 24
  • 38
  • I do not think there is a native uncompress for this. I can do the single .gz uncompress I then end up with the .tar file that needs to be uncompressed again. maybe a two step process with a variable to handle the filename? – analyticsPierce Mar 18 '11 at 20:27
  • There DEFINATELY is. Use the "Text File Input" step and set the compression on the content tab. Best option if you dont want to do anything further with the uncompressed files. – Codek Mar 21 '11 at 12:30
-1

There is not such component in kettle to uncompress the tar.gz file i found. But if we have the csv file text compressed in gizip format we can use gzip input component.

Sagar
  • 51
  • 2
  • 8