We are currently working on a simple ODI POC to extract data from a csv file using the File Generic data server technology. Similar to this tutorial https://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/odi/odi_12c/odi12c_exp_flat_2_tbl/odi12c_exp_flat_2_tbl.html#overview
So far, we are able to extract csv files from our local drives where Studio is running. For example, putting it in a directory called c:/csv on a local drive. However, our goal is to extract the csv file directly from the ODI server.
We are running our ODI 12C agent on a Linux server and ODI Studio on our individual Windows machines. Our version of ODI is 12.2.1.
Also, we have trouble importing knowledge modules. We can’t import them directly from the ODI server using ODI Studio. As a workaround, we sftp the knowledge modules to our desktops and then import from there. It sounds like we should be able to import KMs and flat files directly from the ODI server.
Are we missing something in our setup? What’s the trick to import data from a csv file located on the ODI server?
Thanks,
Steve