IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only
  • 1.  INSERT UPDATE and DELETE Notification

    Posted Tue November 11, 2014 03:06 PM

    Hi All,

    I wanted to know can template notifications polls to multiple tables.

    Can a signle pooling notification handled multiple table insert/update/delete ???

    Please let me know if this can achievable ??

    Shafi :slight_smile:


    #Integration-Server-and-ESB
    #Adapters-and-E-Standards
    #webMethods


  • 2.  RE: INSERT UPDATE and DELETE Notification

    Posted Tue November 11, 2014 03:42 PM

    No each notification can only monitor single table as per the WmART frame work.

    HTH,
    RMG


    #Adapters-and-E-Standards
    #Integration-Server-and-ESB
    #webMethods


  • 3.  RE: INSERT UPDATE and DELETE Notification

    Posted Tue November 11, 2014 03:56 PM

    ok …
    thats clear now thanks…

    Please let me know how to acieve… If we want to achieve this fuctionality to fetch the data from multiple table with optimise solution.

    without creating DB views


    #Integration-Server-and-ESB
    #Adapters-and-E-Standards
    #webMethods


  • 4.  RE: INSERT UPDATE and DELETE Notification

    Posted Tue November 11, 2014 04:26 PM

    Custom framework could be:

    May be you need to schedule a job (parent service) that handles logic based on the flags which can look up particular tables via Adapter Service and best contact would be owner of the tables if they can assist in the above flags based design (insert/update/delete) based records.

    HTH,
    RMG


    #webMethods
    #Adapters-and-E-Standards
    #Integration-Server-and-ESB


  • 5.  RE: INSERT UPDATE and DELETE Notification

    Posted Tue November 11, 2014 04:52 PM

    thanks again,

    The Schedule job will definately solve this problem.

    But, i hope, this will be a not real-time approach

    I am thinking on If i could build some RT ot any near Real Time. :slight_smile:


    #Adapters-and-E-Standards
    #Integration-Server-and-ESB
    #webMethods


  • 6.  RE: INSERT UPDATE and DELETE Notification

    Posted Tue November 11, 2014 05:38 PM