Creating iWay Business Services for Base Tables

How to:

You can generate an iWay Business Service (also known as a web service) for an Oracle E-Business Suite base table. To generate an iWay Business Service, you must deploy the iWay Application Adapter for Oracle E-Business Suite in a business services environment using the iWay Business Services Provider (iBSP). iBSP exposes functionality as web services and serves as a gateway to heterogeneous back-end applications and databases.

A web service is a self-contained, modularized function that can be published and accessed across a network using open standards. It is the implementation of an interface by a component and is an executable entity. For the caller or sender, a web service can be considered a "black box" that may require input and delivers a result. Web services can be integrated within an enterprise as well as across enterprises on any communication technology stack, whether asynchronous or synchronous, in any format.

You can make a web service available to other services within a host server by generating WSDL (Web Services Description Language) from the web service.

Ensure that the servlet iBSP is properly configured. For more information on installing and deploying iWay components, see the iWay Installation and Configuration manual.


Top of page

x
Procedure: How to Create and Test a Web Service for a Base Table

To create a web service for the Oracle E-Business Suite base table HR_LOCATIONS_ALL:

  1. Connect to an Oracle E-Business Suite target, as described in Connecting to Oracle E-Business Suite.
  2. Locate and expand the HR_LOCATIONS_ALL table node, as described in How to Search for Oracle Base Tables and Views.

    Important: Oracle recommends that users do not interact directly with application tables. The use of INSERT, DELETE, or UPDATE to modify data in application tables may jeopardize database referential integrity.

  3. Right-click a function for the base table, for example, INSERT, and select Create iWay Business Service.

    The Create iWay Business Service dialog box opens, as shown in the following image.

  4. Perform the following steps:
    1. From the Existing Service Names drop-down list, select whether you want to create a new service name or use an existing service name.
    2. In the Service Name field, type a descriptive name for the iWay Business Service.
    3. In the Service Description field, type a brief description of the service (optional).
  5. Click Next.

    A second Create iWay Business Service dialog box opens and prompts you for additional information, as shown in the following image.

  6. Perform the following steps:
    1. From the License Name drop-down list, select a license definition.
    2. In the Method Name field, type a descriptive name for the method.
    3. In the Method Description field, type a brief description of the method (optional).
  7. Click OK.

    The iWay Business Services node expands in the left pane. The new iWay Business Service appears under the Services node.

    The following image shows an iWay Business Service called HR_INSERT_WS and, under that service, a method called HR_INSERT_METHOD.

    The right pane displays the name of the expanded iWay Business Service and provides a hyperlink to the selected method, for example, HR_INSERT_METHOD.

  8. Click the HR_INSERT_METHOD hyperlink in the right pane.

    An iWay Business Service test pane opens in your web browser, as shown in the following image.

    1. In the LOCATION_ID field, type the ID of the connection, for example, 390.
    2. In the ENTERED_BY field, type the parameter, for example, 1.
    3. In the DESCRIPTION field, type a descriptive name for the connection, for example, iWay Sample Test.
  9. Click Invoke.

    The web service test result appears in the right pane.

    You have completed the configuration and testing of this service.


iWay Software