How to read a excel file in datastage

[elias.shaik]

Hi all,

Could some one tell how to read excel files in datastage.We are using Datastage 7.5.1 and installed on unix system.

And changing the files into some other files like CSV or text file is not preferred.

Thanks in advance.

regards,
Elias.

[ArndW]

If your DataStage server is on UNIX then you will need to buy a 3rd party software package to read Excel files directly using ODBC. The vendor that springs to mind is DataDirect. There are also Java apps in the public domain that might be used to do this, but I have no experience with that.

[chulett]

And changing the files into some other files like CSV or text file is not preferred.

You may want to reconsider that preference.

[elias.shaik]

I heard of other two options instead of drivers.
1.Perl script
2.Dump into Oracle database.

Not sure how this is possible , please provide pointers.

[tomk]

For Parsing Excel from Perl, take a look at the following URL:

http://www.opensourcetutorials.com/tuto ... page1.html

You will probably need to install the Perl Modules referenced in the article.