Hi all,
We have the requirement to read from different databases 50k + entries, apply some validation rules and for the ones that fail the validaiton generate an approval workflow.
The recommendation that we have been given to the customer is that using Appian as an ETL tool is not a best practice. It is ok to use Appian for the approval workflow but to process 50k instances they should use an ETL tool. Or at least develop something in java and wrap it as an appian plugin. I dont see the benefit of using Appian for this and also I see potential problems with memory.
What is your opinion?
Discussion posts and replies are publicly visible
Agreed. Appian advises complex data processes to be done outside the Appian platform. Please use a Java service or employ ETL and then trigger Appian workflow.