Every week I am tasked with these steps and I'm wondering if it can be turned into an IPA:
Administration Console > Database > Replication > Search
Double-click main replication set
Select certain business class > Right click > Reset
Then go into OS > Data Fabric > Data Lake > Purge > Purge by filter
Select date range from 20 years ago to today and then select same business classes from before under "Data Objects" dropdown
Purge
When that's done, I run a SQL line for every business class
exec infor.clear_table('<Business Class>', 'true');
Then either kick off the replication of the replication set or wait for the scheduled replication to take place.
I do this once a week for about 18 business classes and would like to know if this can be more automated.
Any suggestions?
