agora inbox for pgsql-sql@postgresql.orghelp / color / mirror / Atom feed
best way sync data from Oracle to PostgreSQL? 2+ messages / 2 participants [nested] [flat]
* best way sync data from Oracle to PostgreSQL? @ 2016-01-13 16:37 Michael Moore <michaeljmoore@gmail.com> 0 siblings, 1 reply; 2+ messages in thread From: Michael Moore @ 2016-01-13 16:37 UTC (permalink / raw) To: pgsql-sql 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. TIA, Mike ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: best way sync data from Oracle to PostgreSQL? @ 2016-01-13 17:48 Adrian Klaver <adrian.klaver@aklaver.com> parent: Michael Moore <michaeljmoore@gmail.com> 0 siblings, 0 replies; 2+ messages in thread From: Adrian Klaver @ 2016-01-13 17:48 UTC (permalink / raw) To: Michael Moore <michaeljmoore@gmail.com>; pgsql-sql 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 -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2016-01-13 17:48 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2016-01-13 16:37 best way sync data from Oracle to PostgreSQL? Michael Moore <michaeljmoore@gmail.com> 2016-01-13 17:48 ` Adrian Klaver <adrian.klaver@aklaver.com>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox