Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to Read Excel data on linux using ODI.?

SanthoshSreshtaOct 8 2015 — edited Oct 8 2015

Hi Expertiese,

I am using ODI studio client on windows connected to Linux Server (ODI Server + Oracle Database ).

Now I need to get the Excel Data which is residing on linux machine.

Can anyone help me in creating a DSN on linux and linking the EXCEL path to it as we do on windows.

I am having WinSCP, Putty to view the files on linux machine.

I have succesfully got the data from EXCEL on windows following the ODBC connections. but unable to get from linux machine.

I am using ODI 11.1.1.9 on client and same on Linux Server.

Please help me in doing this.

Thanks a Million,

Santhosh.

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 5 2015

Added on Oct 8 2015

#business-intelligence-applications, #data-integrator, #system-management-and-integration

6 comments

658 views