SCADA Database Configuration

Open a command prompt and the execute install_Scada.bat script.

• For Oracle, the batch script is located in:

  C:\Program Files (x86)\Miner and Miner\Responder\Integration\Scada Service\IntegrationScripts\Oracle

• For MS-SQL, the batch script is located in:

  C:\Program Files (x86)\Miner and Miner\Responder\Integration\Scada Service\IntegrationScripts\MS-SQL.

This script requires the following files, which should be in the same folder:

• 01_RxScadaCustomTables.sql

Provide the Responder Username, password, and database instance when prompted to do so. For example:

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 necessary database structures for the SCADA integration as listed below.

• Adds the following tables:

  • RXINT_SCADA_EVENT

  • RXINT_SCADA_EVENT_PROCESS

  • RXINT_PROCESS_LOGS

  • RXINT_SCADA_EVENT_HISTORY

  • RXINT_SCADA_EVENT_PROCESS_HIST