How to read xlsx file in Datastage

Asked By 50 points N/A Posted on -
qa-featured

I am having a requirement to read an excel file using Datastage. Please guide about, how to read xlsx file in Datastage without converting it to .csv format so that I can read through seq file, Instead I need to read it as .xls. Please guide me.

SHARE
Answered By 70 points N/A #141452

How to read xlsx file in Datastage

qa-featured

Microsoft Excel spreadsheets may be utilized as a data input in Datastage. Ultimately there are two probable methods available. Follow this methods to read xlsx file in Datastage without converting it to .csv format.

1) Access Excel file through ODBC – this method needs building an ODBC connection to the Excel documents on a Datastage server machine & usage an ODBC stage in Datastage. The main difficulty is that it is impossible to do this on a UNIX machine. On Datastage servers functioning in Windows it can be set up here:

First of all Go to Control Panel >> then Administrative Tools >> Next Data Sources (ODBC) >> User DSN >> Click Add >> Driver do Microsoft Excel (.xls) >> Provide a Data source name >> Next Select the workbook > and click OK.

2) Then Save Excel file as CSV – save data from an excel spreadsheet to a CSV text file & use a sequential stage in Datastage to read the data. Problem solved.

Login/Register to Answer

Related Questions