2 Configuring OracleAS Adapter for SAP

Configuring BSE

After BSE is deployed to Oracle Application Server, you can configure it through the BSE configuration page. This configuration is required only when using a database repository with BSE.

To configure BSE:

1. Display the following page in your browser:

   http://hostname:port/ibse
   
   

   Where hostname is the machine where BSE is installed and port is the HTTP port for Oracle Application Server.

For example,

http://localhost:7777/ibse

2. When prompted, log on.

   When first installed, the user ID and password are:

   • User name: iway

   • Password: iway

The BSE configuration page is displayed.

Description of the illustration bse_config.gif

3. Ensure that the Adapter Lib Directory parameter specifies the path to the lib directory, for example:

   OracleAS_home\adapters\application\lib
   
   

   Where OracleAS_home is the directory where Oracle Application Server is installed.

After you specify the path, adapters in the lib directory are available to BSE.

4. For security purposes, enter a new password in the Admin Password field.

5. Click Save.

Configuring J2CA

During the J2CA deployment of OracleAS Adapter for SAP, OC4J generates a deployment descriptor called oc4j-ra.xml. This descriptor provides OC4J-specific deployment information for resource adapters. See Chapter 3, "OC4J Deployment and Integration" for more information on J2CA deployment and configuration.

No configuration changes are necessary if you are using the default file based repository with J2CA deployment.

Configuring a Database Repository for J2CA

To configure a database repository for J2CA:

1. Execute the iwse.ora SQL statement on the machine where the database is installed.

2. Copy the jcatransport.properties file to the following directory:

   OracleAS_home\adapters\application\config\jca_sample
   
   

3. Uncomment the following fields and enter details for them in the jcatransport.properties file. For example:

   iwafjca.repo.url=jdbc:oracle:thin:@90.0.0.51:1521:orcl
   iwafjca.repo.user=scott
   iwafjca.repo.password=scott1
   
   

4. Alter the JDBC driver path in Application Explorer's lcp. For example:

   lcp=..\lib\orabpel-adapters.jar;C:\jdev\jdbc\lib\classes12.jar;C:\jdev\jdbc\lib\nls_charset12.jar;%lcp%
   to
   lcp=..\lib\orabpel-adapters.jar;..\..\..\jdbc\lib\classes12.jar;..\..\..\jdbc\lib\nls_charset12.jar;%lcp%
   
   

Creating a Configuration for BSE

To create a configuration for BSE using Application Explorer, you must first define a new configuration.

Defining a New Configuration for BSE

To define a new configuration for BSE:

1. Right-click Configurations and select New.

   The New Configuration dialog box is displayed.

2. Enter a name for the new configuration, for example, SampleConfig, and click OK.

   
   Description of the illustration app_exp_new_config_type.gif
   
   

3. From the Service Provider list, select iBSE.

4. In the BSE URL field, accept the default URL or replace it with a different URL with the following format:

   http://hostname:port/ibse/IBSEServlet
   
   

   Where hostname is the machine where your application server resides and port is the port number where the application server is listening.

5. Click OK.

   A node representing the new configuration appears beneath the root Configurations node.

   
   Description of the illustration sampleconfig.gif
   
   

The Web service repository configuration file is stored in OracleAS_home\j2ee\home\applications\ws-app-adapter\ibse.

Creating a Configuration for J2CA

To create a configuration for OracleAS Adapter J2CA using Application Explorer, you must first define a new configuration.

Defining a New Configuration for J2CA

To define a new configuration for J2CA:

Description of the illustration selectnewconfig.gif

1. Right-click Configurations and select New.

2. In the dialog box, enter a name for the new configuration, for example, SampleConfig, and click OK.

   The following dialog box is displayed.

   
   Description of the illustration new_jca_config.gif
   
   

3. From the Service Provider list, select JCA.

4. In the Home field, enter a path to your J2CA configuration directory where the repository, schemas, and other information is stored, for example:

   OracleAS_home\adapters\application
   
   

