question for the 'senior' people

[pheonix1t]

hello,
My friend and I are working on a project involving oracle 9i and an old
Unify database. We got the oracle to see the unify (oracle running on
windows) by using the heterogenous services on oracle.
However, that was a test environment. The production environment has
oracle running on linux. The problem is that the odbc drivers for the
old unify database are only available on windows!
So, I was wondering about something.
In the production environment, they also have a MS-SQL 2000 database.
Does that database have a function similar to oracle's heterogenous
services that will let us connect to the old unify database and pass
that data to oracle?
We're building custom apps. on oracle 10g application server. Running
oracle on windows in the production environment is not going to happen.

Thanks,

Dave

[Simon Hayes]

"pheonix1t" <ph***************************@com.com> wrote in message
news:ip***************@newssvr22.news.prodigy.com. ..

hello,
My friend and I are working on a project involving oracle 9i and an old
Unify database. We got the oracle to see the unify (oracle running on
windows) by using the heterogenous services on oracle.
However, that was a test environment. The production environment has
oracle running on linux. The problem is that the odbc drivers for the
old unify database are only available on windows!
So, I was wondering about something.
In the production environment, they also have a MS-SQL 2000 database.
Does that database have a function similar to oracle's heterogenous
services that will let us connect to the old unify database and pass
that data to oracle?
We're building custom apps. on oracle 10g application server. Running
oracle on windows in the production environment is not going to happen.

Thanks,

Dave

I have no idea what "heterogenous services" are, but I suspect that what
you're looking for in MSSQL terms is a linked server - see Books Online for
more information. Depending on what you're trying to do, you might also
consider DTS, which is an ETL tool bundled with MSSQL - in principle, it
could be used to move data directly between Oracle and Unify (although there
are still advantages to using MSSQL, such as scheduling and persisting
package configuration):

http://www.winnetmag.com/SQLServer/A...7444/7444.html

Simon

[Erland Sommarskog]

pheonix1t (ph***************************@com.com) writes:

My friend and I are working on a project involving oracle 9i and an old
Unify database. We got the oracle to see the unify (oracle running on
windows) by using the heterogenous services on oracle.
However, that was a test environment. The production environment has
oracle running on linux. The problem is that the odbc drivers for the
old unify database are only available on windows!
So, I was wondering about something.
In the production environment, they also have a MS-SQL 2000 database.
Does that database have a function similar to oracle's heterogenous
services that will let us connect to the old unify database and pass
that data to oracle?
We're building custom apps. on oracle 10g application server. Running
oracle on windows in the production environment is not going to happen.

Yes, you could set up the Unify database and the Oracle database as linked
servers and access them from MS SQL Server.

However, it sounds like an overkill to involve. There are ODBC-ODBC bridges
out there, which permits you to access Windows ODBC sources from Unix.
I have a couple listed on http://www.sommarskog.se/mssqlperl/unix.html.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp