Skip to main content

Communication with J1, EX, and QX

When JICS communicates with J1, EX, or QX, it does so using a series of C# plug-ins and a direct connection to the ERP system’s database. The information that JICS needs to make this connection is stored in the FWK_ConfigSettings table. These values were probably set by the installation team when JICS was installed, but they can be changed later.

Although the relevant records are all labeled with the prefix EX, these same records are used by J1 and QX. The value you choose for each parameter is stored in the Value column for the records that have the following Key fields:

  • EXDBType – The type of database software used by the ERP database. At the time of this writing, the only valid value is MSS, for Microsoft SQL Server.

  • EXDBServerName – The name of server that hosts the ERP database.

  • EXDBName – The name of the ERP database.

  • EXDBUserName – The user name that JICS will use to connect to the ERP database.

  • EXDBPassword – The password that goes with the EXDBUserName value.

Note that for certain types of interactions between JICS and the ERP database, the system may use COM-based plug-ins instead of web services. This document does not cover that process.