After configuring a data source query, creating an integration mapping and associating the data source query to the mapping, it is common to want to execute the integration manually to determine if it yields the appropriate result before the nightly process runs.
CAUTION: These commands assume a basic understanding of SQL. Any changes to the Database pose the potential to affect the operation of the product. ALWAYS ENSURE YOU HAVE A BACKUP OF YOUR DATABASE BEFORE MAKING CHANGES.
In order for Symantec to provide full support of the schema and the DB environment, you have to be running the DB in the version specific to the used version as outlined in the System Requirements Guide. Please see the limitations section at http://www.symantec.com/docs/TECH220433
Figure 1 - This figure depicts how you would run a query through the ICA UI to bring data into the staging area
Figure 2 - The figure above is a sample query that will provide us the import rule mapping id for the organizations mapping. We will note that the ImportRuleMappingID will be used in the next step to begin the process of loading the data into pre-processing.
Figure 3 - Sample output from the IW_PreProcessTable