Where the IOBOX Database Connection Definition is Stored for ION Integration with Infor CRM

Somewhere along the magical trail of breadcrumbs that leads you into the world of an integrated ION Infor CRM system, you define the location of the IOBOX database. This is the intermediate database that ION actually reads and writes to. This configuration is done initially using the set-up tools. If you have to change this later there is no help on where the connection is stored or how to modify it.

Digging through the ION job assemblies I have found the location where the connection details are stored in order for the Infor CRM jobs to know where the IOBOX location is. It is stored in the registry of the server in the key of:

HKEY_LOCAL_MACHINE\SOFTWARE\InforCRM\Tenants\” + {your tenant name} + \IONIntegration\IOBOXConnection

In that key is a SQL connection string. If you need to change it you can do so here.