Do we have any option to clear data from an on-prem database table before it imports from EPBCS?
Hi,
I am trying to create an integration for data export from EPM application to an On-premise database table using EPM Integration Agent. Integration runs fine and exported data is also reflecting in on-premise table. But, the problem is that It just adds the rows in table each time when it runs. There is no option to delete data in table before it loads again. I am using custom insert statement in the integration. I tried adding delete statement before insert in query but It went in error saying "Error: java.sql.BatchUpdateException: Actual statement count 2 did not match the desired statement