WebSphere Adapter for SAP Software

Configuring the data source

To configure the JDBC data source for ALE inbound processing, you use the administrative console. The data source, which is required for inbound processing, is used for event tracking and recovery. This tutorial uses the Cloudscape™ JDBC provider.

  1. Begin the process of creating a data source by displaying the administrative console.
    1. From the J2EE Perspective of WebSphere® Integration Developer, click the Server tab.
    2. If WebSphere Process Server v6.0 does not show a status of Started, right-click WebSphere Process Server v6.0 and click Start.
    3. Right-click WebSphere Process Server v6.0 and click Run administrative console.
      Figure 1. Selecting Run administrative console for the WebSphere Process Server
      A screen capture of the action of right-clicking the WebSphere Process Server (in the Servers tab) and selecting Run administrative console.
    4. Log in to the administrative console by typing admin and clicking Log in.
  2. Select a JDBC provider.
    1. Click Resources > JDBC Providers.
    2. Click Cloudscape JDBC Provider.
  3. Select Data sources.
    Figure 2. The Cloudscape JDBC provider Configuration tab
    A screen capture of the JDBC providers section of the administrative console, showing the Cloudscape JDBC Provider configuration tab.
  4. Create a new data source by clicking New.
  5. Type the following values in the specified field. Leave the default values for the rest of the configurations.
    Option Description
    Name ALEEventRecoveryDS
    JNDI Name jdbc/ALEEventRecovery
    Description ALEEventRecoveryDS
    DatabaseName ALEEventRecoveryDB
  6. Click Apply.

    After the changes are applied, Custom properties becomes active.

  7. Click Custom properties.
  8. Scroll down and click createDatabase.
    Figure 3. Selecting the createDatabase entry
    A screen capture of the JDBC providers section of the administrative console, showing the createDatabase selection.
  9. Type create in the value field, and click Apply.
  10. Save your configurations.

Result

The new data source, ALEEventRecoveryDS, is displayed in the list of data sources.

Terms of use |

Last updated: Mon 30 Oct 2006 03:34:56

(c) Copyright IBM Corporation 2005, 2006.
This information center is powered by Eclipse technology (http://www.eclipse.org)