Hi,
We wanted to do a POC and connect to an Enterprise Service Bus via Java Message Service Topic XML from ODI.
The user has a Sonic ESB version 8.0.1 and we have been provided with the .jar files from SonicMQ. Both the client machine where the ODI Client is installed as well as the ESB server are within the same Virtual Network and they ping each other. The ODI version that we are using is 12.1.3.0.0.
We aslo have a custom JAVA client that is able to successfully connect to the ESB bus.
We have copied the jar files provided on both ODI client and Weblogic server directories, but we cannot find a folder like “Oracle_home/oracledi/drivers”, so we put the files in:
ODI Client Machine -> “C:/Users/Myuser/AppData/Roaming/odi/oracledi/userlib”
Weblogic server -> “/app/oracle/product/fmw/odi/agent/lib”
We are trying just "test button", do we have to configure something in the model on the designer tab?
In the topology tab, we are trying with two scenarios:
Scenario 1
JMS Topic XML Technology:
Definition tab -> Name, and data server ip address provided by the user where the ESB can be accessed. Connection has the test and password account provided by the user for the test.
JNDI Tab ->
JNDI Authentification: Simple
JNDI User: Provided by user
Password: Provided by user
JNDI Protocol: blank
JNDI Driver: com.sonicsw.jndi.mfcontext.MFContextFactory
JNDI URL : ldap://xx.xx.xx.xxx:2506?d=C:/Users/Myuser/Desktop/FData_3_4.xsd&JMS_DESTINATION=JNDI topic reference provided by the user
JNDI Resource: jms/TopicConnectionFactory
When you click “Test Connection” (both local and agent) you receive a ODI-40105 error message, Connecting to JMS Using URL JDBC:SNPS:JMSXML:jndi:ldap://xx.xx………..
Scenario 2
Progress Techonology (as SonicMQ was part of Progress before Aurea):
Definition tab -> Name, and data server ip address provided by the user where the ESB can be accessed. Connection has the test and password account provided by the user for the test.
JNDI Tab ->
JNDI Authentification: Simple
JNDI User: Provided by user
Password: Provided by user
JNDI Protocol: <undefined>
JNDI Driver: com.sonicsw.jndi.mfcontext.MFContextFactory
JNDI URL : ssl://xx.xx.xx.xx:2506
JNDI Resource: jms/TopicConnectionFactory
When testing……….. Cannot instantiate class… Root exception is …. Java.lang.ClassNotFoundException: com.sonicsw.jndi.mfcontext.MFContextFactory.
Has anybody found a working example for a pretty similar scenario?
Thanks,
Fernando.