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

[Brent Wood]

Can't help with plain dblink but we have succeeded with ODBC connections & shell scripts which pipe the result from an Oracle SQL query into a Postgis SQL to transfer the data.
We have not pursued another approach which we feel is probably viable, which is connecting directly from Oracle to push data, see (amongst several such articles): 
https://dbaspot.wordpress.com/2013/05/29/how-to-access-postgresql-from-oracle-database/
you can also try the Oracle FDW:http://laurenz.github.io/oracle_fdw/
 http://pgxn.org/dist/oracle_fdw/


HTH,
  Brent Wood



   

   From: Tahir Tamba <tahir.tamba at gmail.com>
 To: PostGIS Users Discussion <postgis-users at lists.osgeo.org> 
 Sent: Friday, January 30, 2015 9:22 AM
 Subject: [postgis-users] Creating a DBlink to load data from Oracle Spatial to PostGIS
   
Hi,

I have a mapping project for generating an atlas from multiple layers from QGIS project. All my layers are stored in PostGIS. For cons, I have many layers to add that are stored in Oracle Spatial database and must be part of the project. This tables are updated in live every day. This is the reason why I don't have any choice to access  the data from Oracle database. I already have privileges to access data from Oracle Spatial schema that contains spatial tables.

 My question is the following . Is it possible to make a DBLink to load the Oracle Spatial database  tables in PostGIS database? If yes  what is the procedure and steps for loading Oracle Spatialtables into PostgreSQL / PostGIS ?

Otherwise, are there another ways to load tables from Oracle Spatial database to PostGIS ?

Any suggestions would be greatly appreciated!

Regards!

_______________________________________________
postgis-users mailing list
postgis-users at lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users

  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20150129/7ab95f77/attachment.html>