To connect with a JDBC data source

  1. In the Outline panel, right-click on the Data Sources sub-node and select New Data Source.
  2. Select JDBC Data Source from the data source type list.
  3. Update the Data Source Name field and click Next.
  4. In the New JDBC Data Source Profile window, fill out the following fields, and then click Finish.
    JDBC data source profile Example
    Driver Class net.sourceforge.jtds.jdbc.Driver(v1.2)
    Database URL jdbc:jtds:sqlserver://phtefstage66237.lpc.lawson.com/STAGE_DB;instance=TEF
    User Name STAGETest
    Password Password123
  5. To be able to preview the template in LSR Designer, add the <jdbc driverclass>.jar file manually in the LSR plugins directory.

    Example

    C:\Program files\Lawson\LSRDesigner\plugins\