CloverETL Integration with GoldenGate

Hi,

Is there any mechanism thru which CloverETL can read Goldengate trail files. These trail files are written by Golden gate process and are in binary form. We want to convert them back to data files.

Currently, Ab initio has Goldengate component and it can read the trail file and read the data. Wanted to check whether similar kind of mechanism is possible (may be custom component) using CloverETL.

Hi sameerj365,

We do not have special connector for this kind of files. You have at least 3 workarounds:

  1. Use generic reader like ComplexDataReader. Because this format is quite complex, it won’t be easy.

  2. Try to use logdump (or this or this) for dump into plain text file which can be extracted using UniversalDataReader.

  3. Write custom transformation for component Reformat. This transformation would be implemented using official Java library.

I hope this helps as overview of options.