IBM BPM, V8.0.1, All platforms > Authoring services in Integration Designer > Services and service-related functions > Access external services with adapters > Configure and using adapters > IBM WebSphere Adapters > SAP Software > Configure the module for deployment > Performing prerequisite tasks specific to an interface

Create the data source

To create a data source, which is used for event tracking and recovery during ALE inbound processing, you use the Process Administrative Console.

You select a JDBC provider and then create a data source in the JDBC provider. After configuring the data source, you use the Test Connection button in the Process Administrative Console to test the database connection.

Before configuring the data source, make sure the database is already created and then configure the data source using that database.

You need a JDBC provider only if you are going to set up an event recovery table to persist inbound events (to ensure once-only delivery).


Procedure

  1. In the Process Administrative Console, select a JDBC provider.

    1. Click Resources > JDBC > JDBC Providers.

    2. Select a JDBC provider.

  2. Select Data sources.

  3. Create a new data source by clicking New.
  4. Type values for the required fields.

    1. In the Data source name field, type the name of the event table.

      A default value is provided.

      For example, for the Derby JDBC Provider, the default value is Derby JDBC Driver DataSource. You can change the default value.

      An example of a data source name is: EventRecoveryDS

    2. In the JNDI Name field, type the JNDI name of the data source.

      An example is jdbc/EventRecovery.

  5. Optionally, select an authentication alias for the JDBC provider from the Component-managed authentication alias and XA recovery authentication alias list.

  6. Click Next.

  7. In the Create a data source window, indicate the database to which the data source connects by typing a value in the Database name field.
  8. Review the information in the Summary table to ensure its accuracy, and then click Finish.
  9. Save your configurations.

  10. From the list of data sources, select the check box next to the data source created in the previous steps.

  11. Click Test connection.

    You will see a message that the test was successful.

    If the test is not successful, make sure the database drivers are available in lib\ext directory. Also make sure that the database name and port are correct.


Results

A new data source is created.


What to do next

Configure the adapter for ALE inbound processing. Use the database JNDI created in this topic, and use the Auto create event table property to create the event recovery table.

Performing prerequisite tasks specific to an interface


Related concepts:

Event recovery


Related reference:

Activation specification properties for ALE inbound processing