5. Click OK.

   A node representing the new configuration appears beneath the root Configurations node.

   
   Description of the illustration sampleconfig.gif
   
   

The OracleAS Adapter J2CA configuration file is stored in OracleAS_home\adapters\application\config\configuration_name

Where OracleAS_home is the directory where Oracle Application Server is installed and configuration_name is the name of the configuration you created; for example, SampleConfig.

Connecting to a New Configuration

To connect to a new configuration:

1. Right-click the configuration to which you want to connect, for example, SampleConfig.

2. Select Connect.

   Nodes appear for Adapters, Events, and Business Services (also known as Web services).

Description of the illustration new_config.gif

• Use the Adapters folder to create inbound interaction with SAP. For example, you use the SAP node in the Adapters folder to configure a service that updates SAP.

• Use the Events folder to configure listeners that listen for events in SAP.

• Use the Business Services folder (available for BSE configurations only) to test Web services created in the Adapters folder. You can also control security settings for the Web services by using the security features of the Business Services folder.

You are now ready to define new targets to SAP.

Connecting to SAP

To connect to SAP for the first time, you must define a new target. OracleAS Adapter for SAP supports SAP standard security and the additional protocol of SNC. Once connected to the SAP application server, application security is managed by user ID, roles and profiles. For more information on SAP application security, see the appropriate SAP documentation.

Defining a Target for SAP

To define a target:

1. In the left pane, expand the Adapters node.

   A list of all adapters is displayed.

   
   Description of the illustration adapterexpandedpartial.gif
   
   

   The applications systems supported by Application Explorer appear as nodes based on the adapters that are installed.

   
   Description of the illustration addtarget.gif
   
   

2. Right-click the SAP node and select Add Target.

   The Add Target dialog box is displayed. Provide the following information:

   1. In the Name field, enter a descriptive name, for example, SAPTarget.

   2. In the Description field, enter a description for the target (optional).

   3. From the Target Type list, select the type of target you are connecting to. The supported target types include Message Server or Application Server (default).

      
      

      Note: For load balancing purposes, application servers from one SAP system are usually configured in logon groups, where each group serves a particular kind of user. The application servers in each group are assigned to users by a least-heavily-loaded strategy. This load balancing is done by message servers. Each SAP system has exactly one message server, which can be reached through TCP on a specific message server port.

      
      

3. Click OK.

   The Application Server dialog box appears.

   The following tabs are available:

   • System (Required)

   • User (Required)

   • Advanced

   • Security

4. For the System tab, enter the appropriate information for your SAP target based on the information in the following table.

   Table 2-1 System Tab Parameters

   Target Parameter	Description
   Application Server	The host name or IP address for the computer that is hosting the SAP application.
   System Number	The system number defined to SAP for client communications.
   EDI Version	The Electronic Data Interchange (EDI) document version that you are using with the adapter. Version 3 is the default value.

   
   

5. For the User tab, enter the appropriate information for your SAP target based on the information in the following table.

   Table 2-2 User Tab Parameters

   Target Parameter	Description
   Client	The client number defined for the SAP application for client communications.
   User	A valid user ID for the SAP application.
   Password	A valid password for the SAP application.
   Language	A language key. EN (English) is the default.
   Code page	A character code page value.
   SAP Trace	Select this option to enable traces.

   
   

6. For the Advanced tab (optional), enter the appropriate information for your SAP target based on the information in the following table.

   Table 2-3 Advanced Tab Parameters

   Target Parameter	Description
   Connection pool size	Enter the number of connections you want to make available to SAP.
   Connection pool name	Enter the name of your SAP connection pool.
   BAPI Exception Handling	From the list in the event of a BAPI exception, you can select Creates Error Document or Throws Exception. To receive more detailed error messages, select Creates Error Document.
   Commit with wait	This option is disabled by default.

   
   

