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
Expand all | Collapse all

Retreiving Data from published document

  • 1.  Retreiving Data from published document

    Posted Fri February 13, 2004 02:01 PM

    hi professionals,
    I need to extract data from the published document which is created by the adapter notification and write it to a file
    can u guys help in extracting the data from the Published document
    thanks


    #webMethods
    #Integration-Server-and-ESB
    #broker
    #Universal-Messaging-Broker


  • 2.  RE: Retreiving Data from published document

    Posted Fri February 13, 2004 06:06 PM

    Hello hemanbar!

    Not sure how far you got with this. But her is my 2 cents: Once you have created the notification document, publish it to the Broker and subscribed to it via a Trigger, you should be able to redirect that document to the assigned service for that trigger, the service pipeline should then contain the document. Be sure to fully qualify the the document name for you service inputs to view the document. Once in your service pipeline, it’s just like any other document.

    HTH!


    #Integration-Server-and-ESB
    #webMethods
    #broker
    #Universal-Messaging-Broker


  • 3.  RE: Retreiving Data from published document

    Posted Fri February 13, 2004 06:46 PM

    ya dezi.
    i catch ur point.
    but how to subscribe to the notification document via trigger.
    can u pls make it fast.
    very urgent
    thanks


    #webMethods
    #Universal-Messaging-Broker
    #broker
    #Integration-Server-and-ESB


  • 4.  RE: Retreiving Data from published document

    Posted Fri February 13, 2004 07:48 PM

    Ok I’ll try to make this a quick!

    I’m looking at 6.1 using JDBC Adapter Notification. Same should apply to 6.0.1

    From developer, after successfully creating your JDBC Connection and creating, say an InsertNotification,

    called test.notify:DBInsertNotification. This also generates a test.notify:DBInsertNotificationDocument

    make sure it’s publishable and in sync with the Broker.

    If connected to the Broker, this document should be published automatically or you can publish it
    using sync option at a later time.

    Now create a Trigger call test.notify:insertTrigger

    set the following:

    In document types and filters

    Add - test.notify:DBInsertNotificationDocument

    Condition:
    Name - “something meaningfully”
    Service - test.notify:targetService

    In you test.notify:targetService

    Add Document Reference - test.notify:DBInsertNotificationDocument
    (Reference should be fully qualified)

    e.g.

    test.notify:DBInsertNotificationDocument(DBInsertNotificationDocument)

    When the insert notification occurs, the trigger should re-direct to the service and then you can Map as usual.


    #Universal-Messaging-Broker
    #broker
    #Integration-Server-and-ESB
    #webMethods


  • 5.  RE: Retreiving Data from published document

    Posted Fri February 13, 2004 08:02 PM

    thanks Dezi,
    i did exactly the same way as u told and i created test.notify:targetService
    to write the data to a text file but it writes “null” in the text file


    #webMethods
    #Universal-Messaging-Broker
    #Integration-Server-and-ESB
    #broker


  • 6.  RE: Retreiving Data from published document

    Posted Fri February 13, 2004 09:16 PM

    The fact that the service is executed means that the document gets there and it is valid. Pleas make sure the notification was actually configured to return the fields in the record being updated. You have to manually add the fields and table name to be able to see data being returned. Returning all fields as String usually works well for testing.

    I would enable Audit Logging

    • Always
    • Error and Success
    • Always include pipeline

    You would need the WmMonitor (Services ->Search section “search by Current ContextID”) to take a look at the pipeline data.

    Not sure if you are using pub.flow.savePipelineToFile, but that should also show you the data.


    #webMethods
    #Universal-Messaging-Broker
    #Integration-Server-and-ESB
    #broker


  • 7.  RE: Retreiving Data from published document

    Posted Fri February 13, 2004 10:10 PM

    Is there any other option to configure to return the fields in the record being updated?.I added the table name and fields in the adapter notification editor.
    any way i tried with using pub.flow.savePipelineToFile,it shows the data in the document but it shows only the last record of the set of records inserted


    #Integration-Server-and-ESB
    #Universal-Messaging-Broker
    #webMethods
    #broker


  • 8.  RE: Retreiving Data from published document

    Posted Fri February 13, 2004 10:35 PM

    Looks like these multiple updates are part of a single transaction.

    You may have to commit updates one at a time to get multiple publishes on this doc.


    #broker
    #webMethods
    #Universal-Messaging-Broker
    #Integration-Server-and-ESB


  • 9.  RE: Retreiving Data from published document

    Posted Fri February 13, 2004 10:46 PM


  • 10.  RE: Retreiving Data from published document

    Posted Wed February 18, 2004 07:34 PM

    Also, take a look at the following:

    webMethods JDBC Adapter User’s Guide Version 6.0.3 (pg. 137)

    “Configuring OrderedNotifications”

    An OrderedNotification publishes notification data for multiple insert, update, or delete operations on multiple tables.


    #broker
    #Integration-Server-and-ESB
    #webMethods
    #Universal-Messaging-Broker