We also use Oracle Gateway for ODBC (comes with Oracle EE) and a third party
driver from Easysoft to make connections from Oracle to SQL Server through a
dblink. They may have other options to other databases as well.
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On ;
Behalf Of Steve Bradshaw
Sent: Tuesday, August 02, 2016 8:13 AM
To: JBECKSTROM@xxxxxxxxx
Cc: oracle-l-freelists; oracle-db-l
Subject: Re: Accessing non-Oracle database from Oracle
Hi,
If there is an ODBC driver for the non-Oracle database, you may be able to use
Oracle Heterogenous Connectivity - see
https://docs.oracle.com/cd/B28359_01/server.111/b28277/toc.htm
I've used this before to connect to SQL Server via regular database link on the
Oracle side.
Steve
On Tue, Aug 2, 2016 at 12:28 PM, Beckstrom Jeffrey
<JBECKSTROM@xxxxxxxxx<mailto:JBECKSTROM@xxxxxxxxx>> wrote:
What are my options for accessing a non-Oracle third party database. The
database is C-Tree (working to get this confirmed). Can this even be done? Has
anyone done this?
Jeffrey Beckstrom
Lead Database Administrator
Information Technology Department
Greater Cleveland Regional Transit Authority
1240 W. 6th Street
Cleveland, Ohio 44113
.