Using Javelin to clean up the Views in the GTREP repository
search cancel

Using Javelin to clean up the Views in the GTREP repository

book

Article ID: 368190

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

We would like a way to automatically schedule, or automate the GT DataMaker functionality of dropping the old repository views.

Environment

TDM 4.10+
Javelin (All releases)

Resolution

Attached are example Javelin flows that will drop the older views from the gtrep repository. 

Note: to use these examples, you must know the username and password for accessing the gtrep repository. Also, you must provide the date range in the query variable, that you would like to drop. This is a bit different from the query that GT DataMaker uses, since DataMaker drops all view older than 3 days. You also have the freedom to modify the query to do the same.

Additional Information

Attachments

DROP_GTREP_VIEWS-ORACLE.vwf get_app
DROP_GTREP_VIEWS-MSSQL.vwf get_app