Subject: Re: best way sync data from Oracle to PostgreSQL?
To: Michael Moore <michaeljmoore@gmail.com>,
 postgres list <pgsql-sql@postgresql.org>
References: 
 <CACpWLjNkTR=SJn-717UtKaf0wJgjksRGk-v67__iY_=c+a02aA@mail.gmail.com>
From: Adrian Klaver <adrian.klaver@aklaver.com>
Message-ID: <56968DDD.9070509@aklaver.com>
Date: Wed, 13 Jan 2016 09:48:13 -0800
User-Agent: Mozilla/5.0 (X11; Linux i686; rv:38.0) Gecko/20100101
 Thunderbird/38.5.1
MIME-Version: 1.0
In-Reply-To: 
 <CACpWLjNkTR=SJn-717UtKaf0wJgjksRGk-v67__iY_=c+a02aA@mail.gmail.com>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-sql-owner@postgresql.org

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