EASY + POWERFUL + AFFORDABLE  
Untitled Document

Print friendlyprint

With business intelligence comes the inevitable challenge of data integration.

This process is essential not only because it involves identifying and acquiring the right data to calculate the metrics that businesses require, but also because data integration architecture will largely determine the efficiency and performance of the entire BI solution once it is delivered.

But here’s the problem:

Integrating data from multiple sources to build a warehouse or mart is challenging, time-intensive, and resource-intensive. And most data integration projects involve a difficult tradeoff. The lower the data latency required, the greater the query load placed on operational systems. In 95% of cases, organizations choose high (24 hour+) data latency, and generally end up writing large amounts of custom code to automate the integration processes. In fact, approximately 75% of data warehouse development involves custom coded data integration. These efforts often take months to implement and cost organizations millions to implement and maintain.

At Altosoft, we do data integration differently.

MetricsMart makes data integration flexible and responsive to the needs of business users. It enables dynamic latency selection, so that metrics are delivered to business users when they need them, rather than at the whim of some batch refresh cycle. It can handle real-time environments. And it’s easy to configure and maintain. Rather than requiring custom code or scripting, it’s 100% codeless.


MetricsMart is better, and here’s why:

Intelligent Data Aggregation (IDA)
Rather than moving mass amounts of data in batch to a data warehouse, it intelligently moves the data needed to deliver the KPIs your business needs. This approach, called Intelligent Data Aggregation (IDA), makes MetricsMart extremely efficient.

Codeless Implementation
Instead of writing volumes of ETL scripting and SQL to first centralize all data into a data warehouse or mart, and then following this up with more coding, scripting, and/or SQL to derive KPIs from this raw data, MetricsMart delivers the final KPI metrics to our unique Smart Mart in a single step – with ZERO coding. The result is that all KPIs are processed and stored in a third party repository (generally SQL Server or Oracle) as fully dimensioned tables that can be easily accessed by Insight’s web services interface or directly via any other off the shelf SQL reporting or analysis tools.

Minimal Query Load
MetricsMart uses high performance in-memory processing to perform the most complex, time-consuming calculation, including complex cross-database calculations like outer joins. That means low latency data and minimal query load on source systems.

Real-time Data
Without highly customized integration efforts, standard BI solutions can take days or sometimes even weeks to aggregate, analyze, contextualize, and present operational information to business managers. MetricsMart outputs data into a highly optimized, fully dimensioned Smart Mart and automatically keeps this Smart Mart up-to-date as source data changes. Thus, with an Altosoft solution, you can get the latest business data and analytics at your fingertips within seconds.

Process Awareness
MetricsMart is business process aware. MetricsMart’s optional process state engine, ProcessMart, tracks every business process and enables you to view process performance and process quality.

Easy to Implement and Maintain
MetricsMart is easy to use and has a negligible learning curve. It’s configured using the friendly guide-based Insight Studio tool. Again, no code or script is required - it’s all point and click.

Rapid and Cost Effective
Would you rather be dependent on an IT specialist to understand your data and take months to build solutions or have the ability to integrate your data in days, possible even on your own?

Any Data Source
MetricsMart can integrate data from a variety of sources – including traditional sources like relational databases (Oracle, SQL Server, etc.), enterprise applications like ERP and CRM, flat files, and Excel. But Altosoft also goes beyond this to integrate data from real-time, event-based data sources like Tibco, MQSeries, BizTalk, and more.

Naturally, Altosoft still works with existing data warehouses. MetricsMart can connect to a data warehouse and enables data monitoring, analysis, and dashboard visualization in minutes. And since even the largest and best-designed data warehouses inevitably don’t contain all the enterprise data that needs to be analyzed, Altosoft can come in very handy. In these situations, Altosoft can combine warehouse-based data and data from other systems, calculate KPIs, and deliver analysis – without requiring modification of your data warehouse environment. In fact, some of Altosoft’s largest customers, with massive data warehouses, are using Altosoft for exactly that purpose.

Data integration has never been this easy.