Configuring the Oracle JDBC Driver for WebSphere

Use the procedures in this section to configure WebSphere for Infor BI for Lawson.

Set up these items for your installation:

  • One Oracle JDBC Data Provider

  • A data source for each product you plan to install (Framework Services, Reporting Services, and Smart Notification)

  1. If you have not already supplied the provider definition, start WebSphere and navigate to Resources > JDBC > JDBC Providers.
  2. Select a scope from the drop down box.
    Note: Ensure that the server you plan to use is included in the selected scope.
  3. Click New.
  4. Specify these values for the new JDBC provider:
    Database type

    Oracle

    Provider type

    Oracle JDBC Driver

    Implementation type

    Connection pool data source

    Name

    A name for the driver (e.g., Oracle Data Provider).

    Click Next.

  5. In the directory location field, specify the Oracle JDBC driver jar file.

    Obtain a copy of this .jar file from Oracle and specify its location in the WebSphere Oracle Provider configuration:

    • For Oracle 19c: ojdbc8.jar

    Click Next.

  6. Click Finish.
  7. Click Save to save the configuration changes.