Microsoft SQL Server

Microsoft SQL Server users can perform heterogeneous queries and process information from any OLE DB data source, including OLE DB Object Services. This means that you can formulate queries against both Lawson and non-Lawson data sources and create a result that bridges the two. There are many things you can do with this combination, including answering "what if" questions through SQL queries. You can also view data in different ways such as combining data across product lines.

The connector has been tested as both a direct and indirect source of data where SQL Server is specified as the data source when a query is formulated. This means you can query the SQL Server database directly or go through the Lawson ERP application (indirect method).

SQL Server knowledge is required to perform these queries. Infor does not provide information about how to use the SQL Server query language.

Following is an example query of a SQL Server query that extracts information from the Lawson ERP application EMPLOYEE table and displays it in the SQL Server Query Analyzer output window.

At the SQL Server Query Analyzer prompt, type a statement similar to the following:

select * from OPENROWSET('Lawson.LawOLEDBC','XXX';'XXX';'XXX','dme:FILE=EMPLOYEE&FIELD=EMPLOYEE;LAST-NAME;FIRST-\NAME;EMP-STATUS;EMP-STATUS.DESCRIPTION;EMP-STATUS.PAY-STATUS')

You can add a SQL WHERE clause and ORDER BY clause to the above statement to do additional filtering and sorting of the Lawson ERP application information.