With DataStage older than version 9.1, it was not possible to read Excel doucments (maybe, when using a Windows Server and creating an ODBC interface for teh Excel). But business folks, like the usage of Excel to collect their data (Excel is a good and powerful tool, but if it the right choice to collect data?), and with that, it is very common in a data migration project that you get hundreds of Excel to process in your ETL tools.
When not using DataStage 9.1, maybe the usage of a Java stage could help you
Because with the Java API Apache POI, it is easy to read Excel files (97 and 2007 format).
Read Excel files within of DataStage – using Java Stages – Part 1 weiterlesen