Repository Database Requirements


Component	Supported Version/Notes
Microsoft® SQL Server	See the Compatibility Matrix in Infor Customer Portal for supported versions. Create a database repository for each Lawson application component that is installed. For example: LawsonFS for Framework Services LawsonRS for Reporting Services LawsonSN for Smart Notification Create a valid user ID which uses SQL Server authentication (not Windows authentication). This user ID is the database owner for each of these new databases. As a best practice, create a user ID of "lbiadmin". This user must be tagged with the Owner role for each database through User Mappings interface. Note: Databases must be created as case-insensitive to ensure that sorting and searches are done properly by the Infor BI for Lawson applications. The MS SQL client tool must be installed on the Infor BI for Lawson server. Note: SQL server must be configured to use the mixed authentication of SQL server and Windows authentication mode. For information on how to do this, see the MS SQL Server documentation. Note: Infor BI for Lawson applications require a CI_AS setting in SQL Server.
Oracle	See the Compatibility Matrix in Infor Customer Portal for supported versions. Oracle user must have these attributes: CONNECT role CREATE VIEW privilege RESOURCE role Note: The Reporting Services user does not require the Resource role; Framework Services and Smart Notification users do require this role. Access to the tablespace defined for the user Note: As a best practice, create databases as case-insensitive to ensure that sorting and searches are done properly by the Infor BI for Lawson applications.