In Debezium iceberg, unable to Convert the uppercase_underscore to lowercase_underscore in Oracle connector.

[ASLDnT]

Hi Team,

We wanted to inform you about an issue we faced with our Iceberg consumer component. It was not accepting schema names, usernames, and table names in UPPERCASE_UNDERSCORE format.

To solve this, I created a dummy Oracle database on my local system and converted these names to lowercase_underscore format, which worked well. However, the real challenge we now face is that our actual source Oracle DB uses the UPPERCASE_UNDERSCORE format.

We need to convert these names directly within Iceberg without using Kafka. We attempted to use SMT (Single Message Transforms), but it appears that SMT requires Kafka, making it unsuitable for our needs.

Could someone suggest a better solution for this conversion?

Thank you, DnT

[ASLDnT]

Good Morning everyone, anyone?

[ismailsimsek]

this option is now implemented in 0.6.0.Final release

[ASLDnT]

Hi @ismailsimsek, Thank you For this release now our problem has been resolved. Thank you, DnT

[github-actions[bot]]

This issue has been automatically marked as stale because it has been open for 180 days with no activity. It will be closed in next 14 days if no further activity occurs. To permanently prevent this issue from being considered stale, add the label 'not-stale', but commenting on the issue is preferred when possible.

[github-actions[bot]]

This issue has been closed because it has not received any activity in the last 14 days since being marked as 'stale'