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

Indigo DQM Data Management Engine 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. Create Data Folders to store and organise queries in the system.

Data Sources

Indigo DQM supports multiple Data 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 Data Source Type and Connection String parameters for the Data Source. Or create a shared Data Source and select from the drop down list.

Select Data Source Type

Enter Connection Parameters

Data Set and Table Names

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

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.

Data Folders

Create a Data Folder for the Data Command Query to organise it in the Data 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.

Creating a new Web Service Data Source

A Data Source can be a Connection String to a specific XML or JSon Web Service Data Source.

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.

Data Command Advanced Properties

To view and edit advanced properties click the Advanced button. Advanced options allow the configuration of extra settings.