STFP files

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.