Current position:  Home > Default > What is the use of an outbound Select in DB adapter

What is the use of an outbound Select in DB adapter

Time:November 30
Advertisement
Hi,
In an ESB project, I use a DB adapter to 'select' certain rows from a table. But it is being shown as an outbound adapter and I am unable to transform the xml output of the selected rows. How can I achieve this in ESB. If I use the same adapter in BPEL, it gives me a response xml which I can transform, but in ESB, I am unable to create a routing service that takes the xml output of the selected rows and does a transformation.
Thanks
Arvind
Advertisement
Hi Dominik,
        Thanks for the repy !!!!
Now, as you said we can access a (deep) node of the whole model using an access object.
Let us consider the component set ONEORDER. As seen we can use the following path to reach BTDocFlowAll using search object :-
BTQuery1O -> BTOrder  -> BTOrderHeader  -> BTHeaderDocFlowSet -> BTDocFlowSet -> BTDocFlowAll ....
Also, to reach BTDocFlowAll we can even use the access object as follows :-
BTAdminI -> BTItemDocFlowSet  -> BTDocFlowAll....
Now my question is :-
Normally we use the class cl_crm_bol_query_service to fire a search based on a search object. Can we use the same class to fire a search based on access object ?
(actually I currently dont have a CRM system so I could not try it out myself).
If not, then how do we fire a query using an access object ?
Regards,
Ashish