0 Replies Latest reply: Sep 16, 2013 5:18 AM by SubhrajyotiKundu RSS

    ODI 11g : JMS Queue XML Data Server creation

    SubhrajyotiKundu

      Hi Everybody,

       

      I am facing a problem while i am trying to create a JMS Queue XML data server in ODI 11g. I have
      the following details of the queue.

       

      QueueManager=xxx;
      TransportType=1;
      HostName=ab.cde.fe.com;Port=77777;
      Channel=CLIENT.TO.xxx1

      destination name : SU.BH.RAJY.OTI.UPDATE_ITEM_RESPONSE.01

      user : xyz
      password : 123

       

      I have sussefully created an jms datasouce in weblogic name 'eis/jms/abc' and also I have successfully
      retrived the xml message from queue in BPEL


      (using a jms adapter where
      JMS Provider : Third Party,
      Jms Provider Jndi Name -eis/jms/abc,
      Operation name : consume_message,
      destinamtion name is queue:///SU.BH.RAJY.OTI.UPDATE_ITEM_RESPONSE.01?targetClient=1).

       

      But the new reqirement is to retive the xml data in ODI using "JMS Queue XML data server".I have tried
      several ways(reading from internet) but failed to configure physical dataserver and reverse the xml message.
      Also failed to understand properly the oracle post (http://docs.oracle.com/cd/E21764_01/integrate.1111/e12644/jms_xml.htm#CHDFCFBI).
      Speically this portion "JNDI URL: <JMS_RESOURCE>?d=<DTD_FILE>&s=<SCHEMA>&JMS_DESTINATION=<JMS_DESTINATION_NAME>.".

      What will be the "JMS_RESOURCE" in my case.

       

      How can I configure JMS Queue XML?

      Please help!

       

      Note : I don't have the XML message structure of the Queue(also DTD file). So , I have to reverse it.


      Thanks & Regards,
      Subhra

       

      Message was edited by: SubhrajyotiKundu