Metricus Data Management, tools and knowledge that facilitate the transfer of data from your ITSM tools into Metricus


Metricus sits on top of existing service management and other systems and tools and works of data from all of these systems and tools as well as manual data that is provided to Metricus. Service management systems are the main data sources for Metricus and various methods and tools are provided to collect data and transform this to Metricus.

Metricus provides three options for the collection of data from your environment: manual data entry, data connectors / SQL scripts, or FTP using ‘Simple Data Templates'. The last option is preferred and requires organizations to extract data into a predefined spreadsheet that is uploaded to Metricus. Data Management in Metricus is easy and very well manageable without interference of technicians or skilled data warehouse specialists.

Toolkits for the collection of data (Metricus Data Mart). Metricus is built on Microsoft architecture and uses SQL Server SQL Database for the collection of data related to defined IT Performance metrics. This includes:

  • IT Entity table structures for the integration of data required to provision metrics values and provide supporting drill-through data;
  • Metrics table structures related to the storage of metrics, calculation of metric values and storage of metric history, calendar details, data hierarchies, scoring and trend parameters, and scoring hierarchies.

SQL Server Integration Services packages for management of data related to defined IT Performance metrics. This includes:

  • Template packages for loading data from all major IT enterprise management systems into the IT Entity tables e.g. loading data from HP ServiceCenter Incident Management into the [ITE Incidents] table
  • Packages to populate Metrics table structures from IT Entity tables e.g. scoring, trending
  • Packages to load pre-processed data into the Metrics module i.e. direct loading of metrics values from an XLS file
  • Packages related to jobs required for the ongoing maintenance of metrics e.g. data loads, cube processing and data quality routines
  • Automatic generation of metrics and scorecards in Microsoft PerformancePoint 2007

SQL Server Analysis Services database configured and optimized for the analysis of IT Performance metrics via PerformancePoint 2007. Includes:

  • Standard cube structures and dimensions for metrics and supporting data from IT Entity tables
  • Business Intelligence capabilities and functionality supporting PerformancePoint 2007 e.g. named sets, calculated measures.

Ready for more?

Sign up for a 30-day Free Trial and try out Metricus for yourself

Sign Up for a Metricus Demo Account

Or follow these links to learn more about Metricus: