Implementing Oracle or SQL EAM Grid Scripts

Owned by Matt Sneller (Deactivated)
Last updated: Sept 12, 2018
2 min read
  • 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

Note

The Programs Files path will vary between 32-bit and 64-bit installations in some circumstances


Oracle-Specific Grid Scripts

  • Select the appropriate Oracle ZIP file based on the Database Platform, EAM Server version, and WOM or Inventory version of the targeted Infor system
  • Work Management 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 Oracle Scripts
  1. Open the Deploy_Oracle_WOM_Windows.bat and/or Deploy_Oracle_Inventory_Windows.bat file in Notepad ++ or another text editor (Notepad.exe is NOT recommended)
  2. Configure the following parameters

    1. sqlplusexe: The path to the SQLPLUS.EXE file on the machine Default is: c:\Oracle\Product\Db10g\BIN\sqlplus.exe

    2. dbusername; an Administrative user on both the machine and database
    3. dbpassword: Password for the Administrative user being used for DB installation
    4. dbhost: Machine name where the database is installed
    5. languagecode: should be EN

  3. Save and run the Deploy_Oracle_WOM_Windows.bat or Deploy_Oracle_Inventory_Windows.bat file

    In some cases, it might be easier/quicker to run a single script in SQLPLUS. To do this, open sqlplus and run @Deploy_Oracle_WOM_PLSQL.sql;
    Make sure sqlplus working directory is pointed to the directory where you extracted the scripts.


 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


Have questions? Email support@bluedotsolutions.com