Oracle and GLOBAL TEMPORARY TABLE - please provide a flag to tell us we can't mask these tables!!!

book

Article ID: 196464

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

We got an issue when using the portal and Oracle GLOBAL TEMPORARY TABLE.

 

Since you can't mask those tables, could we have a flag to tell us that we can't mask those type of table.

 

 

 

Environment

Release : 4.9

Component : CA Test Data Manager

Resolution

I created an updated TDM Portal version to provide the functionality to configure whether to fetch Temporary Tables or not in case of Profiling Oracle DB.



1) The updated TDM Portal version is 4.9.79.0 and it can be accessed by requesting this version or later from Broadcom Support.


Please ensure that the new version is installed and required configuration is done as mentioned below.

2) In CATDM_HOME\\config\\application.properties file ensure that tdmweb.profiling.oracle.skip.temporarytable is set to true

3) Restart portal

4) Try to create Data Model (or RESCAN incase of existing Data Model), then temporary tables in Oracle should not show up in the model