IVR Database Configuration
-
Open a command prompt and execute the install_IVR.bat script.
For Oracle, the batch script is located in:
C:\Program Files (x86)\Miner and Miner\Responder\Integration\Ivr Outbound Service\IntegrationScripts\Oracle
For SQL, the batch script is located in:
C:\Program Files (x86)\Miner and Miner\Responder\ Integration\Ivr Outbound Service\IntegrationScripts\MS-SQL
This script requires the following files:
-
IVR_add_fields.sql
-
IVR_create_table.sql
-
-
Provide the Responder Username, password, and database instance when prompted to do so. For example:
Username: responder (or any preconfigured user with DB admin rights)
Password@Instance: password@tnsname
-
The batch script runs the SQL scripts to create the necessary database structures for the IVR integration as listed below.
-
Adds the RXINT_POST_RESTORE_CALLS table.
-
Assigns the RXINT_POST_RESTORE_CALLS permission to the Customer Service Data Access task.
-
Adds the RXINT_GENERATE_CALLBACKS field to RX_INCIDENTS table.
-
Adds the RXINT_CALL_RECORD_ID to the RX_CALLS and RX_CALLS_HISTORY tables.
-