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.
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