Installation

Interaction Data Extractor is a CIC Web application and is installed using the installation procedure in the CIC Web Applications Installation and Configuration Guide found at: https://help.genesys.com/cic/mergedprojects/wh_tr/desktop/pdfs/cic_web_applications_icg.pdf

There are additional prerequisites to using the Data Extractor application. Note, it is not necessary to install and configure the prerequisites if Interaction Data Extractor is not being used.

Oracle

In order to run Setup Assistant during installation and to allow the CIC server to communicate with an Oracle database, Oracle requires an additional 32 bit client to be installed on the CIC server. For database version requirements, see http://testlab.genesys.com/ProductsPage.aspx?ProductType=9

To maintain compatibility with all of the features in CIC, we recommend that the Oracle client path be added to the PATH environment variable on the CIC server, and we also recommend you create the ORACLE_HOME environment variable with the proper path. For best results, the version of the Oracle client should match the version of the Oracle Server. It is also a best practice to patch all Oracle clients after the client has been installed on the CIC server.

For information on patching an Oracle 12c client, see https://my.inin.com/products/selfhelp/kb/_layouts/listform.aspx?PageType=4&ListId={30AFF89A-F3A4-4E0C-9F7F-597BDB996AB5}&ID=238&ContentTypeID=0x0100BC7B80188A53F14EA868B7C68AB5686E

SQL Server

SQL Server does not require an additional client to allow a Windows Server based CIC server to communicate with Microsoft SQL Server Database, nor is an additional client required to run Setup Assistant. SQL Server features use ODBC drivers that are built into Windows Server. However, Interaction Data Extractor requires SQL command line utilities for SQL Server to be installed, which are not included by default in Windows Server. SQL command line utilities require an additional install and also require that the path to SQLCMD be added to the PATH environment variable on the CIC servers. SQLCMD must be installed on the CIC server.

To download the 2012 version of SQLCMD, see https://www.microsoft.com/en-us/download/details.aspx?id=36433

To download the 2016 version of SQLCMD, see https://www.microsoft.com/en-us/download/details.aspx?id=52680

For other versions of SQL Server (2008 or 2014) SQLCMD can be acquired by running the SQL Server Database Server Install and only selecting management tools to complete the install.

Note  
When you are installing SQLCMD, you might receive the following error:

If you receive this error, you need to install Microsoft ODBC Driver 11 for SQL Server. For information, see https://www.microsoft.com/en-us/download/details.aspx?id=36434.