Skip to Main Content


Question and Answer

Connor McDonald

Thanks for the question.

Asked: January 18, 2023 - 3:06 pm UTC

Last updated: January 31, 2023 - 7:09 am UTC

Version: 19

Viewed 100+ times

You Asked


I had Oracle 12c Enterprise on Windows 64 and MariaDB 10.2 on Ubuntu .
I have been using ODBC transparent gateway to send the data from Oracle to MariaDB.

I am in the process of transitioning to Oracle Enterprise 19c on Solaris and MariaDB 10.4 on RHEL8 .
It looks like , there are no native mariadb odbc drivers for Solaris.

What is your recommendation on connecting Maria DB ( RHEL) to Oracle 19 ( Solaris ) ?
With the current licensing model , only the ODBC Transparent Gateway covered with regular licensing?

This data transfer happens once a day ( via dbms_scheduler).
At the maximum , we will have 2000 records transferred between these DBMSes.

What is the best approach ?

Thanks very much.

and Connor said...

If its only 2000 records, I would not bother with any licensing etc.

I'd just use some SQL to build a simple list of inserts that are compatible with MariaDB.

SQL scripts can be scheduled with the standard job scheduler (see ) and you'd be good to go.

Alternatively, if MariaDB has a REST interface, then pushing the data via APEX_WEB_SERVICE could also be used.

More to Explore


More on PL/SQL routine DBMS_SCHEDULER here