How to read an Excel file via ODI 12c?
Could anyone please guide me on the below requirements related to excel file parsing using ODI -
- Read the excel file placed in a local folder via ODI 12c and place the excel data into an ADW DB table. And please suggest any option other than-> https://blogs.oracle.com/dataintegration/post/how-to-load-data-from-excel-using-odi-1221-and-progress-datadirect-sequelink if at all feasible.
- Is it possible to convert an excel file (kept in a local drive) to a .csv file?
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):