Read Windows File on Unix

PeteM2 · Post by **PeteM2** » Mon Aug 01, 2016 5:28 am

Our datastage environment sits on a unix server and we are on version 9.1.2 now.
We have a requirement wherein we have to read a few excel sheets located on a Windows folder and load the data into oracle tables.
Was trying to find out if this is achievable and the best possible way to do it.

Thanks.

chulett · Post by **chulett** » Mon Aug 01, 2016 6:32 am

Any files need to be 'local' to the DataStage server in order to be consumed, either via a share mechanism or transportation. Once there, you have a couple of options on reading native Excel files if you don't want to go through converting them to csv first.

One would be ODBC for Excel but I don't recall if that ships with the product or you would need to purchase it. It can also be a bit of fun if you need to read from multiple worksheets. The other option is the Unstructured Data stage which is all about reading Excel files.