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
