Re: Are we losing momentum?
От | Dann Corbit |
---|---|
Тема | Re: Are we losing momentum? |
Дата | |
Msg-id | D90A5A6C612A39408103E6ECDD77B8294CDB5B@voyager.corporate.connx.com обсуждение исходный текст |
Ответ на | Are we losing momentum? (Bruce Momjian <pgman@candle.pha.pa.us>) |
Список | 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: <<<<-----------------------------
В списке pgsql-hackers по дате отправления: