XML Interface with JDE

AprilP

Member
We're currently looking at a possibility of interfacing with JDE using XML files as inbound and outbound with our 3rd party applications. Any tips on how to make this happen smoothly?

Thanks in advance!
 
Hi,
look at MuleESB, it's an OpenSource Enterprise Service Bus.
You will have your integration architecture up and running in minutes with different protocols out of the box(ftp, file system, http, and much more). Let me know if you like this solution.

Regards

Bruno Condemi
 
Have you tried BI Publisher? I know it can be used for outbound. Not sure for inbound, have not tried it in inbound.
And if its not, We have developed simple report output by doing concat on your output, in the same way xml works. in one of my client we had to do it with regular report writer and it worked fine.
 
Yes,
I use MuleESB as a component for jde (and no jde) integration.
It works fine, no issue, and it's easy to configure and deploy.
I was able to use the jde java connector into a Mule flow and run the jde businness logic, run ube, etc... .
 
I use java api (dynamic java connector) and BSSV if I need to consume a standard process (ex. sales order processor).

Sometimes RTE.

No XMLList.
 
I am a little confused.

Did you use RTE and BSSV on the same project? Did you use the java connector with just RTE? Or java connector with RTE and BSSV?
 
I used RTE and BSSV on the same project.
I used only BSSV in another project (consumer and producer).
I used only RTE in another project (just to publishe the events into a JMS queue).

I never used java connector , RTE and BSSV in the same project.
 
April,
Are you looking for some kind of an interface or adapter to JDE that would expose the key functions of JDE which can then be consumed by your 3rd party applications?
 
You can create XML outbound with BIPubliser, some BSFN (B34A1190, B47XML01, for example) or internal BSSV with java. But for XML inbound you need create a C BSFN with XERCES or internal BSSV with java.

But I think MuleESB is very very interesting, I'll investigate and study this option. Thanks a lot! MuleESB is free, but for companies is free? and jd edwards connector is free? in this link seems is for pay http://www.modusbox.com/products/jd-edwards-connector/

Regards.
 
But for XML inbound you need create a C BSFN with XERCES or internal BSSV with java.
This is absolutely incorrect! You need to know about the JDE XML CallObject API!

The XML CallObject API is by far the easiest way to integrate with JDE. It is easy, quick & has a very small footprint. You likely won't even need to change anything about your JDE server setup to make it work.

The XML CallObject API is exposed in the Java-based "Dynamic Connector" library. It includes a standardized XML structure that allows you to invoke *ANY* JDE BSFN, without the use of BSSV Servers or any of that old GenJava crap. If you spend the time to learn it, you can send a large document that will invoke several BSFNs in a row, allowing you to chain a series of function calls into a single, very high performance request.

There's even a function that lets you pass in the name of a JDE BSFN and it returns a fully formed XML Request Template, with each parameter laid out in a "ready-to-use" manner.

Anyways, if you are interested in JDE integration, you need to know about the XML CallObject API!!

Read about it here: https://docs.oracle.com/cd/E24705_01/doc.91/e24253/undrstnd_xml_call_object.htm#EOTIN00483

I am not a Java programmer, but I built a small adapter that lets you hit the XML CallObject API from a simple HTTP request. If you are interested in building true BSFN-level integration with JDE – but you don't do Java – this is a way to do it completely FREE: https://github.com/brandonkirsch/JDEdwards-XMLRequest-Servlet

If you don't like free and unsupported software, then you might be interested in a commercial alternative: http://www.everestsoftint.com/products_everest2jde.php
 
Thanks brandonkirsch! I'm goint to read your links, investigate about it and try.

Regards.
 
There is a new version of Modubox JDE Connector

Main features include:

•Invoke any JDE Business Function (BSFN) on the server using proper parameters
•Invoke a Universal Batch Engine (UBE) process by name and version.
•Include Data Selection to filter the records to be processed when submitting UBEs
•Pass Report Interconnect (RI) parameters to a UBE.
•Check a UBE call status.
•Poll for outbound events that come from an application, which uses a Master Business Function to generate transactions with Interoperability activated
•Poll EDI Events to capture outbound transactions that are generated from EDI Module applications.
•Invoke multiple BSFNs within the same database transaction
 
Back
Top