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 gopinathreddyr over 9 years ago

@sikhivahans Thank you for your response. The comparison logic is a process model. Each case created has several parameters that need to be compared (To make sure that data in Appian and External Application are in sync ).So for all these comparisons we have a process model(which internally calls sub-process for every parameter that needs to be checked for). To execute this entire process it takes around 30-40 sec. Case is a individual record in our application.So depending on the case count,I need to run this comparison process model and collect all the differences .This later would be exported to excel.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 gopinathreddyr over 9 years ago

@sikhivahans Thank you for your response. The comparison logic is a process model. Each case created has several parameters that need to be compared (To make sure that data in Appian and External Application are in sync ).So for all these comparisons we have a process model(which internally calls sub-process for every parameter that needs to be checked for). To execute this entire process it takes around 30-40 sec. Case is a individual record in our application.So depending on the case count,I need to run this comparison process model and collect all the differences .This later would be exported to excel.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data