[postgis-users] Creating a DBlink to load data from Oracle Spatial to PostGIS

[Vincent Picavet - ML]

Hello,

Le jeudi 29 janvier 2015, 15:22:15 Tahir Tamba a écrit :
[...]
> Otherwise, are there another ways to load tables from Oracle Spatial
> database to PostGIS ?

As Brent suggested, you can use Oracle Foreign Data Wrapper. There is now full 
support for Oracle spatial included in Oracle_fdw natively and without 
dependency.
Once setup, you can access your Oracle tables from within PostgreSQL/PostGIS 
transparently, and can use materialized views on foreign table if you want a 
cache mechanism to improve performances.
This is AFAIK the most performant way to do, and totally transparent from an 
application point of view.

https://github.com/laurenz/oracle_fdw

Note that ora2pg (since version 14) can generate directly the oracle_fdw 
foreign tables, or completely migrate your data :

http://ora2pg.darold.net/news.html

Thanks to Laurenz, Gilles and Vincent for this work.

Vincent

-- 
Vincent Picavet - Gérant Oslandia
www.oslandia.com