Ask Your Question
0

How to specify the Table name pattern in the Oracle CDC Client tab

asked 2018-09-13 00:50:07 -0500

Mahalakshmi gravatar image

updated 2018-09-13 23:24:08 -0500

Maithri gravatar image

It has been specified that the Table Name pattern in the Oracle CDC tab should be specified as SQL like syntax. But whatever pattern we try, it is not taking up. We also tried just giving '%' as it specified in the streamsets documentation that % will retrieve all the tables in the particular schema. But that also didn't work.

Please do let us know how the table name pattern is specified.

Thanks

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted
0

answered 2020-06-09 09:50:06 -0500

iamontheinet gravatar image

Hi!

Not sure if you've upgraded since you ran into this issue, but in SDC 3.16, you can use pattern like so % or table_prefix%

Cheers, Dash

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

2 followers

Stats

Asked: 2018-09-13 00:50:07 -0500

Seen: 231 times

Last updated: Jun 09