Source Extractors - SQL - Information - How to filter some extracted DB objects out of the analysis

Purpose
 This page explains how to filter some extracted DB objects out of the analysis
Applicable in CAST Version
Release
Yes/No
8.3.x (tick) 
8.2.x (tick) 
8.1.x (tick) 
8.0.x (tick) 
7.3.x(tick)
7.2.x(tick)
7.0.x(tick)
Applicable RDBMS
RDBMS
Yes/No
Oracle Server(tick)
Microsoft SQL Server(tick)
CSS2(tick)
CSS1(tick)

This page applies to the following offline extractors:

  • PL/SQL (Oracle)
  • T-SQL (Microsoft and Sybase)
  • Forms
  • PeopleSoft (In 7.3.x only for  x>0)
  • Siebel  (In 7.3.x only for  x>0)

Special case

This solution does not work for Siebel nor PeopleSoft in 7.3.0, because CMS ignore the entry .uaxdirectory and use the folder instead

In 7.3.1 this is fixed.

Details

 Here the steps for the 7.0 version:

  1. Go to the source code folder
  2. Locate the .UAXDirectory file
  3. In this file, remove the <UAXFile> tags corresponding to the objects that need to be filtered out (you can use the name or type attributes to identity the correct tags). Please refer to the example below for further details on how to edit the .UAXDirectory file
  4. Run the discover on the source code repository
  5. Run the analysis and the snapshot

Here the steps for the 7.2 version and later:

  1. Ensure the correct version is deployed in CAST-MS
  2. Locate the .UAXDirectory file in the deployment folder
  3. In this file, remove the <UAXFile> tags corresponding to the objects that need to be filtered out (you can use the name or type attributes to identity the correct tags). Please refer to the example below for further details on how to edit the .UAXDirectory file
  4. Run the analysis and the snapshot
Example

Here is an example of the content of UAXDirectory file

Initial content of .UAXDirectory file
<?xml version="1.0" encoding="windows-1252"?>
<UAXFiles>
 <UAXOption name="configurationVersion" value="1.4"/>
 <UAXOption name="platform" value="Oracle10g"/>
 <UAXOption name="prefixSysView" value="dba"/>
 <UAXOption name="RDBMS.Version" value="10.2.0.3.0"/>
 <UAXOption name="format" value="text"/>
 <UAXOption name="totalFatalExtractionErrorsNb" value="0"/>
 <UAXOption name="totalExtractionErrorsNb" value="0"/>
 <UAXOption name="schema" value="P709_29013_NBE"/>
 <UAXOption name="RDBMS.Name" value="Oracle Server"/>
 <UAXOption name="platform.type" value="2"/>
 <UAXOption name="totalExportedRowsNb" value="100"/>
 <UAXOption name="technicalVersion" value="1.1"/>
 <UAXOption name="platform.description" value="PL/SQL"/>
 <UAXOption name="configurationFilePath" value="CASTDatabase.config"/>
 <UAXFile path="p_Server.1.uax" name="2k3orasup" type="CAST_SQL_Machine">
  <UAXFile path="p_Instance.1.uax" name="ORA10" type="CAST_SQL_Instance">
   <UAXFile path="p_Schema.1.uax" name="P709_29013_NBE" type="CAST_SQL_Schema">
    <UAXFile path="VASTCreateView.1.uax" name="USER_ID_MV" type="CAST_Oracle_MaterializedView"/>
    <UAXFile path="VASTCreateTable.1.uax" name="INST_AUDIT" type="CAST_Oracle_RelationalTable"/>
    <UAXFile path="VASTCreateTable.2.uax" name="MLOG$_INST_AUDIT" type="CAST_Oracle_RelationalTable"/>
    <UAXFile path="VASTCreateIndex.2.uax" name="I_SNAP$_USER_ID_MV" type="CAST_Oracle_FunctionBasedIndex"/>
    <UAXFile path="VASTCreateIndex.1.uax" name="PK1" type="CAST_Oracle_Index"/>
   </UAXFile>
  </UAXFile>
 </UAXFile>
</UAXFiles>

Based on the above extraction, you will get the following objects in the dashboard:

To remove the MLOG$_INST_AUDIT table and the I_SNAP$_USER_ID_MV functional index, just comment out (or remove) the corresponding lines.


Filtered content of .UAXDirectory file
<?xml version="1.0" encoding="windows-1252"?>
<UAXFiles>
 <UAXOption name="configurationVersion" value="1.4"/>
 <UAXOption name="platform" value="Oracle10g"/>
 <UAXOption name="prefixSysView" value="dba"/>
 <UAXOption name="RDBMS.Version" value="10.2.0.3.0"/>
 <UAXOption name="format" value="text"/>
 <UAXOption name="totalFatalExtractionErrorsNb" value="0"/>
 <UAXOption name="totalExtractionErrorsNb" value="0"/>
 <UAXOption name="schema" value="P709_29013_NBE"/>
 <UAXOption name="RDBMS.Name" value="Oracle Server"/>
 <UAXOption name="platform.type" value="2"/>
 <UAXOption name="totalExportedRowsNb" value="100"/>
 <UAXOption name="technicalVersion" value="1.1"/>
 <UAXOption name="platform.description" value="PL/SQL"/>
 <UAXOption name="configurationFilePath" value="CASTDatabase.config"/>
 <UAXFile path="p_Server.1.uax" name="2k3orasup" type="CAST_SQL_Machine">
  <UAXFile path="p_Instance.1.uax" name="ORA10" type="CAST_SQL_Instance">
   <UAXFile path="p_Schema.1.uax" name="P709_29013_NBE" type="CAST_SQL_Schema">
    <UAXFile path="VASTCreateView.1.uax" name="USER_ID_MV" type="CAST_Oracle_MaterializedView"/>
    <UAXFile path="VASTCreateTable.1.uax" name="INST_AUDIT" type="CAST_Oracle_RelationalTable"/>
<!--
    <UAXFile path="VASTCreateTable.2.uax" name="MLOG$_INST_AUDIT" type="CAST_Oracle_RelationalTable"/>
    <UAXFile path="VASTCreateIndex.2.uax" name="I_SNAP$_USER_ID_MV" type="CAST_Oracle_FunctionBasedIndex"/>
-->
    <UAXFile path="VASTCreateIndex.1.uax" name="PK1" type="CAST_Oracle_Index"/>
   </UAXFile>
  </UAXFile>
 </UAXFile>
</UAXFiles>


Once removed, you need to run the analysis and the snapshot (for 7.0 version, you will need to run the discover on the source code repository before runing the analysis). As result, you get the following  objects in the dashboard:

Notes/Comments


Related Pages