Indigo DQM Data Management System Indigo DQM
Data Command Basics Indigo DQM Help

Indigo DQM's Data Management Engine (DME) can execute queries and process data against any type of Data Source using standard relational SQL queries and / or XQuery / XPath.

Enter the details of the Data Command Query along with a description and a reference. Select a Data Folder to store and organise the Data Query in the system.

Data Sources

Indigo DQM supports data from multiple sources and types including Microsoft SQL Server, Microsoft Access, ODBC, OLEDB, MySQL, Oracle, Postgre, Firebird, XML, JSon and CSV making it transparent to virtually all Data Sources.

Open the Data Source Connection dialog and specify the type and connection string parameters for the data or create a shared Data Source and select from the drop-down list.

Select Data Source Type

Enter Connection Parameters

Data Command Query Private Data Source

Data Command Query Shared Data Source

Shared Data Sources can be used by all Data Command Queries and Execution Plans in the system. If data is common to multiple Data Queries then create a shared Data Source.

Click the radio button for a shared Data Source and select from the drop-down list.

Data Set and Table Names

Data Names and Table Names can be specified in the Data Command Query to override the default names from the Data Schema.

Adding Execution Data

Execution data can be added to the Result XML which can be used for reporting information.

Check the option and detailed execution parameters will be included in the XML data such as:-

  • User Name
  • Computer
  • IP Address
  • Execution Time

Data Folders

Create a Data Folder for the Data Command Query to organise it in the Data Asset Store.

Moving the Data Query 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.

Data Folders are used for organising objects in the Data Asset Store.

Creating a new Web Service Data Source

Data Sources can be a connection strings to specific XML or JSon Web Services.

Enter the connection parameters for the Data Source.

To show the Data Connection String properties click the properties button at the bottom of the Connection Dialog. This will display the advanced properties for the Connection String.

Selecting a Web Service JSon Data Source

Enter the connection parameters for the Data Source.

Click OK to save the Data Source.

Run Options

Enabling the 'Auto Execute' option will allow the Data Command Query to automatically execute when selected in the Data Management Studio.

Data Command Advanced Properties

Advanced options allow the configuration of extra settings for the Data Command Query.