Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Data Transfer between two instances

Re: Data Transfer between two instances

From: Mladen Gogala <mgogala_at_adelphia.net>
Date: Sun, 19 Oct 2003 22:44:25 -0800
Message-ID: <F001.005D3ABD.20031019224425@fatcity.com>


That is actually what external procedures were made for. So, here is how I would do it:
I would create a set of C programs which would ask the server process on the SAP DB side for the data and then deliver that data back to oracle. You have a myriad of means for communication between the processes:

To make things even better, both vendors support some of the products listed above (CORBA, TP monitors, messaging systems) on the marketing level. If I were you, and if there weren't gigabytes of information to transfer in a secure fashion over WAN, I'd stick with pipes or sockets.

On 2003.10.20 01:39, Gunnar Berglund wrote:
> Hi all,
>
> we have an application which needs data from other environment (which is
> actually SAP db). Currently we have implemented it the way we create flat
> files and put them in using pl/sql -procedures but I don't like this because
> the data in the flat files are "visible" and it is somehow "secret".
>
> What other options we might have if we do not want to use db links (because
> of its slowness.
>
> I very much appreciate all your suggestions...
>
> TIA
> gb
>
>
> ---------------------------------
> Want to chat instantly with your online friends? Get the FREE Yahoo!
> Messenger

-- 
Mladen Gogala
Oracle DBA
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mladen Gogala
  INET: mgogala_at_adelphia.net

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Mon Oct 20 2003 - 01:44:25 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US