Skip to Main Content
Forums

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!

ODI Excel question

ismaillJan 12 2009 — edited Jan 12 2009
Hi,

i have table in odi.and i want to to transfer the data in the table to a excel file using odi.
how can i do this??

Comments

566902
You are better off using the "IKM SQL to File Append" and to export the data to a csv file. If you really want to put it in an xls file, then you'll have to define a data server using the Excel technology, and use the JDBC ODBC bridge to write to the excel file.
You alos have the option of using the OdiSQLUnload tool to write to a Type=variable file.
1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Feb 9 2009
Added on Jan 12 2009
#business-intelligence-applications, #data-integrator, #excel, #odi, #system-management-and-integration, #variable
1 comment
986 views