agora inbox for pgsql-sql@postgresql.org
help / color / mirror / Atom feedFrom: Adrian Klaver <adrian.klaver@aklaver.com>
To: Michael Moore <michaeljmoore@gmail.com>
To: postgres list <pgsql-sql@postgresql.org>
Subject: Re: best way sync data from Oracle to PostgreSQL?
Date: Wed, 13 Jan 2016 09:48:13 -0800
Message-ID: <56968DDD.9070509@aklaver.com> (raw)
In-Reply-To: <CACpWLjNkTR=SJn-717UtKaf0wJgjksRGk-v67__iY_=c+a02aA@mail.gmail.com>
References: <CACpWLjNkTR=SJn-717UtKaf0wJgjksRGk-v67__iY_=c+a02aA@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-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
view thread (2+ messages)
Message-ID: <56968DDD.9070509@aklaver.com>
Permalink: ../56968DDD.9070509@aklaver.com/
Also on: postgresql.org/message-id/56968DDD.9070509@aklaver.com
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: adrian.klaver@aklaver.com, michaeljmoore@gmail.com
Subject: Re: best way sync data from Oracle to PostgreSQL?
In-Reply-To: <56968DDD.9070509@aklaver.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox