Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

CIS and Oracle

3 posts in Windows NT Last posting was on 1998-03-20 20:54:48.0Z
Marty Phee Posted on 1998-03-19 15:00:35.0Z
Message-ID: <35113312.B9AE1FE2@sprintmail.com>
Date: Thu, 19 Mar 1998 09:00:35 -0600
From: Marty Phee <mphee@sprintmail.com>
X-Mailer: Mozilla 4.01 [en] (Win95; I)
MIME-Version: 1.0
Subject: CIS and Oracle
X-Priority: 3 (Normal)
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 3
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5105
Article PK: 1092470

Has anyone connected to an Oracle db through Sybase 11.5?

Any comments appreciated.

Marty


John McVicker Posted on 1998-03-20 20:54:48.0Z
From: "John McVicker" <mcvicker@sybase.com>
Organization: 192.175.209.26
References: <35113312.B9AE1FE2@sprintmail.com>
X-Newsreader: AspNNTP (Advent 2000, Inc.)
Subject: Re: CIS and Oracle
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Message-ID: <3L1erJEV9GA.659@forums.powersoft.com>
Newsgroups: sybase.public.sqlserver.nt
Date: Fri, 20 Mar 1998 15:54:48 -0500
Lines: 38
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5103
Article PK: 1092467

Marty,
A couple interesting things you can do:
1) Implement a 2 phase commit from a Sybase trigger
over to Oracle (if you want to do something like that).
2) Put data into Oracle from Sybase
3) Get data into Sybase from Oracle
4) Create a local "existing table" which points at Oracle,
then do joins like:
select a.column, b.column
from sybase_table a, oracle_table b
where a.key = b.key
5) Port your Oracle application over to Sybase using Sybase CIS
as a way to get the application first over to Sybase ASE then
the data over to Sybase, etc.
6) Use the CONNECT TO command and log into Oracle through Sybase
via ISQL.
7) Use the sp_remotesql stored procedure to send textual PL-SQL
over to Oracle for result set processing.
8) Create an archiving process to push say 1 month's worth of
data from Sybase into Oracle, then delete it all in one transaction
originating from Sybase.

I guess I could go on and on - but those are all possibilities with
the new CIS stuff in ASE 11.5. And, it doesn't have to be Sybase
to Oracle - it can be Sybase to Sybase, Sybase to MS SQL Server,
etc. Anything heterogenous that CIS can connect to through
Direct Connect!

On Thu, 19 Mar 1998 09:00:35 -0600,
in sybase.public.sqlserver.nt

Marty Phee <mphee@sprintmail.com> wrote:
>Has anyone connected to an Oracle db through Sybase 11.5?
>
>Any comments appreciated.
>
>Marty
>

John McVicker
Sybase Professional Services
Philadelphia, PA


Rex Dent Posted on 1998-03-19 17:15:48.0Z
Message-ID: <351152C4.27B9@micron.com>
Date: Thu, 19 Mar 1998 10:15:48 -0700
From: Rex Dent <rdent@micron.com>
Reply-To: rdent@micron.com
Organization: Micron Technology, Inc.
X-Mailer: Mozilla 3.0 (WinNT; U)
MIME-Version: 1.0
To: Marty Phee <mphee@sprintmail.com>
Subject: Re: CIS and Oracle
References: <35113312.B9AE1FE2@sprintmail.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 13
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5104
Article PK: 1092468


Marty Phee wrote:
>
> Has anyone connected to an Oracle db through Sybase 11.5?
>
> Any comments appreciated.
>
> Marty

We have not done it yet. We will soon be replicating to oracle tables
from Sybase with Sybase Replication.

This is my understanding of what will be needed.
You will need to purchase Direct Connect for Oracle. You can create
this "Direct Connect/ OMNI server" to overlay the Oracle tables. You
can overlay the DCO server from your ASE server.