Ask Your Question

How to receive the entire row from Oracle CDC

asked 2019-07-02 05:11:35 -0500

cypnose gravatar image

updated 2019-07-03 04:19:23 -0500

I want to connect my Oracle DB to a file using StreamSets. I succeeded; in the file I get a SDC RECORD but I have only a ROWID and the data I've modified. So In order to recover the entire row I have to do a select. What is the best way to avoid this other select?

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted

answered 2019-07-02 12:30:45 -0500

metadaddy gravatar image

To receive the entire row without needing to issue a select query the pipeline, you need to configure Oracle LogMiner for full supplemental logging. See the Oracle CDC documentation on enabling supplemental logging.

edit flag offensive delete link more


Thanks a lot I is working ;)

cypnose gravatar imagecypnose ( 2019-07-03 04:19:05 -0500 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-07-02 05:11:35 -0500

Seen: 483 times

Last updated: Jul 03 '19