Does Sybase support bi-directional Gateway 
Author Message
 Does Sybase support bi-directional Gateway

Hi,
   We have a mixture database envirement include Oracle and Sybase.We
want to use some
database gateway products to make these two RDBMS interoperation. For
example:
On Oracle side we can use Oracle tools such as SQL*form and Pro*C access
Sybase
tranparently.On the Sybase side does same (don't use ODBC). Some one
told me Sybase
has a product called OmniConnect can do these. OmniConnect support
bi-directional gateway
functions , so we need not to use Oracle transparent gateway for Sybase
to support Oracle
applications access Sybase database.Does anyone know this?

Thanks

Wang Dong



Mon, 24 Apr 2000 03:00:00 GMT
 Does Sybase support bi-directional Gateway

Quote:

> Hi,
>    We have a mixture database envirement include Oracle and Sybase.We
> want to use some
> database gateway products to make these two RDBMS interoperation. For
> example:
> On Oracle side we can use Oracle tools such as SQL*form and Pro*C access
> Sybase
> tranparently.On the Sybase side does same (don't use ODBC). Some one
> told me Sybase
> has a product called OmniConnect can do these. OmniConnect support
> bi-directional gateway
> functions , so we need not to use Oracle transparent gateway for Sybase
> to support Oracle
> applications access Sybase database.Does anyone know this?

> Thanks

> Wang Dong

Wang,

Yes, OMNIConnect will support bi-dirrectional gateways to Oracle, DB2,
Sybase, and others.  This can give a single-schema view of multiple
backend databases; of course, this view looks like a Sybase server.
It's tricky to work with and has some performance and functional
issues.  Try http://www.sybase.com for more info.

Tom
--
================================================================
T. J. Smith   KB6PGZ
S/V First Light
Redondo Beach, CA

(remove *nospam* to reply)



Mon, 24 Apr 2000 03:00:00 GMT
 Does Sybase support bi-directional Gateway

The new version of SQL server, Adaptive Server Enterprise, has an Extended
Enterprise Option that allows the Sybase server to function as a combined
OmniConnect server. In other words you can define tables from Oracle, DB2,
etc inside your Sybase server. No extra gateway process involved.

It still carries some of the configuration issues of OmniConnect, but most
gateway solutions probably will.

A Sybase client will see the Oracle tables as native Sybase tables, Sybase
will reroute the queries back to the Oracle server when necessary.

Some of the performance problems should be eliminated especially if you are
joining between sources.

We haven't used it yet, but we are expecting it in any day. We plan to have
it up in production in  a few months and retire our current OmniConnect
server.

-KAS

Quote:

> Hi,
>    We have a mixture database envirement include Oracle and Sybase.We
> want to use some
> database gateway products to make these two RDBMS interoperation. For
> example:
> On Oracle side we can use Oracle tools such as SQL*form and Pro*C access
> Sybase
> tranparently.On the Sybase side does same (don't use ODBC). Some one
> told me Sybase
> has a product called OmniConnect can do these. OmniConnect support
> bi-directional gateway
> functions , so we need not to use Oracle transparent gateway for Sybase
> to support Oracle
> applications access Sybase database.Does anyone know this?

> Thanks

> Wang Dong



Tue, 25 Apr 2000 03:00:00 GMT
 Does Sybase support bi-directional Gateway


Quote:
>Yes, OMNIConnect will support bi-dirrectional gateways to Oracle, DB2,
>Sybase, and others.  This can give a single-schema view of multiple
>backend databases; of course, this view looks like a Sybase server.
>It's tricky to work with and has some performance and functional
>issues.  Try http://www.sybase.com for more info.

The performance issues: I've been told by some people who worked with
it, that a query run through a Omniconnect gatway on an Oracle
database was some times atcually FASTER than when the same query was
run on the Oracle database itself (!).
(This happened because the Sybase optimizer can use information about
remote indexes as well)

__________________________________________________

http://www.xs4all.nl/~reinoud
I specifically DO NOT give anyone permission to use my email adress
for any commercial or non commercial mailings. I will bill everyone
who sends me this kind of mail for wasting my time. Under Dutch law,
people who don't let me know they disagree with such a bill are obliged
to pay it.
Attention: remove extra anti-spam info at end of reply adress



Wed, 26 Apr 2000 03:00:00 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. Is Procedure Gateway bi-directional ?

2. Question about bi-directional replication advice form microsoft's techincal support

3. bi-directional varchar problems

4. BI directional replication of text/image thru Transactional repl

5. conflicts with bi-directional replication

6. bi-directional transactional replication - HELP !

7. Bi-directional Transactional Replication

8. bi-directional replication

9. Bi-directional replication

10. Full Bi-directional replication

11. Bi-directional Replication

12. Urgent: How to setup a bi-directional replication?


 
Powered by phpBB® Forum Software