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
Skip to content
  • Register

    • How to read an Excel file via ODI 12c?

    in Data Integration 3 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!