Odata v2 query merge in SAP CPI

[former_member277492]

Hello Experts,

I am working on the Integration between SFEC and CPI. The requirement is to generate the output files separately for each template (Rate, Leave, Pension).

I have created the iFlow and to meet this requirement I have to select multiple Portlets in SF system separately and how do I be able to merge the query to extract the source data.

Ex: I am using these Portlets EmployeeTime, cust_NFE_Pension_Association and EmpCompensation.

Any Inputs would be greatly appreciated.

Thank you,

Best Regards,

Sree

[former_member277492]

Hello Shivaram and Vijay,

Thank you for the response.

I will check on the mentioned points and get back to you in case of any further issues.

Best Regards,

Sree

[Sriprasadsbhat]

Helllo Sreekar,

You can use Parlllel multicast and get all the required data from 3 portlet and then gather it.Later you can write XSLT or groovy to group the records based on Employee ID and perform necessary action.

Also you can check if there are any options to navigate from one entity to another so that you can avoid multiple api calls.

Regards,

Sriprasad Shivaram Bhat

[former_member666312]

HI ,

Do you mean you have to create multiple channels for each entity and create files ?

Thanks and Regards,
Vijay.