CAF -- Stored Procedure in portlet


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?



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.

CAF can directly access DB. why via IS?

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…