CloverETL Integration with GoldenGate

Support questions related to CloverETL Server

sameerj365
Posts: 17
Joined: Tue Mar 25, 2014 8:39 am

CloverETL Integration with GoldenGate

Postby sameerj365 » Mon Jan 12, 2015 8:37 am

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.

kubosj
Posts: 372
Joined: Thu Jan 12, 2012 9:10 am

Re: CloverETL Integration with GoldenGate

Postby kubosj » Tue Jan 13, 2015 5:45 pm

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.
Jaroslav Kubos
CloverCARE Support
CloverETL | Rapid Data Integration

Visit us online at http://www.cloveretl.com


cron