Thread: How to read oracle table's data from postgre

=====-----=====-----=====
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.b@tcs.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.b@tcs.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@gunduz.org>:
> On Mon, 2010-03-08 at 10:40 +0530, venkatrao.b@tcs.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@2ndQuadrant.com   www.2ndQuadrant.us