Implementing Oracle or SQL EAM Grid Scripts

• Identify the server Platform (SQL or Oracle) and EAM Server version of the installation (i.e. 8.3, 8.4, 8.5, 10.1, 10.1.2, 11)
• Determine if you are installing the Work Order Management (WOM) module or Inventory module or both
• Copy the zip file to the EAM database server and extract

Step-by-step guide

Default ZIP File Locations

• Work Order Management: C:\Program Files (x86)\Blue Dot\Advanced Mobile for Infor EAM Server\Instances\{SPECIFIED INSTANCE NAME}\EamWorkDatabase
• Inventory: C:\Program Files (x86)\Blue Dot\Advanced Mobile for Infor EAM Server\Instances\{SPECIFIED INSTANCE NAME}\EamInventoryDatabase
  
  

Oracle-Specific Grid Scripts

1. Select the appropriate Oracle ZIP file based on the Database Platform, EAM Server version, and WOM or Inventory version of the targeted Infor system
2. Either open the desired ZIP file(s) or submit it to the appropriate DBA
3. Extract the contents ZIP file to the target Infor EAM Database Server
4. Open the extracted folder
5. Open sqlplus
   1. Make sure sqlplus working directory is pointed to the directory where you extracted the scripts.
6. Run @Deploy_Oracle_WOM_PLSQL.sql;
    

    

 SQL Specific Grid Scripts

• Select the appropriate SQL ZIP file based on the Database Platform, EAM Server version, and WOM or Inventory version of the targeted Infor system
• Inventory Grid Script ZIP Files
• Either open the desired ZIP file(s) or submit it to the appropriate DBA
• Extract the contents ZIP file to the target Infor EAM Database Server
• Open the extracted folder

Configure SQL Scripts

1. Open the Deploy_SQL_WOM_Windows.bat or Deploy_SQL_Inventory_Windows.bat file in Notepad ++ or another text editor (Notepad.exe is NOT recommended)
2. Configure the following parameters
   1. sqlcmdexe: The path to the SQLCMDEXE.EXE file on the machine Default is: C:\Program Files\Microsoft SQL Server\90\Tools\Binn\SQLCMD.EXE
   2. dbname: Administrative user on both the machine and database
   3. server: SQL server name
   4. languagecode: should be EN
3. Save and run the Deploy_SQL_WOM_Windows.bat or Deploy_SQL_Inventory_Windows.bat file