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.
How to read a excel file in datastage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 51
- Joined: Sat Dec 09, 2006 3:32 am
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.
Re: How to read a excel file in datastage
You may want to reconsider that preference.elias.shaik wrote:And changing the files into some other files like CSV or text file is not preferred.
![Wink :wink:](./images/smilies/icon_wink.gif)
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 51
- Joined: Sat Dec 09, 2006 3:32 am
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.
http://www.opensourcetutorials.com/tuto ... page1.html
You will probably need to install the Perl Modules referenced in the article.