When integrating with Oracle e-Business Suite (aka EBiz), there are various options available. This post summaries the available technologies to connect through Oracle SOA Fusion Middleware.
PLSQL API (Standard or Custom built)
This approach involves invoking the Oracle Ebiz APIs, through SOA Fusion Middleware
Pattern
Inbound (Data insert/update), Outbound (Query/Fetch), Synchronous, Real-time
SOA FMW Connectivity
Discover the required API in the Ebiz Integration Repository OR Create the required custom API in Ebiz
Configure the Apps Adapter in a SOA Composite (Mediator) for the corresponding API
Suggested Usage
Usually suitable for any volume of data
Data Size: Medium Size of data per integration
Medium/High Frequency integrations
Sample Scenarios
Get Item Details, Create Sales Order
Advanced Queue (AQ)
AQs are queues that are configured within Oracle EBiz. Payload can be dropped onto the AQ for consumption by subscribers
Pattern
Outbound (Send data out of EBiz), Asynchronous, Real-time
SOA FMW Connectivity
Create the AQ in Ebiz – the process/programs to generate data on the AQ are to designed/developed in Ebiz
Configure the AQ Adapter in a SOA Composite for the corresponding AQ
Suggested Usage
Data Size: Medium/High Size of data per integration
Low/Medium/High Frequency integrations
Sample Scenarios
Outbound Sales Order
Business Events
Oracle EBiz triggers event subscription for significant events/updates that happen within the system.
Pattern
Outbound (notification of significant events happening in EBiz), Asynchronous, Real-time
SOA FMW Connectivity
For outbound integration with Ebiz, configure the Ebiz Business Event System to generate business events (either standard or custom). These events are consumed in SOA
Discover the required business events in the Ebiz Integration Repository based on the business requirement
Configure the Apps Adapter in a SOA Composite for the corresponding business event
Suggested Usage
Any Volume of Data
Data Size: Low Size of data per integration
Low/Medium/High Frequency integrations
Sample Scenarios
Capturing updates to Items in EBiz, Creation of new Pricelists, Capturing updates to Sales Orders
SOA Gateway
Integrated SOA Gateway (ISG) was included in Oracle EBiz R12. ISG helps expose the PLSQL APIs as SOA Services, which can be invoked through the WSDL.
Pattern
Inbound (Data insert/update), Outbound (Query/Fetch), Synchronous, Real-time
SOA FMW Connectivity
Configure the required ISG WSDL in Oracle EBiz
Invoke WSDL through a partner link in the SOA Composite
Suggested Usage
Low/Medium Volume of Data
Data Size: Low/Medium Size of data per integration
Low/Medium/High Frequency integrations
Sample Scenarios
Get Item Details, Create Pricelists
Interface Tables
These are database tables in Oracle EBiz. SOA connects to EBiz to drop data onto these tables, which is picked up for processing through scheduled programs/APIs. There are standard interface tables available; however custom tables can also be created.
Pattern
Inbound (Data insert/update), Asynchronous, Delayed Response
SOA FMW Connectivity
Discover the required interface table in the Ebiz Integration Repository OR Create the required custom table in Ebiz
Configure the Apps Adapter or an DB Adapter in a SOA Composite for the corresponding Table
Configure a scheduled program which will pick up the data from the interface table for further processing
Suggested Usage
Any Volume of Data
Data Size: High Size of data per integration
Medium/High Frequency integrations
Sample Scenarios
Create Sales Order, Create Customer
Summary
Both Oracle EBiz and SOA FMW provide various mechanisms for connectivity which helps simplify the integration. However, a good analysis is required to determine the appropriate mechanism. Following factors can help with the analysis:
Oracle IREP
The Oracle EBiz Integration Repository (IREP) provides all the details on the standard end points available. This is a catalogue of all the available end points like APIs, interface tables etc for various product families within EBiz.
Details are available here:
http://docs.oracle.com/cd/E18727_01/doc.121/e12064/T291171T329891.htm
PLSQL API (Standard or Custom built)
This approach involves invoking the Oracle Ebiz APIs, through SOA Fusion Middleware
Pattern
Inbound (Data insert/update), Outbound (Query/Fetch), Synchronous, Real-time
SOA FMW Connectivity
Discover the required API in the Ebiz Integration Repository OR Create the required custom API in Ebiz
Configure the Apps Adapter in a SOA Composite (Mediator) for the corresponding API
Suggested Usage
Usually suitable for any volume of data
Data Size: Medium Size of data per integration
Medium/High Frequency integrations
Sample Scenarios
Get Item Details, Create Sales Order
Advanced Queue (AQ)
AQs are queues that are configured within Oracle EBiz. Payload can be dropped onto the AQ for consumption by subscribers
Pattern
Outbound (Send data out of EBiz), Asynchronous, Real-time
SOA FMW Connectivity
Create the AQ in Ebiz – the process/programs to generate data on the AQ are to designed/developed in Ebiz
Configure the AQ Adapter in a SOA Composite for the corresponding AQ
Suggested Usage
Data Size: Medium/High Size of data per integration
Low/Medium/High Frequency integrations
Sample Scenarios
Outbound Sales Order
Business Events
Oracle EBiz triggers event subscription for significant events/updates that happen within the system.
Pattern
Outbound (notification of significant events happening in EBiz), Asynchronous, Real-time
SOA FMW Connectivity
For outbound integration with Ebiz, configure the Ebiz Business Event System to generate business events (either standard or custom). These events are consumed in SOA
Discover the required business events in the Ebiz Integration Repository based on the business requirement
Configure the Apps Adapter in a SOA Composite for the corresponding business event
Suggested Usage
Any Volume of Data
Data Size: Low Size of data per integration
Low/Medium/High Frequency integrations
Sample Scenarios
Capturing updates to Items in EBiz, Creation of new Pricelists, Capturing updates to Sales Orders
SOA Gateway
Integrated SOA Gateway (ISG) was included in Oracle EBiz R12. ISG helps expose the PLSQL APIs as SOA Services, which can be invoked through the WSDL.
Inbound (Data insert/update), Outbound (Query/Fetch), Synchronous, Real-time
SOA FMW Connectivity
Configure the required ISG WSDL in Oracle EBiz
Invoke WSDL through a partner link in the SOA Composite
Suggested Usage
Low/Medium Volume of Data
Data Size: Low/Medium Size of data per integration
Low/Medium/High Frequency integrations
Sample Scenarios
Get Item Details, Create Pricelists
Interface Tables
These are database tables in Oracle EBiz. SOA connects to EBiz to drop data onto these tables, which is picked up for processing through scheduled programs/APIs. There are standard interface tables available; however custom tables can also be created.
Inbound (Data insert/update), Asynchronous, Delayed Response
SOA FMW Connectivity
Discover the required interface table in the Ebiz Integration Repository OR Create the required custom table in Ebiz
Configure the Apps Adapter or an DB Adapter in a SOA Composite for the corresponding Table
Configure a scheduled program which will pick up the data from the interface table for further processing
Suggested Usage
Any Volume of Data
Data Size: High Size of data per integration
Medium/High Frequency integrations
Sample Scenarios
Create Sales Order, Create Customer
Summary
Both Oracle EBiz and SOA FMW provide various mechanisms for connectivity which helps simplify the integration. However, a good analysis is required to determine the appropriate mechanism. Following factors can help with the analysis:
- Data volume flowing in and out of Oracle EBiz
- Size of the payload
- Frequency of the integration
- Synchronous and Real-Time requirements
- Oracle EBiz development capabilities (this will decide whether custom development should be considered)
Oracle IREP
The Oracle EBiz Integration Repository (IREP) provides all the details on the standard end points available. This is a catalogue of all the available end points like APIs, interface tables etc for various product families within EBiz.
Details are available here:
http://docs.oracle.com/cd/E18727_01/doc.121/e12064/T291171T329891.htm
