Oracle ODBC driver/Oracle client

The CIC server and client workstations running Interaction Reporter and/or Interaction Report Assistant in IC Business Manager use the Oracle ODBC driver in their communications with the database server.

It is essential that the 32-bit version of the Oracle ODBC driver is installed on the CIC server, even though the CIC server is running the 64-bit version of Microsoft Windows. CIC programs are 32-bit, and require the 32-bit Oracle ODBC drivers to function properly.

Install the Oracle client and the Oracle ODBC driver (32-bit) on:

• The CIC server

• Client workstations that will run Interaction Reporter and/or Interaction Report Assistant in IC Business Manager

Note: Interaction Optimizer requires Oracle 12.2 client to be installed as the default Oracle client. If the default Oracle client is not version 12.2, then you must set the ORACLE_HOME environment variable to specify the Oracle client install location.

Oracle instance alias name

In order for reports to run correctly, the Oracle instance alias name (specified in TNSNames.ora) must be consistent between the CIC server and client workstations that will run Interaction Reporter and/or Interaction Report Assistant in IC Business Manager. When configuring the Oracle client on client workstations, use the same alias name specified in the CIC server’s tsnames.ora file.