Indigo DQM Data Execution Plans can run multiple Data Command Queries against multiple Data Sources and Types in one operation. This powerful feature allows Data from different locations to be brought together into one result with the result outputs being available for snapshots, saving, migration and reporting.
Enter the details of the Data Execution Plan along with a description and a reference. Create Data Folders to store and organise Plans in the system.
Specify a name for the Execution Plan Data Set
Select the Data Command Queries to run in the Data Execution Plan and select the order in which you want them to Execute by using the up and down arrows. You can also choose to include or not include the result as part of the Execution Plan.
Adding Execution Data to the Result XML
Execution Data can be added to the Result XML which can be used for reporting information. Check the option and Execution parameters will be included in the XML Data such Execution Time, Username etc.
Create a Data Folder for the Data Execution Plan to organise it in the Data Store.
Moving the Data Execution Plan into the new Data Folder
Data Folders are containers for Data Command Queries, Data Sources, Data Reports and Data Executions Plans in the Data Asset Store.
Folders are a way or organising the Data Store so objects can be put in related folders similar to File folders.
Execution Plan Advanced Properties
To view and edit advanced properties click the Advanced button. Advanced options allow the configuration of extra settings.
Searching Data Command Queries
Data Queries can be searched for using the Query Name, Reference and Execution Time. If the Data Asset Store contains many Queries it may be necessary to quickly locate a Query by using the Search Form.
Enter the parameters to Search and click the Search button. Highlight the Data Command Queries to Add to the Execution Plan and click the Select button.
Data consolidation using Execution Plans allows the collection and integration of data from multiple sources into a single destination. During this process, different data sources and types are put together, or consolidated, into the Indigo DQM Data Store.