Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1aWABz-0002cP-8f for pgsql-admin@arkaria.postgresql.org; Wed, 17 Feb 2016 22:03:27 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1aWABy-0007HH-8Z for pgsql-admin@arkaria.postgresql.org; Wed, 17 Feb 2016 22:03:26 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1aWAAH-0004NX-So for pgsql-admin@postgresql.org; Wed, 17 Feb 2016 22:01:41 +0000 Received: from omr1.cc.ipv6.vt.edu ([2607:b400:92:8300:0:c6:2117:b0e] helo=omr1.cc.vt.edu) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1aWAAA-0004Sy-7s for pgsql-admin@postgresql.org; Wed, 17 Feb 2016 22:01:40 +0000 Received: from mr2.cc.vt.edu (mr2.cc.ipv6.vt.edu [IPv6:2001:468:c80:2105:0:212:7ed0:359e]) by omr1.cc.vt.edu (8.14.4/8.14.4) with ESMTP id u1HM1UEZ032694 for ; Wed, 17 Feb 2016 17:01:30 -0500 Received: from mail-qk0-f178.google.com (mail-qk0-f178.google.com [209.85.220.178]) by mr2.cc.vt.edu (8.14.4/8.14.4) with ESMTP id u1HM1P8E027683 for ; Wed, 17 Feb 2016 17:01:30 -0500 Received: by mail-qk0-f178.google.com with SMTP id x1so11684904qkc.1 for ; Wed, 17 Feb 2016 14:01:30 -0800 (PST) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:subject:to:references:from:message-id:date :user-agent:mime-version:in-reply-to:content-type; bh=UF6b1ySy7gol50XZzBTGXSyweHMkY2KeNwo1g3OmhaU=; b=DTkdGskYI4kcuopIWNcqU4iT2Obw04/p/MfWdkGl9jLrhkvBN+3kw9sqknbPL7EwBL ph324VAF+ZTdokXdC2O/ekvS4oucITtNueHHVdVOVt53sIOxP6+npoMbt/rPTWlEHEbl 9uNk0a2H0DNulH90Vysk8ewAsdqBBhr7R8UIARWkzx7jw7+2w74E7b7TKcckMn+5KvsJ U/Qy8K1gyBlnvon/CGWQnfWgFAvjyZQghjNkQE//pCPoQr2FOVQiwNPxFAgHXQLMgwsW 57GLRH5SGQB6dY3t+RWAKL5QvK/oWAGYEBx7tqbaIpJoH2Ayjj+ibK8QA6uKxSeKi+fV 4aLw== X-Gm-Message-State: AG10YOR+QHrucp6+OVPcafa4j34C+97A690qmxpXKw/ILDBZi7n4ngrzbM1fnmn3V58wk06C9MxpIEn3xKDW+RrOpWUs3foBPRAh0s1PVZv86cjbm0m+P4EShv2RBEmMqWtBvuzaWKOfq02ImLyijhxqkWs7RSKdaoq41IxaZjz7DBX7daTc3pSoECYp0bSC9FFPnpw= X-Received: by 10.55.76.15 with SMTP id z15mr4939343qka.32.1455746485535; Wed, 17 Feb 2016 14:01:25 -0800 (PST) X-Received: by 10.55.76.15 with SMTP id z15mr4939327qka.32.1455746485422; Wed, 17 Feb 2016 14:01:25 -0800 (PST) Received: from stell.cns.vt.edu ([2001:468:c80:2102:1d96:8f09:ef01:8a98]) by smtp.gmail.com with ESMTPSA id w190sm1342066qhw.29.2016.02.17.14.01.24 (version=TLSv1/SSLv3 cipher=OTHER); Wed, 17 Feb 2016 14:01:24 -0800 (PST) Subject: Re: oracle db reads from postgresql To: Scott Whitney , "pgsql-admin@postgresql.org" References: <56C486C2.9080702@vt.edu> From: Ray Stell Message-ID: <56C4EDB3.80906@vt.edu> Date: Wed, 17 Feb 2016 17:01:23 -0500 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.10; rv:38.0) Gecko/20100101 Thunderbird/38.6.0 MIME-Version: 1.0 In-Reply-To: Content-Type: multipart/alternative; boundary="------------000400090408020301090005" X-Spam-Status: No, score=-0.7 required=5.0 tests=HTML_MESSAGE, RCVD_IN_DNSWL_LOW autolearn=disabled version=3.3.1 X-Spam-Checker-Version: SpamAssassin 3.3.1 (2010-03-16) on mr2.cc.vt.edu X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org This is a multi-part message in MIME format. --------------000400090408020301090005 Content-Type: text/plain; charset=windows-1252; format=flowed Content-Transfer-Encoding: 7bit On 2/17/16 9:53 AM, Scott Whitney wrote: > The last time I did this, I started with this: > > http://docs.oracle.com/cd/E11882_01/gateways.112/e12070/toc.htm > > and specifically this: > > > http://docs.oracle.com/cd/E11882_01/owb.112/e10582/loading_ms_data.htm#WBDOD10660 > > > and modified appropriately for PG ODBC. > Found these docs on the oracle support web: How to Configure DG4ODBC on Linux x86 32bit or on HP-UX RISC (DG4ODBC 11.1 only) to Connect to Non-Oracle Databases post install (Doc ID 466228.1) Problems Configuring Database Gateway For ODBC (DG4ODBC) to Connect To Postgres (Doc ID 881667.1) --------------000400090408020301090005 Content-Type: text/html; charset=windows-1252 Content-Transfer-Encoding: 7bit On 2/17/16 9:53 AM, Scott Whitney wrote:
The last time I did this, I started with this:

http://docs.oracle.com/cd/E11882_01/gateways.112/e12070/toc.htm

and specifically this:


http://docs.oracle.com/cd/E11882_01/owb.112/e10582/loading_ms_data.htm#WBDOD10660


and modified appropriately for PG ODBC.

Found these docs on the oracle support web:

How to Configure DG4ODBC on Linux x86 32bit or on HP-UX RISC (DG4ODBC 11.1 only) to Connect to Non-Oracle Databases post install (Doc ID 466228.1)
Problems Configuring Database Gateway For ODBC (DG4ODBC) to Connect To Postgres (Doc ID 881667.1) --------------000400090408020301090005--