We are working on a project wherein we pull data from an external application an

gopinathreddyr over 9 years ago

We are working on a project wherein we pull data from an external application and act on this data. There might be scenarios where the data in external application might change and in-order to detect this discrepancies we have a process model that would compare both the data(Data we are working in Appian and external application data) and show all the discrepancies detected. Now we have a use case where in we need to generate a daily excel report of this discrepancies . And there might be around 1000-2000 cases that this process model need to run. Any help on how this can be achieved in Appian without performance issue is appreciated.

Discussion posts and replies are publicly visible

Parents

0 Shyam Bommakanti
Certified Lead Developer
over 9 years ago

How complex is the compare? Can you do it in a complex rule?

Assuming rule, create a rule that compares and returns you the result. And execute it in a process when the system is least used. Delete or archive the process sooner based on your retention requirement. Default 7 days should be good for future debugging if needed.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Shyam Bommakanti
Certified Lead Developer
over 9 years ago

How complex is the compare? Can you do it in a complex rule?

Assuming rule, create a rule that compares and returns you the result. And execute it in a process when the system is least used. Delete or archive the process sooner based on your retention requirement. Default 7 days should be good for future debugging if needed.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data