Integration Wizard and LDW tables

book

Article ID: 171324

calendar_today

Updated On:

Products

Information Centric Analytics Data Loss Prevention Core Package

Issue/Introduction

When data is being brought into Information Centric Analytics (ICA) through the Integration Wizard, what is the process for bringing data in from the source system into the ICA LDW tables?

Environment

SQL Server

Resolution

When data is being brought into the ICA Database it will move from the base tables in the source system to the ICA Staging area.  Once the data goes into the staging area, it will move to the ICA pre-processing area where formulas are applied, and other lookups are performed. The data is then moved into pre-processing via intra-day processing or through nightly processing depending on the configuration of the integration.  After the data goes into the pre-processing area the data will be moved from the pre-processing area into the LDW area where it will remain at rest.  

Attachments