7. For the Security tab (optional), enter the appropriate information for your SAP target based on the information in the following table.

   Table 2-4 Security Tab Parameters

   Target Parameter	Description
   Logon ticket (SSO2)	If you are using a Secure Network Communications (SNC) adapter with SAP, enter the name of the SSO2 logon ticket you are using.
   Logon ticket (X.509)	If you are using an SNC adapter with SAP, enter the name of the X.509 logon ticket you are using.
   SNC mode	By default, SNC is disabled. To enable SNC, select 1 from the list.
   SNC partner	Enter the name of the RFC server or message server (load balancing) that provides the SNC services.
   SNC level	From the list select the version of the SNC library.
   SNC name	Enter the name of the SNC library you are using.
   SNC library path	Enter the path to the SNC library.

   
   
   
   

   Note: SNC provides protection for the communication links between the distributed components of an R/3 System. Using SNC, SAP R/3 can support products that adhere to the GSS-API Version 2 standard. SNC supports application level (end-to-end security), Smartcard authentication, and single sign-on.

   
   

8. When you have provided all the required information for your target, click Finish.

   After the extraction finishes, the new target, SAPTarget, appears under the SAP adapter node.

   
   Description of the illustration saptarget.gif
   
   

   See "Creating an XML Schema" for information on how to create schemas for the adapter.

Connecting to a Defined SAP Target

To connect to a target:

1. Expand the Adapters node.

2. Expand the SAP node.

3. Under the SAP node, click the target name, for example, SAPTarget.

   The Connection dialog box displays the values you entered for connection parameters.

4. Verify your connection parameters.

5. Provide the correct password.

6. Right-click the target name and select Connect.

   The x icon disappears, indicating that the node is connected.
   Description of the illustration saptarget2.gif
   
   

Managing a Connection to SAP

To manage SAP connections, you can:

• Disconnect from a connection that is not currently in use.

  Although you can maintain multiple open connections to different transaction processing systems, it is recommended to disconnect from connections not in use.

• Edit a target.

• Delete a connection that is no longer required.

Disconnecting from a Connection to SAP

To disconnect a target:

1. Expand the Service Adapters node.

2. Expand the SAP node.

3. Right-click the target to which you are connected, for example, SAPTarget, and select Disconnect.

   Disconnecting from the SAP target drops the connection with SAP, but the node remains. The x icon appears, indicating that the node is disconnected.

Editing a Target

To edit a target:

1. In the left pane, ensure the target you wish to edit is disconnected.

2. Right-click the target and select Edit.

   The Edit pane is displayed on the right.

3. Modify the target information.

4. Click OK.

Deleting a Connection to SAP

To delete a connection:

1. Expand the Service Adapters node.

2. Expand the SAP node.

3. Right-click the target to which you are connected, for example, SAPTarget, and select Delete.

   The node disappears from the list of available connections.

Creating a Request and a Response Schema

The following procedure explains how to create request and response schemas for an SAP business function. Application Explorer enables you to create XML schemas for this function.

1. Connect to an SAP target as described in "Connecting to a Defined SAP Target".

2. Expand the Business Object Repository node.

3. Click the icon to the left of the Financial Accounting group.

4. Scroll down and click the icon to the left of the Company business object.

5. Scroll down and select the BAPI named BAPI_COMPANY_GETLIST.

   The following screen appears on the right.

   
   Description of the illustration schema1.gif
   
   

6. To view the XML for each schema type, click the appropriate tab.

Generating Web Service Definition Language (WSDL) (J2CA Configurations Only)

The Web Service Definition Language (WSDL) description of a service enables you to make the service available to other services within a host server. You use Application Explorer to create both request-response (outbound) and event notification (inbound) J2CA services of the adapter.

To generate a WSDL file for request-response service:

1. After you create a schema, right-click the respective object.

   The following menu is displayed:

   
   Description of the illustration bpel_40.gif
   
   

2. Select Create Outbound JCA Service (Request/Response).

   The Export WSDL dialog box is displayed.

   
   Description of the illustration bpel_41.gif
   
   

