SMT debezium to replace a string with another in topic name

Kafka Connect Self-Managed Connectors
1

hi,

I have a Debezium connector that pulls data from SQL server tables.
It seems the connector creates the topic name like Server.Database.Table.

I want Server.Database.invitation.Sent.V1 - to be transformed to invitation.Sent.V2
where invitation.Sent.V1 is the table name

Is there a Transform to apply where I can

  1. remove Server.Database
  2. replace V1 with V2
    in all topics being generated

thanks

2

Yes, you should be able to do this with the standard RegexRouter SMT: RegexRouter | Confluent Documentation

3

Thanks, i could do it with RegexRouter