we've a CSV documents being loaded robotically in Unix system. Requirement: We need to load the csv document from that faraway server to my oracle DB. We do have an ODI as our ETL tool. Can a person advice on a way to continue in addition. what is the manner to load the CSV from Unix server to Oracle DB.Please help us with a few record if this example is possible.
We have a CSV files being loaded automatically in Unix machine. Requirement: We need to load the csv file from that remote server to my oracle DB. We do have an ODI as our ETL tool. Can someone advice on how to proceed further. What is the way to load the CSV from Unix server to Oracle DB.Please help us with some document if this case is possible.
Are you trying to see if any of the Progress Datadirect products can help you achieve this?
If your question is more on how to do this with inbuilt functionalities in Oracle ODI; then you probably need to raise this question on Oracle Forum to get a better answer.
Thanks and Regards,
Lead Principal Software Engineer
Progress Software Development Private Ltd.