Recommended approach to process large amount of data from Excelsheet

Hi there,

I have a question on the design of one of the projects I am working on. In one of the projects, we have a requirement of fetching an Excel sheet (size ~12 MB) having ~55000 rows into Appian daily from external source and process it. I would like to know what would be the better/recommended approach -

a) fetch and parse excel file through Appian (using Excel Tools plugin). [Per my understanding, fetching and parsing 55k rows of data daily using Appian may impact the performance of Appian.]

b) fetch and parse excel file through some other tool like Informatica and implement only workflow part of it in Appian.

Thanks!

  Discussion posts and replies are publicly visible