3. Accept the default name and location for the file.

   The .wsdl file extension is added automatically. By default, the names of WSDL files generated for request-response services end with _invoke, while those generated for event notification end with _receive.

   
   

   Note: You can organize your WSDL files in subfolders, creating your own WSDL hierarchy structure. Create the folders under OracleAS_home\adapters\application\wsdls\. The WSIL browser in JDeveloper will display the full tree structure of your WSDL hierarchy.

   
   

4. Click OK.

   The WSDL file is saved in the specified location.

Creating an Event Port

Application Explorer enables you to create event ports from the Adapters node or from the Events node.

Creating a Channel

The following procedure describes how to create a channel for your event. All defined event ports must be associated with a channel.

Creating a Channel

To create a channel:

1. Click the Events node.

   
   Description of the illustration eventexpandedpartial.gif
   
   

2. Expand the SAP node.

   The ports and channels nodes appear in the left pane.

3. Right-click Channels and select Add Channel.

   The Add Channel dialog box is displayed. Provide the following information:

4. 1. Enter a name for the channel, for example, TEST_CHANNEL.

   2. Enter a brief description.

   3. From the Protocol list, select SAP Channel.

   4. Select an event port from the list of available ports.To select more than one, hold down the Ctrl key and click the ports.

   5. To transfer the ports to the list of selected ports, click >>.

5. Click Next.

   The Message Server dialog box is displayed.

   The following tabs are available:

   • System (Required)

   • User (Required)

   • Advanced

6. For the System tab, enter the appropriate information for your SAP channel based on the information in the following table.

   Table 2-5 System Tab Parameters

   Target Parameter	Description
   Gateway host	A host name for the SAP Gateway.
   Gateway service	A service for the SAP Gateway.
   Program ID of the server	An SAP program ID you want to use for this channel.
   Message Server	A host name for the message server.
   R/3 name	An SAP R/3 name.
   Server group	An SAP server group.

   
   

7. For the User tab, enter the appropriate information for your SAP channel based on the information in the following table.

   Table 2-6 User Tab Parameters

   Target Parameter	Description
   Client	The client number defined for the SAP application for client communications.
   User	A valid user ID for the SAP application.
   Password	A valid password for the SAP application.
   Language	A language key. EN (English) is the default.
   Code page	A character code page value.

   
   

8. For the Advanced tab (optional), enter the appropriate information for your SAP channel based on the information in the following table.

   Table 2-7 Advanced Tab Parameters

   Target Parameter	Description
   IDOC Format	Select an IDoc type from the list.
   User Defined Function Modules	Enter the path to the user-defined function module you created.
   SAP trace	Select this check box if you want to enable SAP traces for troubleshooting purposes.
   Unicode	Select this check box if you are expecting your response in Unicode format.
   Synchronous Processing	Select the type of synchronous processing from the list.

   
   

9. Click OK.

   The channel appears under the channels node in the left pane.

   
   Description of the illustration sapchannel4.gif
   
   

   An X over the icon indicates that the channel is currently disconnected. You must start the channel to activate your event configuration.

10. Right-click the channels node and select Start.

    The channel you created becomes active.

    
    Description of the illustration sapchannel5.gif
    
    

    The X that was over the icon in the left pane disappears.

    
    

    Note: If you are planning to integrate OracleAS Adapter for SAP with BPEL Process Manager, do not start the channel, as it is managed by the BPEL PM Server. If you start the channel for testing and debugging purposes, stop it before runtime.

    
    

11. To stop the channel, right-click the connected channels node and select Stop.

Editing a Channel

To edit a channel:

1. In the left pane, locate the channel you want to edit.

2. Right-click the channel and select Edit.

   The Edit channels pane is displayed.

3. Make the required changes to the channel configuration and click Finish.

Deleting a Channel

To delete a channel:

1. In the left pane, locate the channel you want to delete.

2. Right-click the channel and select Delete.

   A confirmation dialog box is displayed.

3. To delete the channel you selected, click OK.

   The channel disappears from the list in the left pane.