DB Triggers not working on data type tables while using excel Import
Hello,
we are looking for alternative options on below scenario.
There is Datatype in our application for which we have created Triggers on DB end on that table. while using individual Add/Update and Delete option from DataTypes, the Db triggers configured on that table are working fine, However while using bulk import option available on DataType, DB triggers are not working. we checked with Pega team and they confirmed, DB triggers wont work while using bulk import option.
we also explored other option, when this bulk import started happening, the file will be in static content folder but when bulk import is completed, this file will be deleted from system.
Is there any alternative option available to track the changes made on a table and take the back up of the actions performed?