pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedoracle db reads from postgresql
9+ messages / 6 participants
[nested] [flat]
* oracle db reads from postgresql
@ 2016-02-17 14:42 Ray Stell <stellr@vt.edu>
2016-02-17 14:53 ` Re: oracle db reads from postgresql Scott Whitney <scott@journyx.com>
2016-02-17 14:59 ` Re: oracle db reads from postgresql Andrea Suisani <sickpig@opinioni.net>
2016-02-18 01:28 ` Re: oracle db reads from postgresql Shreeyansh Dba <shreeyansh2014@gmail.com>
0 siblings, 3 replies; 9+ messages in thread
From: Ray Stell @ 2016-02-17 14:42 UTC (permalink / raw)
To: pgsql-admin
I've dreaded this task coming my way for years. An Oracle developer
wants to read postgresql data from his Oracle db. Is there a current,
successful path to making this work or is it fools errand? I find this
description:
https://dbaspot.wordpress.com/2013/05/29/how-to-access-postgresql-from-oracle-database/
which is 3 yrs old. I see they want me to load an v8 rpm for the odbc
driver so I tried to compile the latest and failed out of the gate.
Just wondering if anyone has it working or not? Is there a more
current howto?
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: oracle db reads from postgresql
2016-02-17 14:42 oracle db reads from postgresql Ray Stell <stellr@vt.edu>
@ 2016-02-17 14:53 ` Scott Whitney <scott@journyx.com>
2016-02-17 22:01 ` Re: oracle db reads from postgresql Ray Stell <stellr@vt.edu>
2 siblings, 1 reply; 9+ messages in thread
From: Scott Whitney @ 2016-02-17 14:53 UTC (permalink / raw)
To: Ray Stell <stellr@vt.edu>; pgsql-admin
The last time I did this, I started with this:
http://docs.oracle.com/cd/E11882_01/gateways.112/e12070/toc.htm
and specifically this:
http://docs.oracle.com/cd/E11882_01/owb.112/e10582/loading_ms_data.htm#WBDOD10660
and modified appropriately for PG ODBC.
________________________________________
From: pgsql-admin-owner@postgresql.org <pgsql-admin-owner@postgresql.org> on behalf of Ray Stell <stellr@vt.edu>
Sent: Wednesday, February 17, 2016 8:42 AM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] oracle db reads from postgresql
I've dreaded this task coming my way for years. An Oracle developer
wants to read postgresql data from his Oracle db. Is there a current,
successful path to making this work or is it fools errand? I find this
description:
https://dbaspot.wordpress.com/2013/05/29/how-to-access-postgresql-from-oracle-database/
which is 3 yrs old. I see they want me to load an v8 rpm for the odbc
driver so I tried to compile the latest and failed out of the gate.
Just wondering if anyone has it working or not? Is there a more
current howto?
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Journyx, Inc.
7600 Burnet Road #300
Austin, TX 78757
www.journyx.com
p 512.834.8888
f 512-834-8858
Do you receive our promotional emails? You can subscribe or unsubscribe to those emails at http://go.journyx.com/emailPreference/e/4932/714/
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: oracle db reads from postgresql
2016-02-17 14:42 oracle db reads from postgresql Ray Stell <stellr@vt.edu>
2016-02-17 14:53 ` Re: oracle db reads from postgresql Scott Whitney <scott@journyx.com>
@ 2016-02-17 22:01 ` Ray Stell <stellr@vt.edu>
0 siblings, 0 replies; 9+ messages in thread
From: Ray Stell @ 2016-02-17 22:01 UTC (permalink / raw)
To: Scott Whitney <scott@journyx.com>; pgsql-admin
On 2/17/16 9:53 AM, Scott Whitney wrote:
> The last time I did this, I started with this:
>
> http://docs.oracle.com/cd/E11882_01/gateways.112/e12070/toc.htm
>
> and specifically this:
>
>
> http://docs.oracle.com/cd/E11882_01/owb.112/e10582/loading_ms_data.htm#WBDOD10660
>
>
> and modified appropriately for PG ODBC.
>
Found these docs on the oracle support web:
How to Configure DG4ODBC on Linux x86 32bit or on HP-UX RISC (DG4ODBC
11.1 only) to Connect to Non-Oracle Databases post install (Doc ID 466228.1)
Problems Configuring Database Gateway For ODBC (DG4ODBC) to Connect To
Postgres (Doc ID 881667.1)
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: oracle db reads from postgresql
2016-02-17 14:42 oracle db reads from postgresql Ray Stell <stellr@vt.edu>
@ 2016-02-17 14:59 ` Andrea Suisani <sickpig@opinioni.net>
2016-02-17 15:33 ` Re: oracle db reads from postgresql Ray Stell <stellr@vt.edu>
2 siblings, 1 reply; 9+ messages in thread
From: Andrea Suisani @ 2016-02-17 14:59 UTC (permalink / raw)
To: Ray Stell <stellr@vt.edu>; pgsql-admin
On 02/17/2016 03:42 PM, Ray Stell wrote:
> I've dreaded this task coming my way for years. An Oracle developer wants to read postgresql data from his Oracle db. Is there a current, successful path to making this work or is it fools errand? I find this description:
> https://dbaspot.wordpress.com/2013/05/29/how-to-access-postgresql-from-oracle-database/ which is 3 yrs old. I see they want me to load an v8 rpm for the odbc driver so I tried to compile the latest and failed out of the gate. Just wondering if anyone has it working or not? Is there a more current
> howto?
>
>
if you're using postgresql 9.1+ you could give oracle_fwd a try:
http://laurenz.github.io/oracle_fdw/
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: oracle db reads from postgresql
2016-02-17 14:42 oracle db reads from postgresql Ray Stell <stellr@vt.edu>
2016-02-17 14:59 ` Re: oracle db reads from postgresql Andrea Suisani <sickpig@opinioni.net>
@ 2016-02-17 15:33 ` Ray Stell <stellr@vt.edu>
2016-02-17 16:30 ` Re: oracle db reads from postgresql Andrea Suisani <suisani@demetra.com>
2016-02-17 16:34 ` Re: oracle db reads from postgresql Andrea Suisani <sickpig@opinioni.net>
0 siblings, 2 replies; 9+ messages in thread
From: Ray Stell @ 2016-02-17 15:33 UTC (permalink / raw)
To: Andrea Suisani <sickpig@opinioni.net>; pgsql-admin
On 2/17/16 9:59 AM, Andrea Suisani wrote:
> if you're using postgresql 9.1+ you could give oracle_fwd a try:
Isn't that the opposite direction? Reading oracle from pg?
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: oracle db reads from postgresql
2016-02-17 14:42 oracle db reads from postgresql Ray Stell <stellr@vt.edu>
2016-02-17 14:59 ` Re: oracle db reads from postgresql Andrea Suisani <sickpig@opinioni.net>
2016-02-17 15:33 ` Re: oracle db reads from postgresql Ray Stell <stellr@vt.edu>
@ 2016-02-17 16:30 ` Andrea Suisani <suisani@demetra.com>
1 sibling, 0 replies; 9+ messages in thread
From: Andrea Suisani @ 2016-02-17 16:30 UTC (permalink / raw)
To: Ray Stell <stellr@vt.edu>; Andrea Suisani <sickpig@opinioni.net>; pgsql-admin
On 02/17/2016 04:33 PM, Ray Stell wrote:
> On 2/17/16 9:59 AM, Andrea Suisani wrote:
>> if you're using postgresql 9.1+ you could give oracle_fwd a try:
> Isn't that the opposite direction? Reading oracle from pg?
>
brian fart of mine sorry.
scratch that
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: oracle db reads from postgresql
2016-02-17 14:42 oracle db reads from postgresql Ray Stell <stellr@vt.edu>
2016-02-17 14:59 ` Re: oracle db reads from postgresql Andrea Suisani <sickpig@opinioni.net>
2016-02-17 15:33 ` Re: oracle db reads from postgresql Ray Stell <stellr@vt.edu>
@ 2016-02-17 16:34 ` Andrea Suisani <sickpig@opinioni.net>
1 sibling, 0 replies; 9+ messages in thread
From: Andrea Suisani @ 2016-02-17 16:34 UTC (permalink / raw)
To: Andrea Suisani <sickpig@opinioni.net>; pgsql-admin
On 02/17/2016 04:33 PM, Ray Stell wrote:
> On 2/17/16 9:59 AM, Andrea Suisani wrote:
>> if you're using postgresql 9.1+ you could give oracle_fwd a try:
> Isn't that the opposite direction? Reading oracle from pg?
>
brian fart of mine sorry.
scratch that.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: oracle db reads from postgresql
2016-02-17 14:42 oracle db reads from postgresql Ray Stell <stellr@vt.edu>
@ 2016-02-18 01:28 ` Shreeyansh Dba <shreeyansh2014@gmail.com>
2016-02-18 14:08 ` Re: [MASSMAIL]Re: oracle db reads from postgresql Gilberto Castillo <gilberto.castillo@etecsa.cu>
2 siblings, 1 reply; 9+ messages in thread
From: Shreeyansh Dba @ 2016-02-18 01:28 UTC (permalink / raw)
To: Ray Stell <stellr@vt.edu>; +Cc: pgsql-admin
On Wed, Feb 17, 2016 at 8:12 PM, Ray Stell <stellr@vt.edu> wrote:
> I've dreaded this task coming my way for years. An Oracle developer wants
> to read postgresql data from his Oracle db. Is there a current, successful
> path to making this work or is it fools errand? I find this description:
> https://dbaspot.wordpress.com/2013/05/29/how-to-access-postgresql-from-oracle-database/
> which is 3 yrs old. I see they want me to load an v8 rpm for the odbc
> driver so I tried to compile the latest and failed out of the gate. Just
> wondering if anyone has it working or not? Is there a more current howto?
>
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>
Hi Raymond,
PF following tutorials which worked for me.
http://agapoff.name/oracle-postgresql-links.html
https://www.toadworld.com/platforms/oracle/b/weblog/archive/2015/02/23/connecting-oracle-to-postgres...
Hope this will help.
--
Thanks & Regards,
Harshad Adalkonda
Database Administrator
www.shreeyansh.com
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: [MASSMAIL]Re: oracle db reads from postgresql
2016-02-17 14:42 oracle db reads from postgresql Ray Stell <stellr@vt.edu>
2016-02-18 01:28 ` Re: oracle db reads from postgresql Shreeyansh Dba <shreeyansh2014@gmail.com>
@ 2016-02-18 14:08 ` Gilberto Castillo <gilberto.castillo@etecsa.cu>
0 siblings, 0 replies; 9+ messages in thread
From: Gilberto Castillo @ 2016-02-18 14:08 UTC (permalink / raw)
To: Shreeyansh Dba <shreeyansh2014@gmail.com>; +Cc: Ray Stell <stellr@vt.edu>; pgsql-admin
> On Wed, Feb 17, 2016 at 8:12 PM, Ray Stell <stellr@vt.edu> wrote:
>
>> I've dreaded this task coming my way for years. An Oracle developer
>> wants
>> to read postgresql data from his Oracle db. Is there a current,
>> successful
>> path to making this work or is it fools errand? I find this description:
>> https://dbaspot.wordpress.com/2013/05/29/how-to-access-postgresql-from-oracle-database/
>> which is 3 yrs old. I see they want me to load an v8 rpm for the odbc
>> driver so I tried to compile the latest and failed out of the gate.
>> Just
>> wondering if anyone has it working or not? Is there a more current
>> howto?
Use HS module in Oracle, but is better to join Postgres to Oracle to
otherwise.
--
Saludos,
Gilberto Castillo
ETECSA, La Habana, Cuba
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 9+ messages in thread
end of thread, other threads:[~2016-02-18 14:08 UTC | newest]
Thread overview: 9+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2016-02-17 14:42 oracle db reads from postgresql Ray Stell <stellr@vt.edu>
2016-02-17 14:53 ` Scott Whitney <scott@journyx.com>
2016-02-17 22:01 ` Ray Stell <stellr@vt.edu>
2016-02-17 14:59 ` Andrea Suisani <sickpig@opinioni.net>
2016-02-17 15:33 ` Ray Stell <stellr@vt.edu>
2016-02-17 16:30 ` Andrea Suisani <suisani@demetra.com>
2016-02-17 16:34 ` Andrea Suisani <sickpig@opinioni.net>
2016-02-18 01:28 ` Shreeyansh Dba <shreeyansh2014@gmail.com>
2016-02-18 14:08 ` Gilberto Castillo <gilberto.castillo@etecsa.cu>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox