Indigo DQM Data Management Engine Data Command Queries allow Data Sources of any type to be queried using standard relational SQL queries and / or XQuery / XPath.
Select the Query Tab for the Data Command and check the radio button for either Command Text or Command File.
Command Text option will Execute the Command entered into the Textbox. Selecting the Command File option will Execute Commands contained in a shared Command File at the location specified.
Creating or Editing a Data Command and will load the Data Schema based on the connection parameters of the Query Data Source.
Click the button for the Query Command Text to open in the Data Command Query Designer.
Test Executing the Data Command Query
Data Command Queries can be tested before deployment using the Query Tab.
Click the Execute button to Run the Data Command. The output results are displayed below.
Data Command Files
Data Command Files are useful for sharing Queries with multiple Data Commands in the System. If you have a Query used by several Data Commands create a Command File by saving the Query to File and then pointing the Data Command Query to the Command File. This is a more efficient way to share Command Text for support and maintenance should the Data Command need changing.
The Command File can be local, on a Network share or on the Internet. Open the properties page for the location to specify the URI for the File.
Encrypting the Data Command
The Data Command Query can be Encrypted for added security using the Advanced Encryption System (AES) with a 256-bit encryption key . Check the option and the Data Command will be Encrypted in the Data Store. If the option is Enabled for the Command File then the Command File must be Encrypted by the System. You can Save a Data Command Query from the Query Designer and use the Encryption Tool to Encrypt the Command File.
A secure Password must be setup in the Program Settings and Options or applied to an individual Data Asset Store. By default a global Encryption Password will be used but it is recommenced that you create your own unique Password.
Encryption Passwords must match when Encrypting / Decrypting Data. It is recommended that a copy of your Password be stored in a secure Location. If you lose the Password it will be impossible to Decrypt any Encrypted Data.
Enabling a Result Limit
The results can be limited to a maximum number of Data Rows by enabling the Result Limit option. Select the maximum number of Data Rows to be returned before the Data Command stops Executing.
Enabling Select Filters and Sorting
Data Filters can be applied to the Data Command Query to return even more specific results. For example, in the above Test Data if a Select Filter is applied for Name = 'Cool Doc Fee' then only the Fees with this Name will be returned. Also, additional sorting can be applied to the Data Command Query to sort results by specific Columns.
Test the Data Result Outputs
Testing the Data Source you can also apply XPath to the Data Source if CSV or XML. If the Data Source is a Database you can apply SQL and / or XPath to that Database using the SQL dialect for that particular Data Source.
Data Command Query Designer
The Data Command Query designer gives a logical view of the Data Schema. Click the Open button next to the Command Text to open the Designer.
All Tables, Views and Procedures are shown in the Explorer.
The Data Command Query designer allows complex queries to be created and tested before deployment.
Data Command Advanced Properties
To view and edit advanced properties click the Advanced button. Advanced options allow the configuration of extra settings.