On 02/17/2016 03:42 PM, Ray Stell wrote:
I've dreaded this task coming my way for years. An Oracle developer wants to read postgresql data from his Oracle db. Is there a current, successful path to making this work or is it fools errand? I find this description: https://dbaspot.wordpress.com/2013/05/29/how-to-access-postgresql-from-oracle-database/ which is 3 yrs old. I see they want me to load an v8 rpm for the odbc driver so I tried to compile the latest and failed out of the gate. Just wondering if anyone has it working or not? Is there a more current howto?
if you're using postgresql 9.1+ you could give oracle_fwd a try: http://laurenz.github.io/oracle_fdw/ -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin