        |  |
 |
 |
 |
 |
 |
 |
 |
 |
 |
|
Connect for Oracle E-Business Suite User's Guide
CHAPTER 1
Welcome to the Novell exteNd Composer Connect for Oracle E-Business Suite User's Guide. This Guide is a companion to the Novell exteNd Composer User's Guide, which describes how to use all the features of Composer except for the Connect Component Editors. You should be familiar with the Composer User's Guide before using this Guide.
Novell exteNd ComposerTM provides separate Component Editors for each Connect, including the Connect for Oracle E-Business Suite. The special features of each component editor are described in separate Guides, like this one.
If you have been using exteNd Composer and are familiar with the core component editor (the XML Map Component Editor), then this Guide should be enough to get you started with the Oracle E-Business Suite Component Editor.
NOTE: To be successful with this Component Editor, you must be familiar with Oracle E-Business Suite and basic XML integration concepts.
Novell exteNd Composer is the XML integration-broker component of the Novell exteNd suite. It encompasses a set of design tools for building XML integration applications and Web services, plus a runtime engine that enables execution and administration of the services that you build. The applications and services that you build with Composer can be deployed to any popular J2EE application server or servlet container. Supported application servers include JBoss, IBM WebSphere and BEA WebLogic in addition to the Novell exteNd application server. Apache Jakarta Tomcat is also supported. Check the Novell Web site for latest platform-support information.
At the core of Composer is a robust XML transformation engine capable of performing a wide range of data transformations, including joining of multiple documents, decomposition of documents, and creation of entirely new documents. The underlying enabling technologies include XSLT, XPath, ECMAScript, and Java. The Composer design environment offers a rich, intuitive graphical user interface, making it possible for you to specify XML transformations and mappings visually, using wizards, dialogs, and drag-and-drop gestures. You never have to write raw XSL or Java code.
Composer supports numerous kinds of data-source connectivity, through individual adapters called Connects. Using the functionality exposed in the various Connects, you can design EAI applications and Web services that pull data in from or push data out to different kinds of back-end systems, using a variety of transport protocols and technologies, ranging from 3270 and 5250 terminal data streams to Telnet, HP3000, Unisys T27 (and UTS), Tandem, and Data General, in addition to HTML screen-scraping, JMS messaging, and CICS RPC transactions. You can also take advantage of JDBC, LDAP, and other mechanisms to reach back-end data repositories and systems that might or might not natively understand XML. Composer Connects allow you to connect to these systems inobtrusively, so as to marshall non-XML data into XML form or vice versa without any need to modify host-system setups or code.
In addition to legacy data-stream and protocol-specific Connects, Composer has Connects for ERP and CRM systems, including Baan, PeopleSoft, SAP, Lawson, JD Edwards, and Siebel. As with other Connect solutions, the ERP and CRM Connects are fully integrated into Composer's design-time environment so that you can use intuitive visual tools to create powerful custom integration solutions, eliminating the need to write Java code or edit raw XML or schemas by hand. You can also test the components that you build against live Oracle E-Business Suite connections, using the animation facility (step-through debugger) of the design environment. As part of the design and debug process, your Oracle-aware components can call other Composer Components (such as XML Map Components, JDBC Components, etc.) and make use of any of the core actions that Composer defines (such as Map, Function, Log, and other actions).
The Novell exteNd Composer Connect for Oracle E-Business Suite allows you to build powerful XML-based integration solutions and enables you to reuse your existing Oracle E-Business Suite business functions with other applications—the key to building a successful e-business or integrated enterprise. The Composer Connect enables you to incorporate Oracle E-Business Suite business objects and services into new application initiatives.
You do not need to manually generate or install Oracle E-Business Suite XML schemas in order to use the Composer Connect for Oracle E-Business Suite. The Connect will generate schemas for you, as needed, automatically.
You also don't have to take any steps to preinstall RARs (resource adapter archives, defined by the Java Connector Architecture) on the target application server ahead of time. Composer handles RAR deployment for you automatically when you deploy any Composer-built service that utilizes the Composer Connect for Oracle E-Business Suite.
NOTE: Some one-time setup and configuration steps are required in order to use the Composer Connect for Oracle E-Business Suite. These steps are described in Getting Started With the Composer Connect for Oracle E-Business Suite.
The J2EE Connector Architecture (JCA) defines a standard architecture for connecting elements of the J2EE platform to a heterogeneous Enterprise Information System (EIS). Examples of EIS components include Enterprise Resource Planning (ERP) systems, Customer Relationship Management (CRM), Supply Chain Management (SCM), mainframe transaction processing, database systems, and legacy applications that are not written in the Java programming language. By defining a common set of scalable, secure, transactional mechanisms reachable via a standard set of APIs, J2EE Connector Architecture enables the integration of an EIS with an application server and enterprise applications.
The J2EE Connector Architecture permits an EIS vendor to provide a standard resource adapter for its EIS. The resource adapter plugs into an application server, providing connectivity to an EIS, and integrating it with the rest of the enterprise. If an application server vendor has extended its system to support J2EE Connector Architecture, it is assured of seamless connectivity to multiple Enterprise Information Systems.
Before J2EE Connector Architecture, most EIS vendors offered vendor-specific architectures to provide connectivity between applications and their software. Each program interacting with an EIS needed to be hand-tooled by someone with a detailed knowledge of the target EIS. Custom software to provide connectivity across multiple systems was time consuming to develop, debug, and maintain.
By providing a standard set of APIs and contracts for managing connectivity, exposing EIS APIs, and using application-server services (like transaction control and connection pooling), J2EE Connector Architecture greatly reduces the need for custom programming. Developers can focus on business logic rather than connectivity and transaction-related logic and a variety of "plumbing issues."
The "major participants" in J2EE Connector Architecture include these components:
The application server is not strictly required. Certain services like connection pooling and transaction control will not be available in a "server" that is just a servlet container. But J2EE Connector Architecture resource adapters can still operate.
The RAR represents the interests of the underlying EIS.
The application interacts with the resource adapter using what J2EE Connector Architecture calls standard contracts. Standard contracts define what interactions are to take place and how they are exposed. The contract between the application and the resource adapter is called the Common Client Interface (CCI). The resource adapter, in turn, interacts with the application server under the Service Provider Interface (SPI), which defines how the management of resource adapter interactions occurs. The aspects of this include:
Event listening (listeners can receive notification of significant events; for example, a connection failure)
In the normal course of events, the application uses a naming service to locate the appropriate resource adapter. The application server supplies the naming service, and so it recognizes that a request is being made to locate a resource adapter. In such a case, the application server interposes a resource-adapter-supplied intermediate object that interacts between the resource adapter and the application server. Through this intermediating object, the application server manages the items within the SPI contract below the awareness of the application.
For more information about J2EE Connector Architecture, visit http://java.sun.com/j2ee/connector/.
Novell exteNd Composer uses licensed J2EE Connector Architecture adapter technology from iWay Software* (a division of Information Builders, Inc.) to mediate EIS interactions in the Composer Connect for Oracle E-Business Suite. A leader in the J2EE Connector Architecture technology space, iWay Software provides resource adapters and connectivity solutions across a wide array of EIS and other systems.
For more information about iWay, see http://www.iwaysoftware.com.
With Composer Connect for Oracle E-Business Suite, you can build any kind of Web service or integration application that needs to push data into or pull data from an Oracle E-Business Suite-based data store using XML as the interchange format. Your integration application can be deployed to a J2EE application server and run as a public web service, or it can be used in "behind the firewall" scenarios. It can be triggered by a servlet, JSP, EJB, e-mail, timer, file arrival, JMS message arrival, or any of the supported Composer trigger types. It can also run standalone or as part of a workflow built using Composer Enterprise Edition's Process Manager. (For more information about deployment options, see "Deploying Your Project," in the Novell exteNd Composer User's Guide.)
Copyright © 2004-2005 Novell, Inc. All rights reserved. Copyright © 1997, 1998, 1999, 2000, 2001, 2002, 2003 SilverStream Software, LLC. All rights reserved. more ...