ODX server: Improve Error handling

The current ODX transfer process to the best of my understanding is as follow: 

  1.  create ODX target table according to table structure as collected by SYNC 
  2.  connect to datasource (ADO.NET)
  3. load source table (ADO.NET)
  4. fill ODX table with dataset 

The problem with this approach is TX and CData processes seems to be loosely coupled.  If an error has occurred, no rollback is performed.  ODX table will be read empty in the DWH 

My suggestion: change sequence so ODX table will only be created o if no error has occurred. 

The same sequence can be kept if the ODX table will be dropped upon error

If no error has occurred but the ODX is empty, show (mail) warning 





Please sign in to leave a comment.