Posts

Showing posts from June, 2023

Learn How to Utilize XQuery Mapping in OSB 12c

Image
In integration scenarios, it is common to encounter situations where the source and target systems have different payload structures. The source system may send a payload with a more extensive set of columns, while the target system may only require a specific subset of these columns, or vice versa. In such cases, it becomes necessary to align the payload structures of the source and target systems to enable effective communication between them. Various integration platforms offer their own mechanisms for mapping elements, but in the case of OSB (Oracle Service Bus), we can utilize XQuery mapping to map the payload elements Let's use the existing application where  Business Service is using Database Adapter to fetch records based on the input parameter CustomerId.  Input Response having one element that is :  Cust Id Output Response having multiple Elements like :  CustId   CustomerName City Designation LastUpdateDate LastUpdateLogin CreationDate CreatedBy...