RE: How to connect from sybase to oracle
- From: Amar Kumar Padhi <amar.padhi@xxxxxxxxx>
- To: <ramakrishnan42@xxxxxxxxx>
- Date: Wed, 3 Jun 2009 15:06:14 +0400 (GST)
Hi,
Just to qucikly answer your query. Yes you can directly connect from oracle
database to other databases like mysql, sqlserver and sybase. You can achieve
this by using oracle heterogenous service, now also known as oracle Transparent
Gateway or database gateway option. The advantage is that you can have plsql
program units running on remote tables. you need to pay for this separately.
This would also require installation of unixODBC and freeTDS libraries.
Other option is to create an odbc link and make use of sqlplus to read data
from the source. This has very basic features but good enough for reporting or
spooling data to text files that can then be uploaded to oracle.
Thanks!
Amar
Www.amar-padhi.com
-original message-
Subject: How to connect from sybase to oracle
From: "Ramakrishnan Seshadhri" <ramakrishnan42@xxxxxxxxx>
Date: 03-06-2009 12:00
Hi,
Is there a possibility to connect to Sybase DB from Oracle. Currently My
Oracle DB is 10gR2 and resides on a Linux server and the sybase db is on a
windows server. Is it feasible to coonct to Sysbase from Oracle and pull
data from tables.
Ramakrishnan.S
Other related posts:
