Required database components and settings

Relational database versions

Supported versions for your relational database are documented in the installation guide for your Infor Lawson System Foundation product and platform.

Operating system for the database server

Refer to the Infor Software - Compatibility Matrix for Lawson Web browser Products document available on Infor Concierge for supported operating system versions.

Operating system for the database client

The database interface layer utilizes third-party database client software to access data from the relational database server. The database client and server may run on different operating systems, utilizing connection software provided by the third-party database vendor. Lawson supports any configuration that the third-party relational database vendor certifies and supports between their database client and server. However, to be supported, the client software must be running on an operating system version that supports Lawson software products.

Microsoft SQL Server required database products

When installing Microsoft SQL Server products, you are given a list of products and features to choose from. While the Lawson runtime system does not require you to install all the offered products, these products are required for installation, setup, runtime or performance analysis of the Lawson database:

  • Microsoft OLE DB Driver for SQL Server Interface used by the Lawson database driver for Microsoft SQL Server

  • Microsoft Command Line Utilities for SQL Server

    This utility dynamically executes SQL requests between local and remote databases and can create the database and table spaces.

Data at Rest Encryption Support

Lawson supports data at rest encryption for a variety of database and platform versions. For details, see the installation guide and release notes for your Infor Lawson System Foundation product and platform.

See Encryption of Data at Rest.

Required Database Settings

  • Microsoft SQL Sort Order setting of Binary Order, case-sensitive.

    To verify that the database Sort Order is set to Binary order, case-sensitive, use the Microsoft SQL command sp_helpsort.

  • Lawson does not support the UTF-8 character set.