Re: Are we losing momentum? - Mailing list pgsql-hackers

> -----Original Message-----
> From: Ron Mayer [mailto:ron@intervideo.com]
> Sent: Tuesday, April 15, 2003 3:07 PM
> To: Dann Corbit; Tom Lane
> Cc: Robert Treat; ow; pgsql-hackers@postgresql.org
> Subject: RE: [HACKERS] Are we losing momentum?
>
>
>
> Dann wrote:
> >Sure you can.  It's not easy of course.  That's one of the
> things that
> >CONNX software does (I work for CONNX Solutions Inc.).
> Certainly, the
> >PostgreSQL group could accomplish the same thing, if they put their
> >mind to it.
> >
> >I can easily join PostgreSQL tables to Oracle tables and insert the
> >result set into DB/2.  No programs, no extracts.  Just a SQL query.
>
> Very interesting...  I was just in a conversation here at
> work about joining data from an oracle system with data in a
> postgresql
> system...
>
>
>
> FWIW, Oracle has something called "Oracle Generic Connectivity"
> and "Oracle Transparent Gateways" that do similar.
>
http://otn.oracle.com/products/oracle9i/datasheets/gateways/gateway_rel2
_ds.html
 "Oracle Generic Connectivity and Oracle Transparent Gateways provide  the ability to transparently access data in
non-Oraclesystems from   an Oracle environment.... 
  ...Oracle Generic connectivity makes it possible to access low-end   data stores such as Foxpro, Access, dBase and
non-relationaltargets   like Excel. ... 
  ...Oracle has transparent gateways to many sources, Sybase, Informix,
  Microsoft SQL Server, Ingres, Teradata to name a few."

I was mildly disapointed I didn't see PostgreSQL on the list. 1/2 :-)
1/2 :-| Is this similar to what CONNX does?

DRC responds: >>>>-----------------------------

CONNX joins anything to anything.  We wrote several of our own ODBC
drivers (including a recent one for PostgreSQL in {soon to be released}
CONNX 8.9) and we also work with ODBC drivers or OLEDB sources written
by other folks.  We import every data source into a central repository
of metadata called the CONNX CDD.  After that, we can join across
systems transparent to the user.

We also have a data replication system that will mirror data from any
collection of database systems to a single target system or a collection
of target systems.  We can replicate only the data that has changed,
which speeds up the synchronizations a lot.

Plenty of other stuff too.  Those that are interested can cruise around
our web site.  Probably off topic for the list at this point.  Further
inquiries would probably be better as private emails.

DRC responds: <<<<-----------------------------