- OracleApps Epicenter - http://www.oracleappshub.com -
EBS – Integration/Interface options
Posted By Sanjit Anand On September 7, 2007 @ 10:08 am In API Integration | 5 Comments
Some time back in last post we have already seen the definition of interfaces and there types.Just to summarize here are the high points for interface :
Guess the next question in your mind will be what are the options available for interfacing with oracle ERP or any other ERP? The way integration and interfacing works in typical commercial application have almost similar in nature. Lets emphasize some options that technology offer in Oracle application. But the option will be drived on the basis of nature of system and process how its works , moreover Cost is yet another driving factors. From the integration and interfacing these important factors are :
Is this really driving the integration decisions for choice.? ...The answer is YES, on the top of other factors like cost, support etc...etc.But how...lets understand what is really means and how they really affect in :
Under these set of schema , a developer and designer have to take a call which options should he/she can go for interfacing?? Lets take some of the options :
Before exploring the some options, note that integration is broadly categorize into two types:
We are not going to discuss details her, lets take some of the options as for integration and interfacing in EBS.
Options 1: Open Interface Table (OIT)?
This is the the most standard way for doing interfacing in oracle application till day.This consist of developed interface table and programs. The underline interface table allow you to load data and then call concurrent program if any else use the standard AOL API's and have a custom concurrent program. The standard/custom concurrent program will take data from the interface table validate it and the data into application base products table.
This kind of Open Interface Table satisfy in most of time, as design and development does not requires much efforts.In oracle each product has number of OIT available to cater most of interfacing/integration need.
Options 2 : Application Programming Interface(API's)
Many time we need a tighter integration to oracle application that can be provided with interface table. In those cases, Oracle Application API's are indeed a good Options .APIs allow for tight integration into oracle application product. There are also 3rd party products that need to bolt-on into oracle apps with its integration capability. A typical API's works as figure in the right.
Options 3 : Enterprise Application Integration Tools (EAI) /Middleware Tools
When there is no standard Oracle process (no interface tables) as well no API's to import data.In that case, you have to write a program that inserts data directly into the Oracle Base Tables.Though this is not recommended by oracle as it any changes from oracle standard functionality may malfunction during patch or upgrade version. So there is another options where we can use some EAI or middle ware tool . EAI/Middle ware tools typically works as adaptor or connector which then take care of any insert /update in oracle base table without any risk.There are number of adapter available to integrate with oracle application.
These tools normally provide robust visual development GUI as well as have strong functionality to provide integration monitoring and alerting tools. I personally know Taviz( How good this is..i really like this ..sorry guys i am not sells person but Still i will recommode). Normally these tools are higher-quality than a options discussed in OIT or API's.
There are EAI vendors which has capability with interface and integrate with oracle application. Some of them are oracle cerified partners.
Normally most of EAI products provide a tool called "Studio" which uses a graphical environment for you to design integration process flows called orchestrations (integrations). Integrations are deployed to a provided â€˜Application Routerâ€™, which is an integration appliance pre-configured before it is installed at the customerâ€™s site.Provides native â€˜Connectorâ€™ to Oracle E-Business Suite.
Options 4 : EDI
EDI (Electronic Data Interchange) uses industry standard data definitions(US/ANSI/X.12) for transmission of documents such as POâ€™s, Invoices, Sales Order, etc.Oracle provides some EDI transactions through EDI Gateway.This is also a good options. More details can be found in my last post.1 .2 
A bit on other options
Options 5 : BPEL Process Manager
It is typically as similar to EAI but i personally found bit simpler. It Provides â€œDashboardâ€ for server maintenance and monitoring and moreover this is exposes Oracle APIs as web services. Only drawback is extra license and relatively higher learning curve may lead to higher initial costs
Options 6 : other Oracle Technology
By means of making a either PL/sql or stored procedure or hybrid process.
Will take some deep drive for options 4 and options 5 in some other post.
Article printed from OracleApps Epicenter: http://www.oracleappshub.com
URL to article: http://www.oracleappshub.com/api/ebs-integrationinterface-options/
URLs in this post:
 1: http://www.oracleappshub.com/edi/edi-e-business-suite/
 2: http://www.oracleappshub.com/edi/edi-e-business-suite-part-ii/
Disclaimer The opinions expressed here represent solely my own represent personal conjecture based upon experience, practice and observation and does not represent the thoughts, intentions, plans or strategies of my current & previous employers and their clients. Copyright © 2007-2010 OracleApps Epicenter. All rights reserved.