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

CAF -- Stored Procedure in portlet

  • 1.  CAF -- Stored Procedure in portlet

    Posted Tue November 25, 2008 10:44 PM

    Hello,

    I want to invoke a stored procedure and display the resultset in CAF portlet.

    Can I use database connector? if not, what is the approach?

    Thanks,

    Shuren


    #webMethods
    #webMethods-BPMS
    #MWS-CAF-Task-Engine


  • 2.  RE: CAF -- Stored Procedure in portlet

    Posted Sun November 30, 2008 09:49 PM

    Create a service wrapper for the stored P. in IS that has the required input and output.

    Create a portlet in designer and browse the service, drag and drop it to the view.

    This step will create for you all the required input and output boxes in view and will bind them with the corresponding fields in the services.


    #webMethods
    #MWS-CAF-Task-Engine
    #webMethods-BPMS


  • 3.  RE: CAF -- Stored Procedure in portlet

    Posted Mon December 01, 2008 02:48 AM

    CAF can directly access DB. why via IS?


    #webMethods
    #MWS-CAF-Task-Engine
    #webMethods-BPMS


  • 4.  RE: CAF -- Stored Procedure in portlet

    Posted Tue December 02, 2008 05:49 PM

    Definitely u can connect to DB in different ways. I am assuming if u r using MWS, u are also using IS to integrate to different systems. If the database is already connected to IS, I would use the easiest way, which is drag and drop…


    #webMethods-BPMS
    #webMethods
    #MWS-CAF-Task-Engine