Re: Oracle Transparent Gateway on Solaris

From: Peter Gram <peter.m.gram_at_gmail.com>
Date: Fri, 27 Jan 2023 18:44:55 +0100
Message-ID: <CAJ=80GXLd3BJ2z1ZfDScg2NP-5pccwRVFgh6ShD4mTpae_6YZQ_at_mail.gmail.com>



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_at_gmail.com

<http://oaktable.net/members>

On Fri, 27 Jan 2023 at 18:34, Zahir Mohideen <zahir.dba_at_gmail.com> 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*
>

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Jan 27 2023 - 18:44:55 CET

Original text of this message