how to define "Table Name Pattern" for more than 1 table in ChangeCaptureMySql processor configuration file

[#1]

Hi,

how to define "Table Name Pattern" for more than 1 table in ChangeCaptureMySql processor configuration file.  I tried below patterns where "product_types" and "user_subscription" table names. I want to read data only from these tables.

[product_types|user_subscription]_ or [product_types|user_subscription]%

[#2 · Accepted solution]

@AbhishekSingh ,

The pattern expression must be a regular expression (regex).

The regex equivalent to your LIKE pattern is:

(product_types|user_subscription).*

Cheers,

André

[#3]

Hello @araujo 

This does not work, i tried to use the above expression and the changeMySql does not use it.

So far i can do the following

- whitelist individual tables

- include all tables (by setting the table name pattern to empty)

This is a problem for us, we need to whitelist tables, since the dB user we use does not have access to all tables and the processor complains without the filtering.

Manually filtering one table at a time, is not a scalable approach since we need to extract data from multiple tables and this processor does not support incoming connections.

Did anyone find a solution where one instance of "CaptureChangeMySQL" can extract data for multiple tables ?

[#4]

Anyone else experienced this issue ? is there a solution that does not involve creating one CaptureChangeMySQL processor instance per source table ?

[#5]

Anyone else experienced this issue ? is there a solution that does not involve creating one CaptureChangeMySQL processor instance per source table ?