Configuring a Lawson data source's FTP connection

Note: Use this procedure if you selected Lawson data connection as the connection type. This procedure sets up the transfer of the Lawson Application data from the Lawson Applications server to the Infor BI for Lawson server.
  1. Open the Tools dashboard and select Report Administration. The Reporting Services Administration screen is displayed.
  2. Select Server Administration > Maintain Data Sources. A list of data sources is displayed.
  3. Select the Edit FTP Settings link of the data source to configure the selected server.
  4. Specify this information:
    Description
    Optionally, specify a description for the Lawson application server.
    Lawson Technology Release Level
    Select the appropriate Environment (8.0.3), Lawson Foundation Technology (8.1), or Lawson Core Technology (9.0) release levels.
  5. Specify this FTP Connection Properties information:
    Lawson Application Server
    Specify the name or IP address of the Lawson Application Server, For example, app_server or 10.27.29.89.
    Connection User
    Specify the connection user name for the FTP connection. The user that you specify must have access to the FTP connection.
    Password
    Specify the password for the FTP connection user.
    Timeout Period
    Specify a timeout period for the FTP connection. The allowable range is 10-99 seconds; the default is 10 seconds.
    Port
    Specify the port for the FTP connection. Allowable port numbers range from 1-9999, but ensure to select a port that is not being used by another component. The default FTP port is 21, and the default port for secure FTP (SFTP) is 22.
    Connection Mode
    Select the connection mode. Values include Active and Passive.
    An active mode, with its more stringent validation, may be necessary if you are passing through a firewall. A passive mode will provide less restriction.
    Operating System
    Select the operating system. Values include Auto Detect, Unix, and Windows.
    This configuration is used to determine the proper carriage return end marker for reports.
    Enable Secure FTP
    Select True to enable a secure FTP connection. Select False to disable this option. SFTP allows you to secure sessions while transferring BackOffice files over FTP.
    Note: SFTP must be enabled in the LSF or BackOffice server.
    Product Line
    Optionally, if you are using a project for the data area, specify the product line, the project's parent, value. If you are not using a project, leave blank.
    Data Area
    Specify the date area for the FTP connection. This field specifies the data area to which you want to connect. The data area can be a project line or a project.
    Application Home Path
    Specify the application home path such as $LAWDIR for Unix or $LAWDIR% for Windows. This location is where the Lawson Application resides, and all other paths, such as system and print directories, will be relative to this location.
    For Lawson Core Technology 9.0, this information will be either LAWDIR/PRODUCTLINE/map/LOCALE or LAWDIR/print/LOGIN.
    For Lawson Foundation Technology 8.1, this is WEBDIRlawson/xtra/properties.
    Report Information Path
    Specify the report information path, for example, $WEBDIRlawson/xtra/properties for Unix or %WEBDIR%\lawson\xtra\properties for Windows, where WEBDIR is the document root directory defined in your web server.

    This location contains reporting property files and meta-information for reporting.

  6. Specify the Deployment Properties for the Lawson application server information:
    Server Deployment Status
    Select the server deployment status. Values include Disabled and Enabled.
    If you are working with Lawson Application reports, you must set this field to Enabled. When enabled, the system checks the server frequency and publishes Lawson Application reports.
    Check Server Frequency
    Specify a check server frequency value. The frequency range is 1-99 minutes; the default is 5 minutes. This value specified how often Reporting Services will poll the Application server for new reports that have been run.
    Note: If a report has been run multiple times, Reporting Services will only catch the most recent run of the report. To deploy the version of a report that will be run multiple times, you must ensure the desired version has been deployed by Reporting Services before rerunning the report.
  7. Specify the XML report information:
    XML Reports Generated upon Report Acquisition
    Select to have Reporting Services generate the XML documents it needs to create the .pdf files and perform bursting and filtering for Lawson Applications reports.
    Note: Select if the XML Reports option for Lawson Applications server is off. When the XML Reports option is off, Lawson Applications does not create XML documents when a Lawson batch job is submitted and run.
  8. Click Save.
  9. Click Deploy Reports to deploy reports immediately.