The Data Asset Store is a Database that contains all the Data Command Queries, Data Folders, Data Sources, Data Reports, Data Execution Plans and Execution Logs in a shared Data Repository.
Its purpose is to consolidate Data Assets into a shared repository for the most efficient and effective Data Management, Querying, Processing and Reporting.
Initially the system comes with a default Data Assets Store as an MDB Database which is installed in the User Documents Folder.
This can be moved to any location including a network share. The Data Store may also reside on another type of database such as Microsoft SQL Server or MySQL. You can migrate the Data Asset Store to another Database using the built-in migration features of the system or with the tools provided with your Database.
To configure the Data Store select the Tools menu and click Data Store Source.
Configuring the Data Store
Select the Data Store Source Type from the dropdown list.
The Data Store can also be configured from the Settings and Options dialog.
Configuration of multiple Data Asset Stores
Multiple Data Asset Stores can also be setup and Activated using the Data Asset Stores configuration utility.
To Activate the Data Asset Store click the Activate Button and the Store will become the Active Store.
Indigo DQM Data Asset Store supports multiple Data Sources Types including Microsoft SQL Server, Microsoft Access and MySQL. The Data Store can be migrated to any of these Data Source Types using the inbuilt features of the system or with the tools provided with your Database.
Adding a Data Asset Store
Adding a new Data Asset Store using a Microsoft SQL Server Database. Enter a Name and Description for the Data Store.
Specifying the connection parameters to the Data Store using the Connection Dialog.
Indigo DQM features AES 256 Encryption allowing Data Assets to be stored and transmitted across the Internet / Cloud in the most secure way possible.
Data Result Outputs, Data Source Files, Raw Data and Backup Data can be Encrypted and stored securely using the highest level of cryptography.
Encryption can be setup globally in Program and Settings or applied to an individual Data Asset Store where a Private Encryption Password will be used to Encrypt Data.
To use a Private Encryption Password on the Data Store select the Radio button and Enter a Strong Password.
Click the Generate button to automatically create a strong Encryption Password. The strength of the Password is shown by the Quality Bar.
Great care must be taken to keep copies of Encryption Passwords in a secure location. If you lose your Password you will not be able to Decrypt your Data. You must also remember what Password you used to Encrypt Data if you decide to change the Password at a later stage. Encryption / Decryption will only work if the Encryption Passwords are the same.
The Advanced Encryption System (AES) 256 is a symmetrical encryption algorithm that uses a 256-bit Encryption Key. It is accepted by the U.S. and Canadian governments as the most secure way to store sensitive Data.
With AES-256 bit encryption you can be assured that you will be the only one who can access your critical information.
NOTE: The Default Encryption Password should only be used for Testing! You must create or generate your own secure Encryption Password!