Do we have any option to clear data from an on-prem database table before it imports from EPBCS? — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Do we have any option to clear data from an on-prem database table before it imports from EPBCS?

edited Sep 5, 2025 11:02AM in Planning 6 comments

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!