This discussion is archived
4 Replies Latest reply: Sep 12, 2012 1:38 PM by KP RSS

Accessing flat_files of one machine in another machine through ODI

SriramKarthik Newbie
Currently Being Moderated
Hi All,

Suppose there are two machines M1 and M2.
In M1, we have some flat files like .txt, .csv etc.
In M2 machine, we had ODI. I would like to access the flat files in M1 in the M2 ODI.
Could you please let me know if we can achieve this.

Thanks in adv.
  • 1. Re: Accessing flat_files of one machine in another machine through ODI
    PeakIndicators_Alastair Guru
    Currently Being Moderated
    You could share the directory that the files are in on M1 to server M2 , thereby making them appear 'local' to M2 , or install an agent on M1 and run any jobs to access those files on that agent (read the file, copy the file to M2 etc).
  • 2. Re: Accessing flat_files of one machine in another machine through ODI
    _Phil Journeyer
    Currently Being Moderated
    Depending on the OS you're working on, you might try creating mounted directories on M2 which reference the directories containing the flat files on M1.

    Alternatively, you should set up a stand-alone ODI agent on the remote machine (M1) which will be local to the flat files.

    ...It appears Alistair beat me to this :)

    Edited by: _Phil on Sep 12, 2012 10:16 AM                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           
  • 3. Re: Accessing flat_files of one machine in another machine through ODI
    _Phil Journeyer
    Currently Being Moderated
    From a previous forum discussion, here's another route utilizing FTP if that works in your environment:

    https://kr.forums.oracle.com/forums/thread.jspa?threadID=1092330
  • 4. Re: Accessing flat_files of one machine in another machine through ODI
    KP Explorer
    Currently Being Moderated
    You can add the server 1 file drive as a Network drive in Server2 where you have ODI.
    then you can use as X:\<file Path> in your File Physical Schema directory in Topology Manager..

    -KP

    Edited by: KP on Sep 12, 2012 1:37 PM

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points