Configuring the Expense Management ION integration server

To configure the Expense Management ION Integration Server:

  1. On the Expense Management ION integration server, configure the Expense Management ION database connection information in the ionconfig.xml file in:
    XM_Install_Root\apache-tomcat-6.0.29-intserver\webapps\XMFortressServer\WEB-INF\

    This is a sample configuration in ionconfig.xml.template file. You should rename or copy this to the ionconfig.xml file: 

    <?xml version="1.0" encoding="utf-8" standalone="yes"?>
<ION-Config>
      <!-- Note: The ExtnDBConnection element was renamed to SOAExchangeDB in Infor Expense Management 8.1.4. Rename it if your Infor Expense Management installation is 8.1.4 or later.-->
<ExtnDBConnection>
		<Url> jdbc:jtds:sqlserver://<db server>:<port>;DatabaseName=XM_ION_EXTN</Url>
		<Driver>net.sourceforge.jtds.jdbc.Driver</Driver>
		<User><db user></User>
		<Password><db password></Password>
	</ExtnDBConnection>
	<ConnectionPoints>
		<ConnectionPoint>
			<LogicalId><logical id></LogicalId>
			<Tenant><tenant id></Tenant>
		<Url>jdbc:jtds:sqlserver://<db server>:<port>;DatabaseName=XM_ION_T1</Url>
			<Driver>net.sourceforge.jtds.jdbc.Driver</Driver>
			<User><db user></User>
			<Password><db password></Password>
		</ConnectionPoint>
		<ConnectionPoint>
			<LogicalId><logical id></LogicalId>
			<Tenant><tenant id></Tenant>
		<Url>jdbc:jtds:sqlserver:// <db server>:<port>;DatabaseName=XM_ION_T2</Url>
			<Driver>net.sourceforge.jtds.jdbc.Driver</Driver>
			<User><db user></User>
			<Password><db password></Password>
		</ConnectionPoint>
	</ConnectionPoints>
</ION-Config>

    This screen shows a sample configuration of the logical id=infor.erp.xm:



  2. Set the JAVA_HOME variable in the startintegrationserver.bat file in:
    XM_ION_Integration_Server_Install_Root\apache-tomcat-6.0.29-intserver\webapps\XMFortressServer\bin
    Note: If you are using a Linux platform, set this variable in the startintegrationserver.sh file.
  3. On the Expense Management ION integration server, configure the Expense Management ION logging information in the logbods.properties file in:
    XM_Install_Root\apache-tomcat-6.0.29-intserver\webapps\XMFortressServer\WEB-INF\

    This is a sample configuration in the logbods.properties.template file. You should rename or copy this to the logbods.properties file:

    #For test purpose, the bods can be exported to the specified path

    logBodEnabled=true

    #The path to export BODs, please use '\\' as the seperator in the path

    logBodPath=<<XM_HOME>>\\apache-tomcat-6.0.29-intserver\\logs\\

    #Specify whether format BOD xml by pretty print.

    logBODPrettyPrint=true