E9.2 Integrate Inbound & Outbound C-XML to JDE

coolkl

Well Known Member
Hello All,

We have a unique challenge to integrate C-XML for Inbound and Outbound with JDE. C-XML will also embed Attachments that needs to be moved to JDE and attached to Sales Order.

Questions:
  1. How to convert Inbound C-XML to XML or CSV (preferable). Is there a third-party tool or some script we can write to convert to CSV and then do the integration. Any help is appreciated.
  2. How to extract & convert embedded Attachments in C-XML to JDE Media Objects (PDF) and write to Fileserver folder.
Thanks,
coolkl
 
Hello Hari,

Thanks. I reviewed the link. However not sure how will the Lynx Integrator convert & map the Media Objects along with data into JDE.
Does it write to JDE files or dumps a CSV output ? How will the media objects integrate ?

Request if you can help with more details.

Thanks.
 
Hello Hari,

Thanks. I reviewed the link. However not sure how will the Lynx Integrator convert & map the Media Objects along with data into JDE.
Does it write to JDE files or dumps a CSV output ? How will the media objects integrate ?

Request if you can help with more details.

Thanks.

All of that can be done in a business process, which is essentially a C#/.NET class library. All JDE functionality (including media objects) is called from .NET directly. CSV conversion is really not required, as the C-XML can be uploaded as a file through SOAP or REST API. If XML to CSV conversion is required, we have a component to do that as well.
 
Oracle Data Integrator (ODI) is a nice tool to handle inbound XML or C-XML file, where you can do re-verse engineering to convert XML data into relational database tables. This means developer can process XML file without XML knowledge.
 
Back
Top