Full Parameter List
May 20, 2019
|By Thomas Pryce
Search Knowledge Base by Keyword
Created OnMay 20, 2019
byThomas Pryce
< Back
There are also several optional parameters that can be defined in VIP Server Controller or a re-usable .cmd script. The optional and mandatory parameters are listed in the table below. Mandatory here means that you should edit the parameter for each and every Subset Action, as otherwise the defaults will be used. For all other parameters, there will either be a default, or it is wholly optional.
In the VIP Server Controller, some parameters are set from fields in the UI. This is flagged up in the below table. All other parameters are set as “Arguments”.
When executing Actions via a Command script, all parameters must be specified in the Command script.
| Parameter Name | Mandatory | Description | Examples |
|---|---|---|---|
| -fp= | Yes | Specifies the location of the .vip workflow that will execute the Subset Action. When using the VIP Server Controller this is specified in the “Flow Path” field of the “Run Flow” tab. The default flow location is: "C:\VIPTDM\SubsetCloneAndMask\SQLSubset.enc.vip" If you keep the static files in the default location, this parameter will be set by the re-usable command scripts or Executor.cfg configuration file. Note: The folder that contains the flow is the “Flow Directory”. This is what is "set" when executing via a Command Script. | -fp="C:\Users\VIP1\Documents\Subsetting documentation\SQLSubset.enc.vip" -C:\Users\VIP1\Documents\Subsetting documentation\SQLSubset.enc.vip |
| -logDir= | Yes | Specifies the location into which the Log File will be created. When using the VIP Server Controller this is specified in the “Log Directory” field of the “Run Flow” tab. | -logDir="C:\Users\VIP1\Documents\Subsetting documentation\Subset Files" -C:\Users\VIP1\Documents\Subsetting documentation\Subset Files |
| parAction | Yes | You must specify the Actions that the automation will run. These are the Subset Actions listed in the Process Overview. Possible actions are GETMETADATA, PREPENV, BUILDMODEL, SUBSET, ADDPKEYS, ADDFKEYS, ADDKEYS, DELETEORPHANS, DROP, DROPFKEYS, DROPPKEYS, DROPKEYS, GETKEYS, TABLES, FINDIDENTITYCOLUMNS, TRUNCATE, VALIDATEFKEYS, VALIDATEPKEYS, and VALIDATEKEYS. Multiple actions can be executed in one run. Simply comma separate the required actions. | -parAction=”TABLES,GETKEYS” |
| parCleardownReport | No | This specifies whether the Action(s) will empty the Subset Report file when one already exists. If set to True, the Subset Report file will be overwritten. If set to False, then the Report will be appended to the end of the existing Subset Report File. | -parCleardownReport=False |
| parCommandTimeout | No | Time (in seconds) before a SQL command times out. Defaulted to 600. | - parCommandTimeout=400 |
| parContolExcel | Yes | You must specify the location of the Control Spreadsheet that will be used to drive the action. | -parControlExcel=” C:\Users\VIP1\Documents\Subsetting documentation\VIPsubsetSample_init.xlsx” |
| parDatabaseType | Yes | MySQL, SQL Server, Postgres or Oracle. | -parDatabaseType="SQL Server" |
| parPrepenvAllTables | No | If set to “False”, it will only PREPENV will only create tables in the Staging Database when are needed to fulfil the Subset Criteria and relationships in the Database Model. If set to “True”, it will create all tables set to “Active” in the Tables sheet. If set to “False”, you must have run your BUILDMODEL. Defaulted to “True”. | - parPrepenvAllTables=False |
| par1, par2, par3, par4, par5 | No | Another way to specify Substitution Variables. If specified as parameters, these values will override the Substitution Variables specified in the Control Spreadsheet. This provides a quick way to change the values when running an Action. Substitution variables available for use in SQLCriteria and FoundCriteria. | -par1=”onpromotion” |
| parReportFile | Yes | This specifies the name and location of the Subset Report. The file name is defaulted to SubsetReport.txt To set the location where the Subset file will be generated, specify the whole file directory. If naming the file, you should include the file extension in the file name. | -parReportFile=” C:\Users\VIP1\Documents\Subsetting documentation\SubsetRun2.txt” |
| parSQLActionsPath | This parameter is mandatory when using the VIP Server Controller. | This parameter specifies the location of the SQLActions.enc.vip workflow. This is used alongside the SQLSubset.enc.vip workflow. It must be specified as an argument when using the VIP Server Controller. | -parSQLActionsPath=C:\VIPTDM\SubsetCloneAndMask\SQLActions.enc.vip |
| parOverrideBuildmodelRequirement | No | This parameter allows the SUBSET action to run even if the flow reports that the database model has changed. Defaulted to False. When the SUBSET action, VIP first checks whether the database model is up-to-date. They use the HashCodes sheet to check if the Control Spreadsheet has been changed in a way that will effect the database model. If BUILDMODEL has not been run since such a change, you will need to re-run BUILDMODEL to register the updated model. Alternatively, you can set this parameter to “True” to run SUBSET Action anyway. | - parOverrideBuildmodelRequirement=True |
-
-
-
- IEnumerable to Data Reader
- Data Table to List
- Nested String List to Data Table
- List to Data Table
- IEnumerable to List
- List to IEnumerable
- Remove from List
- Exists in List
- Value Exists in Dictionary
- Key Exists in Dictionary
- Remove from Dictionary
- Get from Dictionary
- Clear Dictionary
- Add to Dictionary
- Clear List
- Add to List
- Show all articles ( 1 ) Collapse Articles
-
-
-
-
- Introduction
- Overview of the Advanced Control Spreadsheet
- Refining the Control Spreadsheet
- The ProcessModel sheet – Toggling Subset Rules
- The Tables Sheet: Defining Metadata that will be read from the Source Database
- The ForeignKeys Sheet - Specifying which Foreign Keys to read from the Source Database
- Explanation of Remaining Sheets in the Control Spreadsheet (for reference only)
-
- Overview of Post-Subset Actions
- Add Primary Keys
- Add Foreign Keys
- Add Both Primary and Foreign Keys (The Composite ADDKEYS action)
- Validate that Primary Keys are Unique
- Validate that Foreign Keys are Unique
- Validate Both Primary and Foreign Keys (The composite ValidateKeys Action)
- Drop Foreign Keys
- Drop Primary Keys
- Drop both Primary and Foreign Keys (The composite DROPKEYS Action)
- Delete Orphans
- Truncate Data
- Drop Tables
-
-
- How to Configure the Synthetic Test Data Configuration Control Sheet
- Sample Commerce Configuration Sheet Examples
- Adding Event Hooks in Configuration sheet for custom functionality
- Use Event Hooks to call VIP Flows
- How the PreProcessVariables Table is used in the Configuration sheet
- PreProcess Variables and Parameters
- Using SQL Functions to query Databases and Using the Queries in Data Generation Functions
- Different Methods for Connecting to Source Databases
- Summary of the Process to Configure the Test Data Configuration sheet
-
-