I am looking to automate the process of metadata build using OutlineLoad utility using flat files (csv format).
However the Planning Server is located on UNIX machine. Is there a way the Oracle team can place files on the Planning Server (UNIX box) or can I grab the files from a shared driver ( which I think is not possible but just want to confirm).
Would like to hear from someone who has done this before.
Thanks in advance
I am not sure what you mean by the Oracle team but anyway files can be easily transferred on to a unix machine by a number of different methods for example you could use SFTP/SCP.
I meant that the flat files will come from relational tables and it needs to be placed on Planning Server.
You mentioned that we can use SFTP for file transfer. Can this file transfer process be automated ? I think the answer is yes but just wanted to confirm.