Indigo DQM Data Management Engine shared Data Sources can be used by all Data Command Queries and Execution Plans in the System.
If the Data Source is common to multiple Data Queries then create a shared Data Source.
Select the Data Source Tab from the Indigo DQM Data Management Studio.
Indigo DQM supports multiple Data Sources and Types including Microsoft SQL Server, Microsoft Access, ODBC, OLEDB, MySQL, Oracle, Postgre, Firebird, XML, JSon and CSV. The Indigo DQM Data Management Engine is unique in its ability to handle multiple Data Sources and Types simultaneously making it transparent to virtually all Data Sources.
Create a Data Folder for the Data Source to organise it in the Data Store.
Creating a new Data Source
A Data Source can be a Connection String to a specific Data Source Type such as a Microsoft Access Database, Microsoft SQL Server or MySQL. Shared Data Sources can also contain Raw Data in the form XML, JSon or Comma Separated Values (CSV).
Select the Location Radio Buttons to Select the Data Store Source in this example the Location of the Data Source is specified in a Data Connection String.
Enter a Name and Description for the Data Source and Select a Data Folder.
Selecting a Microsoft SQL Server Database
Enter the connection parameters for the Data Source.
Connection Strings can be Saved or Opened into the Data Connection Dialog.
Data Source Type Properties
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 and Data Provider for the Data Connection.
Click OK to update the Connection String.
Creating a Raw Data Source
Select the Location Radio Buttons to Select the Data Store Source as Raw Text or a File.
To store XML Data in the Data Store select either the XML Data Set or XML Document option.
Paste the Raw Data into the Text Box or open the Editor to select the Data Source.
Check the Encrypt option to Encrypt the Raw Data using AES 256 Encryption.
Data Source Advanced Properties
To view and edit advanced properties click the Advanced button. Advanced options allow the configuration of extra settings.