Data Warehouse

Many institutions wish to report against the MAPS and Argos databases to gather information on users, DataBlocks and reports, security information, etc. While it is possible to gather some of this information by querying the databases, there are some disadvantages to doing so.

MAPS 4.3 introduces the data warehouse, which is a new feature that allows you to run reports against a copy of some of the most commonly-requested data from the MAPS and Argos databases. By using a separate copy of the data, you can run very detailed queries and reports without impacting the performance of your production databases.

If you enable this option, MAPS will copy select information from the MAPS and Argos databases to a separate data warehouse database immediately following the nightly MAPS backup. (You can also migrate the data manually.) You can then report against the data warehouse rather than directly against the MAPS and Argos application databases.

For information on using Argos to report against the data warehouse, see Reporting Against MAPS and Argos Databases.

The Data Warehouse settings in MAPS are located in the Auditing & Data Warehouse section:

• Migrate daily after MAPS automatic backup - If you have enabled nightly automatic backups in MAPS, you can check this box to automatically migrate data to the data warehouse after the backup.
• Number of days to store auditing records - Choosing a lower length of time to store records from the auditing table can help to limit the disk space used by the data warehouse, as well as speed up queries that use the auditing tables.
• Migrate Data Now - Click this button to migrate data to the data warehouse immediately. The date of the last manual migration appears underneath in red text.