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.
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).