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 > Oracle E-Business Suite > Configure the module for deployment

Adding external software dependencies

The external service wizard needs a copy of certain files from the Oracle E-Business Suite to be able to communicate with it. Specify the location of the JAR files that contain the JDBC driver for Oracle and any native system library files that are needed.

Run the external service wizard in IBM Integration Designer to perform this task.

In addition to performing this task when you configure the module, you also need to deploy files on IBM BPM or WebSphere Enterprise Service Bus.


Procedure

  1. Obtain the Oracle JDBC driver-specific files or native libraries for your database software and operating system from your database administrator or from the database software website. The following table lists the Oracle JDBC driver files needed for the Oracle database software.

    Oracle JDBC driver files for Oracle database software
    Database software Driver JDBC driver files Native System Libraries
    Oracle Thin driver ojdbc6.jar or ojdbc14.jar depending on the JRE version None

    The Java™ Runtime Environment (JRE) version required by the Oracle JDBC driver must not be higher than the JRE version in the runtime environment.

    For example, if the JRE version is 1.5 in the runtime environment, then the Oracle JDBC Driver must be "ojdbc14.jar" which supports both Java Development Kit (JDK) 1.4 and JDK 1.5; if the JRE version is 1.6 in the runtime environment, then the Oracle JDBC Driver must be "ojdbc6.jar" which supports JDK version 1.6.

  2. Obtain the Oracle JMS driver-specific files or native libraries for your database software and operating system from your database administrator or from the database software website. The following table lists the Oracle JMS files needed for Oracle database software.

    Oracle JMS driver files for Oracle database software
    Database software Driver JMS driver files Native System Libraries
    Oracle JDBC Thin ojdbc6.jar or ojdbc14.jar depending on the JRE version None
    Oracle JMS apaqi*.jar None
    Oracle JMS jmscommon*.jar None

    The jdbc driver and jms driver should be compatible with Java Runtime Environment (JRE) version and Oracle Database version.

  3. In the Locate the Required Files and Libraries window, specify the location of the Oracle JDBC driver-specific files that are required by the adapter.

    1. In Oracle JDBC driver JAR files, click Add and select the Oracle JDBC driver files or Oracle JMS driver files.

    2. If you use the Oracle JDBC type 2 driver, click Add in System libraries to add the native system libraries that are required to access the database server. If you use Oracle JDBC type 4 driver, leave this field empty.

  4. Click Next. The wizard displays the Select the Processing Direction window.


Results

The wizard has the files it requires to communicate with the database server.


What to do next

Continue working in the external service wizard. The next step is to provide the information that the wizard needs to communicate with the Oracle database.

Configure the module for deployment


Previous topic: Create the project


Next topic: Setting connection properties for the external service wizard


Related tasks:

Adding external software dependencies on the server