Business Intelligence (BI) Interface Guide › Business Intelligence Interface › SQL Interfaces › Raw Data and Intermediate Data Interfaces

Raw Data and Intermediate Data Interfaces

The Raw Data and Intermediate Data interfaces supply access to the input events for calculations:

1. The Raw Data Interface exposes the events received from Adapters and:
   1. Can handle deletion of records
   2. When the Raw Data decoding process encounters events that have a corrupted value in the encoded data field, it skips the problematic record, writes an entry in the process log and continues.
   3. Raw Data decoding process also handles updates of existing events and applies them to the T_RAW_DATA_FIELDS table. This insures that no discrepancies occur as a result of correction to the T_RAW_DATA table.
2. The Intermediate Data Interface exposes events generated by calculations and:
   1. Handles deletion of records.
   2. When the Intermediate Data decoding process encounters events that have a corrupted value in the encoded data field, it skips the problematic record, writes an entry in the process log and continues.

Both the Raw Data and Intermediate Data decoding processes are able to clean up log entries from the T_RAW_DATA_FIELDS_LOG table.

In addition, both processes cleanup their respective log entries (i.e. the Raw Data decoding process cleans up raw data decoding log entries; the Intermediate Data decoding process cleans up intermediate data decoding log entries).

Log entries are considered candidates for cleanup according to:

• Number of days since they were written
• Severity (Debug, Info, Error)
• Configuration parameters. The parameters (see below) are located in the T_RAW_DATA_FIELDS_CONFIG table:
  • Debug – How long (in days) to keep entries of severity Debug. Default value: 30
  • Info – How long (in days) to keep entries of severity Info. Default value: 90
  • Error – How long (in days) to keep entries of severity Error. Default value: 365

Event data is supported in HTML format.