Setting up the background process

XMDBTool uses the background process XMDBToolBkg. This background process includes all the basic XMDBTool functionality. You must define the various instances of this background process in the alco_background_process table, with the appropriate parameters. You can then run the background processes using Infor Expense Management System Administration Tool or schedule the processes to run at specified intervals using Infor Expense Management System Administration Tool.

You can link the background processes together. The linked background processes are queued and automatically runs after a current background process is complete. You can use the runbkg background parameter to specify the background process names. For example, if you specify the runbkg=HRBKG in the background process parameter of the XMDBToolBkg.Import, the HRBkg background process starts automatically after the XMDBToolBkg.import background process is complete. The background process linking feature currently supports the XMDBToolBkg.import, XMDBToolBkg.export, and the XMDBToolBkg.CC processes.
Note: The background process linking functionality is applicable from 10.2.6 release.

These background process instances are pre-configured. You may have to run the load tool to populate the alco_background_process table.

  • XMDBToolBkg.import This parameter is used for uploading files to the database. This is similar to upload_data.bat/sh in the XMDBTool client. All the parameters used for upload_data.bat can be specified to this background process using the bkg parameter in Infor Expense Management System Administration Tool.
  • XMDBToolBkg.export This parameter is used to download the files from the database. It is similar to the download_data.bat/sh in the XMDBTool client. The parameters used for the download_data.bat can be specified in this background process using the bkg parameter in Infor Expense Management System Administration Tool.
  • XMDBToolBkg.exportER This parameter is used to download the ER module from the database. It is similar to the download_data.bat/sh that is run with the downloadModule = ER in the XMDBTool client. The parameters used for the download_data.bat can be specified in this background process, using the bkg parameter in SAT.
  • XMDBToolBkg.exportTP This parameter is used to download TP module from the database. It is similar to download_data.bat/sh running with the downloadModule = TP in the XMDBTool client. All the parameters used for download_data.bat can be specified to this background process using the bkg parameter in Infor Expense Management System Administration Tool.
  • XMDBToolBkg.exportTS This parameter is responsible for downloading TS module from the database and is similar to download_data.bat/sh running with the downloadModule = TS in the XMDBTool client. All the parameters used download_data.bat can be specified to this background process using the bkg parameter in Infor Expense Management System Administration Tool.
  • XMDBToolBkg.exportPR This parameter is responsible for downloading PR module from the database and is similar to download_data.bat/sh running with the downloadModule = PR in the XMDBTool client. All the parameters used for download_data.bat can be specified to this background process using the bkg parameter in SAT.
  • XMDBToolBkg.CC This takes care of uploading cc files and is similar to upload_cc_feed.bat/sh. in the XMDBTool client. All the parameters used for upload_cc_feed.bat can be specified to this background process using the bkg parameter in Infor Expense Management System Administration Tool.
  • XMDBToolBkg.ETL This takes care of running the etl for generating sql scripts and is similar to run_etl.bat/sh in the XMDBTool client. All the parameters used for run_etl.bat can be specified to this background process using the bkg parameter in Infor Expense Management System Administration Tool.
  • XMDBToolBkg.Archive XMDBToolBKG.Archive BKG enables the users to pass date range to the archive tool. The required parameters must be specified in the bkg parameters.
  • XMDBToolBKG.ArchiveINC XMDBToolBKG.ArchiveINC enables the user to run the archiving process in the incremental mode. In case of XMDBToolBkg.ArchiveINC, the startDate is picked up from the internal db (it is the end date of the previous run) and the end date is current date (it is the date on which this bkg is run).
  • XMDBToolBkg.ETL_UnlockRDB XMDBToolBkg.ETL_UnlockRDB is used to support the unlocking of the reporting DB. By default , the bkg parameters are c=RUN_ETL,manual_lock_rdb=N.