ODI Snippets: Oracle Data Integrator, Excel data types, and limitations of the MS Excel ODBC driver.

Uli Bethke Oracle Data Integrator (ODI)

I have come across two serious issues when loading data from Excel into Oracle Data Integrator. These are not related to ODI, but are shortcomings of the Microsoft Excel ODBC driver. Both issues are explained on Metalink: (1) Excel Returns NULL Values When Numeric And Alphanumeric Datatypes Are Intermixed Within The Same Column (424419.1) Extract from Metalink "Having defined a ...