Re: [NOVICE] How to read oracle table's data from postgre

Hello ,

I want to read oracle database table data from postgre. (like in oracle we
can use database links, is there something like this available in
postgre).
I tried below -

select dblink_connect('host=.., dbname=..user=.. pwd=..'); but it is
giving error database refused connection. Do i need to add anything in
oracle datbase server tnsnames. how should be this entry.(since here we
are connecting oracle to postgre and not the oracle to oracle)

Thanks in advance..

Regards,
Venkat
=====-----=====-----=====
Notice: The information contained in this e-mail
message and/or attachments to it may contain
confidential or privileged information. If you are
not the intended recipient, any dissemination, use,
review, distribution, printing or copying of the
information contained in this e-mail message
and/or attachments to it are strictly prohibited. If
you have received this communication in error,
please notify us by reply e-mail or telephone and
immediately and permanently delete the message
and any attachments. Thank you

venkatrao(dot)b(at)tcs(dot)com wrote:
>
> Hello ,
>
> I want to read oracle database table data from postgre. (like in
> oracle we can use database links, is there something like this
> available in postgre).
> I tried below -
>
> select dblink_connect('host=.., dbname=..user=.. pwd=..'); but it is
> giving error database refused connection. Do i need to add anything in
> oracle datbase server tnsnames. how should be this entry.(since here
> we are connecting oracle to postgre and not the oracle to oracle)

postgresql's dblink functions can only connect to other postgresql
databases. it has no idea how to connect to Oracle, or any other sort
of database.

On Mon, 2010-03-08 at 10:40 +0530, venkatrao(dot)b(at)tcs(dot)com wrote:
>
> I want to read oracle database table data from postgre. (like in
> oracle we can use database links, is there something like this
> available in postgre).

(It is not postgre, it is PostgreSQL or Postgres.)

You can try dbi-link:

http://pgfoundry.org/projects/dbi-link/

--
Devrim GÜNDÜZ
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz

2010/3/7 Devrim GÜNDÜZ <devrim(at)gunduz(dot)org>:
> On Mon, 2010-03-08 at 10:40 +0530, venkatrao(dot)b(at)tcs(dot)com wrote:
>>
>> I want to read oracle database table data from postgre. (like in
>> oracle we  can use database links, is there something like this
>> available in postgre).
>
> (It is not postgre, it is PostgreSQL or Postgres.)
>
> You can try dbi-link:
>
> http://pgfoundry.org/projects/dbi-link/

Anyone know if this is still active / developed?

http://wiki.postgresql.org/wiki/SqlMedConnectionManager

Scott Marlowe wrote:
> Anyone know if this is still active / developed?
> http://wiki.postgresql.org/wiki/SqlMedConnectionManager
>

That's still the right long-term approach for a lot of these problems,
so while activity on it happens in bursts I don't think it will ever go
completely inactive. I expect SQL/MED plans for the next release may
get fleshed out at this year's developer's meeting in a couple of
months, should have a better idea who might be working on this by the
end of May.

--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
greg(at)2ndQuadrant(dot)com www.2ndQuadrant.us