iWay Adapter for Oracle E-Business Suite

The iWay Application Adapter for Oracle E-Business Suite provides simple, open-standard access and interacts with Oracle E-Business Suite in three ways:

• Oracle stored procedures under a package (PL/SQL APIs)
• Oracle interface tables and custom interface tables
• Oracle base tables and views

In addition, the iWay adapter enables full integration of the Oracle E-Business Suite system with other enterprise resources, such as a database management system (DBMS) that has a JDBC™ 2.0–compliant driver, e-mail system, HTTP protocol–based server, or FTP server.

With the adapter, you also can connect to a host of enterprise integration systems (EIS), including popular applications for enterprise resource planning (ERP), supply-chain management (SCM), and customer relationship management (CRM). iWay’s Application Adapter for Oracle E-Business Suite comprises several execution agents that enable integration with other systems by functioning in one of two ways:

• Requests for Oracle inbound services – The adapter sends requests to the Oracle E-Business Suite system through Oracle interface tables and custom interface tables, stored procedures under a package, base tables and views, and Oracle published APIs.
• Listeners for Oracle outbound events – The adapter listens for application-based table activity.

iWay’s Application Adapter for Oracle E-Business Suite supports all interface tables. Some of the most common we interface with include general ledger, WIP work order, WIP move, payables, receivables, cash management, fixed assets, manufacturing and distribution, engineering and bills of material, cost management, master scheduling and Oracle supply chain, purchasing, quality, HR, and CRM.

Highlights

• Quick time-to-market – Complete integration projects 80 percent faster with iWay’s Application Adapter for Oracle E-Business Suite

• Monitoring and management – Get instant notification of data, messaging, and connectivity errors and full visibility of messaging movements and status
• Rapid development and service creation – iWay is 100 percent standards-based so there’s no need for niche skills and middleware experts. Drag-and-drop integration with Lawson S3 systems connects via XML, SOA services, etc.
• Unlimited integration possibilities – Connect to any database, messaging system, or prepackaged application with iWay’s pre-built adapters
• Deployment options – Support for all major integration and development platforms, including integration brokers, J2EE application servers, .NET, service transactions, and event architectures across a variety of transport mechanisms

Features

• Requests communicate with Oracle published APIs, interface tables, and custom interface tables, as well as base tables and views
• Asynchronous and synchronous processing
• Bidirectional message and request processing
• XML-based requests and responses
• Back-end error propagation with a table listener
• Support for Oracle business logic and functionality to ensure accuracy and maintainability
• A workbench for browsing Oracle E-Business Suite metadata and generating XML schemas for service requests

Product Details

Key features include:

• Dynamic introspection of metadata from the Oracle Data Dictionary and V$Parameter tables, as well as request and response schema generation
• XML-based payload requests can communicate with APIs, interface tables, base tables, and views to vary integration options based on your business needs
• Supports Oracle APIs (procedures within a package), including those with Oracle-specific data types such as Tables and Records
• Based on the integration methodology and business event, the adapter supports asynchronous and synchronous, bidirectional message processing
• Conforms to all W3C XML standards and generates valid standard schemas and WSDLs, which can be consumed by most third-party application servers
• Error Propagation – capture all system-level messages
• Enables interaction and integration with Oracle applications to maintain all Oracle business logic, functionality, and security and ensure accuracy, control, and data integrity
• High availability and load balancing with RAC support – uses Oracle’s RAC features to guarantee fully scalable, flexible, high-availability integration

For More Information

No other company provides the kind of sophisticated data integration and SOA-based integration technology that iWay Software does. To find out more, call toll-free (866) 297-4929 or e-mail us at info@iwaysoftware.com.