BI & Performance Management for Teradata

Integrated Technology


IBM Cognos 8 BI leverages Teradata's data warehouse technology across clients, servers, and the Web on Windows, UNIX, and Linux platforms.

Key integration points

  • IBM Cognos tools leverage the TERADATA OPTIMIZER to automatically generate version-specific, optimized, and native Teradata SQL.
  • Cognos tools are 100% schema-neutral (3NF, Snowflake, STAR): leveraging Teradata's high performance normalized models and supporting performance optimizing techniques such as Soft Referential Integrity, Join Indexes, Aggregate Join Indexes, Partitioned Primary Indexes, and more.
  • Cognos tools can leverage metadata directly from Teradata Meta Data Services (MDS).
  • Cognos data integration uses Teradata Bulk Loaders for fast data loading into your data warehouse.
  • Use any combination of LDAP, OS, or RDMS security. SSL protocol ensures secure delivery outside the firewall.
  • Produce native queries using Teradata Database standards and protocols without users needing to know how to write SQL.
  • IBM Cognos software uses the best tool for the job—ROLAP, MOLAP, or HOLAP.

The Cognos 8 - Teradata Performance Management Overview
Click the thumbnail to view a larger version.

Analytical Processing Technology   Teradata Optimization
ROLAP (Relational On-line Analytical Processing) - Data remains in relational database and relies heavily on the database engine to perform calculations and aggregations.   Pre-calculated aggregations with Aggregate Join Indexes (AJI) provide fast query response.

Uses Teradata parallel engine for fast query response.

Leverages Teradata Optimizer to automatically generate version-specific, optimized, and native Teradata SQL.

MOLAP (Multi-dimensional On-line Analytical Processing) - Data to be analyzed is identified, extracted, pre-calculated, aggregated, and stored in mid-tier data store or "cube".   Uses Aggregate Join Indexes and Teradata load tools to speed cube creation and updates.
HOLAP (Hybrid On-line Analytical Processing) - A combination of MOLAP & ROLAP. Some dimensions and levels of the data to be analyzed are extracted and stored in a mid-tier cube for high-level analysis. Users drill-down into a relational database.   Pre-calculate cube's lowest level aggregates via Aggregate Join Indexes for quick refreshes. This allows more frequent updates to cube.

Leverages Teradata Optimizer to automatically generate version-specific, optimized, and native Teradata SQL.

Additional Resources:


IBM Cognos 8 Business Intelligence - Full Overview
Online Demo
Complete capabilities in one product, on a single architecture. See key features for both business and IT users, including Framework Manager, the Adminstration Console, and integration with Microsoft Excel.
Read Now
Cognos Performance Manager
Online Demo
See how plans, financial reports, and scorecards can help you manage performance across all data sources.
Avoiding Performance Management Pitfalls
White Paper
Read what Robert D. Kugel, Ventana Research, describes as performance management pitfalls.
 
Teradata Resources
IBM Cognos 8 Business Intelligence - Full Overview
Online Demo
Complete capabilities in a single product. See key features for IT and business users.
Reporting and Performance Management
Online Demo
See reporting as part of managing performance for every department.
Avoiding Performance Management Pitfalls
White Paper
Read what Robert D. Kugel, Ventana Research, describes as performance management pitfalls.
Contact Sales