You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to read an Excel file via ODI 12c?

Received Response
14
Views
2
Comments
in Data Integration 2 comments

Summary:

Hi Team,

Could anyone please guide me on the below requirements related to excel file parsing using ODI -

  1. 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.
  2. Is it possible to convert an excel file (kept in a local drive) to a .csv file?

Thanks,

Partha

Content (required):


Version (include the version you are using, if applicable):


Code Snippet (add any code snippets that support your topic, if applicable):

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!