Re: best way sync data from Oracle to PostgreSQL?

On 01/13/2016 08:37 AM, Michael Moore wrote:
> Our DBA's want to write a home-grown ETL system. Surely there has got to
> be a better way. What is the best NO COST solution for doing this? We
> have CLOBS and XML datatypes. We could "toString" the XML datatypes on
> the Oracle side if that helps.

Have you looked at Foreign Data Wrappers?:

http://www.postgresql.org/docs/9.4/static/ddl-foreign-data.html

in particular:

http://laurenz.github.io/oracle_fdw/

>
> TIA, Mike


-- 
Adrian Klaver
adrian.klaver@aklaver.com