XML and Integrating with an ERP (Back-end)
Overview
Back-end integration (for example, with an ERP system) is most often achieved using a third-party integration tool, usually referred to as middleware. The bulk of back-end integration is accomplished by exchanging XML data between Oracle CPQ and the ERP system. There are 2 types of back-end integration:
Outgoing XML
This refers to all XML sent from to the partner server and from the partner server it is sent to the ERP system.
The partner server can be configured to modify the XML into a format that is understood by the ERP system.
Incoming XML
This refers to all XML sent from an ERP system to the hub and from the hub it is forwarded to the application.
The hub can be configured to modify the partner XML into a format that is understood by the application. You can use either the outgoing XML method or incoming XML method or both.
Administration
Best Practices
- Use built-in services instead of JavaScript when possible.
- Use string templates instead of concatenation.
- Insert database records all at once, not individually.
- Close database connections after insertion is completed.
Notes
- Recommended middleware: Oracle Fusion and Cast Iron. Other approved Enterprise Application Integration (middleware): Infomatica and Boomie.
- Other middleware would need to be reviewed before being used.
Related Topics
See Also