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 :
- Import data from any environment , including own system or old system or from data collection device or external system or any others in the easier way possible,
- This consist of review the result of import run which as whole include verification ,validation, review, reimport and error identification
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 :
Frequency - The frequency is important in term of running the interface. Many times a interface need to run during month end processing, many times it runs in nightly basis as most of airlines industry updations happen in night only, or may be weekly only.
Batch - It should be real time, one time in day or one in batch ...somehow it is linked with Frequency.
Volume - This is yet another important to understand what volume data need to interface. This is very very important which is affect how technology is helpful in handling such a big volume.
Technology : This is based out of all above three factors ,
Accessing data :What access is there to the data? Typically points considered here are like;
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.
SeeBeyond (formerly STC)
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
BPEL stands for Business Process Execution Language (This was developed by IBM, BEA, and MSFT)
Development tools and server acquired with Oracleâ€™s purchase of Collaxa Inc.
Requires extra licenses beyond Oracle application licenses
Uses industry standards, web services, and business process design to orchestrate integration development
Marketed very heavily by Oracle as their current and future integration standard
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.