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