Oracle JD Edwards is an established vendor with a long track record in the manufacturing ERP space. We have a lot of customers that rely on JD Edwards to run their businesses. Keeping JD Edwards and CloudDISPATCH is sync is often one of the first integrations our customers consider.
Below is a list of general use cases for integration with ERP systems like JD Edwards. This information contains the general workflow and best practices we have discovered working with our customers.
General ERP Use Cases:
- Spares / Inventory Management
- Asset Management
- Master Data Management
- Allocation of Labor & Spares Costs from Shop Floor Activities
- Production Orders and Status
Supported Versions Details:
We support all recent versions of JD Edwards EnterpriseOne. We've had customers successfully integrate using both the L2L Integration Servers and other integration methods.
Integration Methods and Best Practices:
General Considerations
When it comes to JD Edwards, L2L CloudDISPATCH integration API endpoints and use cases are well known and documented. Depending on your specific JD Edwards spare parts reservations, ordering, receiving, and issuing procedures you will likely need to customize the JD Edwards interfaces to match your business needs. This is normal and average for this industry. JD Edwards is a very powerful financial system that allows for very advanced customizations that meet industry and company-specific policies, requirements, and regulations. Based on this you should plan on customizing and tailoring our best practices to fit your needs.
JD Edwards Connectivity Options
You have a couple of options when it comes to JD Edwards connectivity. JD Edwards provides APIs using programs written in a language like C that can use windows .DLL files. If you're more interested in accessing the database directly it provides an ODBC database interface. Since Oracle owns java they provide a java COM interface if you're into java. From within the platform, JD Edwards also has the ability to consume web services from external systems like CloudDISPATCH, which might be a good option depending on your needs. JD Edwards can also be accessed using middleware solutions that allow you to focus more on the business rules and data flow instead of the technical connection and API details. See the following documentation section for more information to determine which method is right for your integration.
JD Edwards EnterpriseOne Documentation
Oracle has some great documentation that can be useful during an integration. Here are some links that we found useful.
- Oracle JD Edwards EnterpriseOne Tools Documentation Release 9.2.x
- Integrating JD Edwards Orchestrator into an External Connection
- Oracle JD Edwards EnterpriseOne Tools Documentation Release 9.1.x
- Archive JD Edwards EnterpriseOne Documentation
Middleware Solutions
Depending on your established JD Edwards integration standards, you might develop this integration using an existing middleware solution. We have customers that have successfully completed this using some of the following middleware solutions:
https://community.boomi.com/s/article/howtoconnectjdedwardsapplication
https://anypoint.mulesoft.com/exchange/com.modus/mule-jde-connector/
https://www.jitterbit.com/jd-edwards-integration-made-easy/
L2L Integration Server
We provide a reference implementation for a JD Edwards integration as part of the L2L Integration Server. The L2L Integration Server is an on-premise java application with a number of pre-built ERP integrations, including JD Edwards. The L2L Integration Server runs behind your corporate firewall on a Linux or Windows host. It performs bi-directional synchronization between your L2L CloudDISPATCH Instance and your JD Edwards database. You'll need to customize the database tables and fields according to your specific JD Edwards customizations, use cases, policies, and procedures. We provide the L2L Integration Server with the java source code so you can easily extend and expand the functionality as you need. For more information regarding the L2L Integration Server, please contact support.
L2L API Code Examples
You might be asking yourself, I'm technical, can't I just do this myself? YES! Based on how easy it is to use our API, a lot of customers jump right in and write custom JD Edwards integrations using the tools, programming languages, and platforms they are most comfortable with. If this is you, we've created a number of API code examples in all of the most popular programming languages. Check out our Github repository at:
https://github.com/leading2lean
Related Articles:
- Spares API Integration Workflow
- Integration Options and Best Practices
- L2L Integration Overview and Architecture Diagrams