Database Configuration
-
Open a command prompt and execute the install_cis.bat script.
- For Oracle, the batch script is located in: C:\Program Files (x86)\Miner and Miner\Responder\Integration\CisSyncApplication\IntegrationScripts\Oracle
- For SQL, the batch script is located in: C:\Program Files (x86)\Miner and Miner\Responder\Integration\CisSyncApplication\IntegrationScripts\MS-SQL
This script requires the following files, which are in the same folder:
-
CISConfiguration.sql
-
CreateTables.sql
-
Provide the Responder username, password, and database instance when prompted to do so, e.g.:
- User name: responder (or any preconfigured user with DB admin rights)
- Password@Instance: password@tnsname
-
The batch script runs the SQL scripts to create the database structures listed below for the CisSync Application integration.
-
Adds the RXINT_CUSTOMERS_STAGE table.
-
Adds the Edit Customer Information role. This role has the Edit Customer Data task and is allowed to insert, update, and delete items from the RX_CUSTOMERS table.
-