Hi
THe gateway does not need to be on the solaris machine. You can put it on
the RHEL 8 machine if there is a odbc driver for linux.
See manual 1) that even suggests this.
1)
https://docs.oracle.com/en/database/oracle/oracle-database/19/odbcu/database-gateway-odbc-introduction.html#GUID-01E50954-A8BD-400C-ACA9-7F6A7AD1BFD6
Best regards/Venlig hilsen
Peter Gram
Sæbyholmsvej 18 DK-2500 Valby
Mobile: (+45) 5374 7107
Email: peter.m.gram@xxxxxxxxx
<http://oaktable.net/members>
On Fri, 27 Jan 2023 at 18:34, Zahir Mohideen <zahir.dba@xxxxxxxxx> wrote:
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 ?
Any known issues with Oracle Solaris TG ?
Thanks very much.
Zahir Mohideen
http://mfzahirdba.blogspot.com/
*Nothing so GREAT was achieved without enthusiasm*