Skip to Main Content

Breadcrumb

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

Hi

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 https://connor-mcdonald.com/2018/06/20/the-death-of-utl_file/ ) 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

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

DBMS_SCHEDULER

More on PL/SQL routine DBMS_SCHEDULER here