Accessing SQL Server DB from Oracle
From: Sallie Cottingham <Sallie.Cottingham_at_cot.tn.gov>
Date: Thu, 10 Aug 2023 12:59:53 +0000
Message-ID: <SA1PR09MB7951401FA009B2E05F26A950DE13A_at_SA1PR09MB7951.namprd09.prod.outlook.com>
I am looking for any advice/suggestions of the best way to access a SQL Server DB from Oracle. I've communicated with Oracle via a Support Ticket and the solutions they gave me involve using the Oracle Gateway (one free and the other paid). The Oracle DB is being hosted by a vendor and that DB will be talking to one of our SQL DBs on-prem. We already have communication via Oracle DBlinks both from Oracle down to Oracle on-prem and vice versa.
Date: Thu, 10 Aug 2023 12:59:53 +0000
Message-ID: <SA1PR09MB7951401FA009B2E05F26A950DE13A_at_SA1PR09MB7951.namprd09.prod.outlook.com>
I am looking for any advice/suggestions of the best way to access a SQL Server DB from Oracle. I've communicated with Oracle via a Support Ticket and the solutions they gave me involve using the Oracle Gateway (one free and the other paid). The Oracle DB is being hosted by a vendor and that DB will be talking to one of our SQL DBs on-prem. We already have communication via Oracle DBlinks both from Oracle down to Oracle on-prem and vice versa.
Just checking with this group to see what experiences you might have on how to do this and the pros/cons of various types of solutions.
Thanks!
Sallie A. Cottingham, OCP
Database Administrator
Comptroller of the Treasury
Technology Solutions
425 Rep. John Lewis Way N. | Nashville, TN 37243
sallie.cottingham_at_cot.tn.gov<mailto:sallie.cottingham_at_cot.tn.gov> | Direct Line 615.401.7962
[A picture containing food Description automatically generated]
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Aug 10 2023 - 14:59:53 CEST
- image/png attachment: image001.png
