-
1. Re: Use Excel file stored in AWS S3 as a source
Sandeep Nanjappa Oct 10, 2019 5:29 AM (in response to Nick White)As of current release , we don't support reading excel files from Amazon S3 or S3 V2 connector.We may need to use pre-processing script to covert the XLS format to CSV and read .
Ref:windows - Convert XLS to CSV on command line - Stack Overflow
-
2. Re: Use Excel file stored in AWS S3 as a source
Biswadeep Sen Oct 10, 2019 6:26 AM (in response to Nick White)Nick,
The Microsoft Excel file must be located on the same machine on which the Secure Agent runs. So it is not possible to get excel file from S3. And the connector is currently in maintenance mode.
Informatica Cloud Connector End of Life and Maintenance Mode (IICS)
For S3 connector, if the file is an excel file (extension .xls) then it will not be able to read as it can read text files (.txt, .csv). For more details, check these two links;
Source Types in Amazon S3 V2 Sources
For a workaround, I can suggest converting excel file into CSV file and process. That would resolve this issue.
~ Biswa