Forum Stats

  • 3,837,490 Users
  • 2,262,264 Discussions
  • 7,900,301 Comments

Discussions

ODI Excel question

ismaill
ismaill Member Posts: 19
edited Jan 12, 2009 1:11PM in Data Integrator
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??
Tagged:

Answers

  • 566902
    566902 Member Posts: 809
    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.
This discussion has been closed.