Indigo DQM includes a utility to Create a new MDB Data Asset Store on the fly. The Data Asset Store is a Database that holds all the Data Command Queries, Data Folders, Data Sources, Data Reports, Execution Plans and Execution Logs in a shared Data Repository.
Initially the system comes with a default Data Assets Store as an MDB Database which is installed in the User Documents Folder. Its purpose is to consolidate Data Assets into a shared repository for the most efficient Data Management, Processing, Access and Reporting.
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.
Creating a new MDB Data Store with the Wizard
To Create a new MDB Data Store select the option from the Data Management Studio Tools menu. Follow the instructions in the Wizard.
Select the location to Create the new MDB Data Store using the browse button.
Check the option to the Add the Data Asset Store.
To Activate the Data Asset Store check Activate and the Store will become the Active Store upon completion of the Wizard.
If the option to Add the Data Store to the Data Asset Stores you will be prompted to enter the details of the new Data Store.
Click OK to Add the Data Asset Store and complete the Setup.
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.