Hello,
We are doing an integration through a process that goes through a file that is in an SFTP, but we would like to be able to do a rollback if any problem occurs while reading records.
How could we create this control?
Thank you
Alex
Discussion posts and replies are publicly visible
It depends! It depends on exactly what is done with the content of that file. If it's a very simple application of some data to a single database table, then, as long as you can identify what the changes applied were and and generate the equivalent of a rollback, then it is possible.
If the file contents result in a process that changes database tables and calls multiple web services (both internal and external to your organisation) then the effort required to implement an automated roll-back grow exponentially.
So: do-able? Yes. Worth spending the time, effort and dollars on automating for a once-in-a-blue-moon scenario? Only you can answer that.
Hi, I think in the end I will control the rollback in a more manual way.
Thank you very much for your reply.