Oracle CDC not reading data from Origin

asked 2019-04-09 14:06:30 -0500

anonymous user

Anonymous

Dear Team, I am not able to read the data from Oracle to Postgre using Oracle CDC with the latest version 3.8, I am using very latest version with an ojdbc7 driver. can you guide me how will I read using Oracle CDC.

Thanks.

edit retag flag offensive close merge delete

Comments

1

Are you getting any errors? Did you follow steps to enable LogMiner, supplemental logging, etc. outlined here https://streamsets.com/documentation/datacollector/latest/help/datacollector/UserGuide/Origins/OracleCDC.html#concept_rs5_hjj_tw?

iamontheinet gravatar imageiamontheinet ( 2019-04-09 14:12:36 -0500 )edit

@Dash Earlier it was working fine earlier but Recently Upgraded my Streamsets to 3.8. after that only it's not working and I am not getting any error but my oracle cdc client not reading the data from origin. Which version of jdbc it will work fine with the latest version of Streamsets? Thanks.

Dep gravatar imageDep ( 2019-04-10 07:49:00 -0500 )edit

I am not 100% sure it's a version issue but try ojdbc8. That has worked for me in the past but I've also never tried using any other version.

iamontheinet gravatar imageiamontheinet ( 2019-04-10 11:13:39 -0500 )edit

I tried with the same version ojdbc8, but still, I am not getting the data from origin using oracle cdc client

Dep gravatar imageDep ( 2019-04-10 13:16:14 -0500 )edit