Re: best way sync data from Oracle to PostgreSQL?

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Michael Moore <michaeljmoore(at)gmail(dot)com>, postgres list <pgsql-sql(at)postgresql(dot)org>
Subject: Re: best way sync data from Oracle to PostgreSQL?
Date: 2016-01-13 17:48:13
Message-ID: 56968DDD.9070509@aklaver.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: 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(dot)klaver(at)aklaver(dot)com

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message John DeSoi 2016-01-14 16:00:49 Re: BYTEA vs BLOB
Previous Message Michael Moore 2016-01-13 16:37:26 best way sync data from Oracle to PostgreSQL?