How to connect to Data Mart
The structure of the YSoft SafeQ Data Mart Mode feature makes importing data from Data Mart mostly automatic.
Enable Enterprise Reporting
This is a few step recapitulation of more detail explanation from Data Mart Mode article.
Requirements
Reporting License - Data Mart Mode functionality requires the YSoft SafeQ Reporting module license included in the environment.
How to enable
In YSoft SafeQ management interface, log as a user with admin access.
Navigate to System Settings tab.
Set configuration property enableCMLDataMart to Enabled.
Note: This setting is turned off by default with all YSoft SafeQ installations.
Other considerations, best practices
When Data Mart is enabled, it is recommended to disable the Web Reports functionality for performance reasons. Set web-stats-enable to Disabled.
When Data Mart is enabled, it is recommended to disable the Management Reports functionality for performance reasons. Set enableManagementReport to Disabled .
Use the following properties to fine-tune statistics data retention:
maxStatsMonthsBase - Maximum number of months, for which web reports and counter reports data are stored. Default value is 36.
maximumCMLDataMartMonths - Maximum number of months, for with the data mart measurements are kept. Default value is 36.
maxStatsDaysFull - Maximum number of days, for which unaggregated web reports are kept. Default value is 31. It is NOT recommended to adjust the number without consulting Y Soft.
remove-jobs-from-db - Maximum number of days, after which the print jobs metadata will be removed (along with jobs log and jobs accounting metadata). Default value is 31. It is NOT recommended to adjust the number without consulting Y Soft.
printJobAgeForStats - M inimum age of print jobs to include in web reports and data mart statistics for Management Service cluster environment, in minutes. Allowed range is between 20 and 120. It is NOT recommended to adjust the number without consulting Y Soft.
enable-purge_reports - Either enables or disables Green Reports found on the Administrator or End-User Dashboards. This value should be enabled in order to capture, and report on, savings.
Connect Business Intelligence tool to Data Mart
Use Business Intelligence tool for connection with data mart and create your own customised reports.
List of manuals for tested BI tools: