Ask Your Question
1

If I have a CDC origin (e.g. Oracle CDC) do I need to create multiple JDBC producer for each table. Looking at the config it seems so.

asked 2018-09-26 13:43:14 -0500

andy gravatar image

JDBC producer configuration seems to allow one table mapping. If I have a transaction with multiple tables do I need to create multiple JDBC producers

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted
0

answered 2018-09-26 19:10:45 -0500

metadaddy gravatar image

You can configure the JDBC Producer's Table Name with an expression. So, if the table name is in the field value /tablename, you would use ${record:value('/tablename')}

edit flag offensive delete link more

Comments

Thank you for the response. Looks like the "field to column mapping" in JDBC can be specified for a table, if the CDC origin sends say 2 tables (T1 and T2) which I need to map to say T3 (t1 to t3) and T4 (t2 to t4) on the target I think I need to use two JDBC producers

andy gravatar imageandy ( 2018-09-26 20:12:39 -0500 )edit
Login/Signup to Answer

Question Tools

2 followers

Stats

Asked: 2018-09-26 13:43:14 -0500

Seen: 30 times

Last updated: Sep 26