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.  How view archive tables

    Posted Thu July 31, 2008 04:32 PM

    Instead of re-inventing the wheel, I was wondering if anyone has written or a built-in service in wM that’s able to get data in the archive tables. Basically, similar to the TN analysis but just reporting against the archive tables instead.


    #webMethods
    #Integration-Server-and-ESB
    #Flow-and-Java-services


  • 2.  RE: How view archive tables

    Posted Tue August 05, 2008 12:41 PM

    can you be specific regarding what tables and what data are you looking out for?


    #Integration-Server-and-ESB
    #webMethods
    #Flow-and-Java-services


  • 3.  RE: How view archive tables

    Posted Tue August 05, 2008 03:41 PM

    If you archive data, it goes into the tables that start with “ARCHIVE_BIZDOC…” I was going to setup a JDBC connection to the Oracle database execute sql statements to retrieve the data. The only is that one field is defined as BLOB.


    #Integration-Server-and-ESB
    #webMethods
    #Flow-and-Java-services