oracle to mariadb Migration

[karthik M]

Hello,

I’m currently exploring the feasibility of setting up a Change Data Capture (CDC) pipeline for migrating data from Oracle to MariaDB using Debezium. While I could find some documentation for Oracle and PostgreSQL/MySQL setups, I haven’t been able to locate anything specific that confirms or guides an Oracle → MariaDB use case. I wanted to reach out to see if this migration path is officially supported or technically feasible with Debezium. If so, are there any documents, examples, or recommendations that will be helpful to me.l Any help or guidance would be greatly appreciated.

Best Regards,

[Chris Cranford]

Hi -

As discussed on Zulip, the set up to do Oracle to MariaDB would be identical to that of Oracle to MySQL or even PostgreSQL as long as you are using Debezium 2.7+ where we added explicit MariaDB support to the JDBC sink connector.

Generally the only variances between target systems is your `database.url` and credentials along with potentially implementing specific naming transforms [1] depending on your source and target databases. These naming transforms are important because the JDBC sink treats all column names as case sensitive, and with Oracle as the source, columns in the event are in upper-case but target systems like MySQL, MariaDB, and PostgreSQL store columns in lower-case unless they're quoted. Therefore it's important that you either (a) enabled quoted identifiers or (b) using the naming transforms so that the field names are converted to the expected default case of the target database to avoid schema evolution concerns.

Thanks,
-cc

[1]: https://debezium.io/documentation/reference/stable/connectors/jdbc.html#_naming_transformations