Ask Your Question

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 -0600

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

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

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


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 -0600 )edit
Login/Signup to Answer

Question Tools



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

Seen: 80 times

Last updated: Sep 26 '18