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.
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.
