Wednesday, December 12, 2012

Creating the reports based on the data from weblogic JMS queue – Oracle BAM

Creating the reports based on the data from weblogic JMS queue – Oracle BAM


Oracle BAM supports the reporting based on the data from External Messaging Sources.
This post explains the steps to create a report based on the data from the weblogic Queue.

Create the data object:

Create a data object with required fields to populate the data from the JMS Queue (Refer the previous post for the steps to create the Data Object).Here I am creating the Employee data object with three fields.

Configure the External Messaging Source:

These steps configure the JMS queue and map the JMS data to the data object (Employee) created in the previous step.
  • Click on Architect button from the Start up page.
  • Select External Message Source from the drop down list.
  • Enter the name for the message source and also the JNDI Service provider URL, Queue connection factory name and Queue name.
  • Select the JMS Message Type as TextMessage.
  • Select the Data object name as Employee created in the previous step and also select the operation as Insert.



XML Formatting – Pre-Processing can be used to process the incoming xml message with XSLT (For this scenario I am not using any XSLT processing).
  • Enter the Message Element name as the parent element of the message.For my case the Message Element Name is EMPLOYEEDETAILS.

<?xml version="1.0" encoding="UTF-8"?>
<EMPLOYEEDETAILS xmlns="http://bamems.sample.com">
   <EMPNAME>Albin</EMPNAME>
   <EMPNO>24</EMPNO>
   <EMPAGE>27</EMPAGE>
</EMPLOYEEDETAILS> 
  •  Select Namespace Qualified checkbox and enter the name space value if the message is qualified with the name space. My case the name space is http://bamems.sample.com.
  • Select the Column value as Element Tag.
  • Select the data object the field name enter the corresponding XML tag name.


  • Click on save.
  • Post the sample data to the JMS queue and same can be verified in the Employee data object.
<?xml version="1.0" encoding="UTF-8"?>
<EMPLOYEEDETAILS xmlns="http://bamems.sample.com">
   <EMPNAME>Albin</EMPNAME>
   <EMPNO>24</EMPNO>
   <EMPAGE>27</EMPAGE>
</EMPLOYEEDETAILS>



Create the Report:

  • Create a report based on the Employee data object.




No comments:

Post a Comment