Extract and Integrate Disparate Source Data

IBM Cognos Integration Server extracts data, metadata and security profiles and moves them into open data warehouses and repositories for use in financial performance management (FPM) or business intelligence (BI) applications, or directly into IBM Cognos TM1®.

Cognos Integration Server enables users to source specialized cube data from a variety of sources, including Oracle Essbase, Oracle Hyperion Planning, Oracle Hyperion Financial Management and Cognos TM1. It reduces the need for custom integrations that can introduce compliance risk and place a burden on IT resources.

Cognos Integration Server provides:

  • Integrated and automated_extraction—automates data extraction and streamlines the process of dynamically generating target schemas that support data warehousing and single source reporting.
  • Intelligent, near-real-time data extraction—extract Oracle Hyperion cube data, metadata and security profiles for loading into open-standard reporting formats or Cognos TM1®.
  • Support for continuous planning—perform extractions on a continuous basis to update external reporting and analysis applications.
  • Preserved hierarchies—ensure that important hierarchies and drill paths that reflect the business are preserved in the target relational reporting application.
  • IT and finance_data—provide IT with access to data while finance users can continue to use cube technology.