Configuring the SQL 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 SQL JDBC Data Provider

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

Note: As a best practice, use an installed SQL Server or the WebSphere embedded ConnectJDBC driver supplied with WebSphere.
  1. If you have not already supplied the provider definition, start WebSphere and go to Resources > JDBC > JDBC Providers in the Integrated Solutions Console.
  2. Select a scope from the drop down box.
    Note: Ensure that the server you plan use is included in the selected scope.
  3. Click New.
  4. Specify these values for the new JDBC provider:
    Database type

    SQL Server

    Provider type

    WebSphere embedded ConnectJDBC driver for MS SQL Server

    Implementation type

    Connection pool data source

    Name

    A name for the driver (for example, MSSQL Data Provider).

    Click Next.

  5. In the Directory location field, enter the location to the JDBC driver jar file. Click Next.
  6. Review the summary and click Finish.
  7. Click Save to save the configuration changes.