How to write only unique entries in the table

Hi team,

I am capturing data from process metrics report and storing to oracle db as it's business requirement.

Now I just want to check is there any inbuilt functionality of Appian which only writes the rows in table which has been not inserted in the previous run ?

if not is there any suggested way you recommend that can be followed to achieve the same ?

  Discussion posts and replies are publicly visible

Parents Reply
  • If I want to do it without procedure.. one way I am thinking is to get data in batches the concern that I have with this approach is as the data will keep on growing and our database hits will be increased so that can cause an issue in future. so as an alternative what I am thinking is to create a record on that table and hit the record and get data in batches and as per my understanding it would solve multiple db hits problem.. is my understanding correct ?  or do you think any caveat in this alternate solution.. 

Children
No Data