ETL software that delivers an integrated reporting data foundation for the enterprise
Cognos DecisionStream is ETL (extraction, transformation, and load) software that makes operational data report-ready. It lets you build, deploy, and manage a series of linked, dimensional data marts to form an integrated business intelligence (BI) system.
Dimensional data marts are organized by subject area (such as sales, finance, and marketing) and coordinated by data category, (such as customer, product, and location). These flexible information stores mean you can adapt your data structures to respond to business changes—product line additions, new staff responsibilities, mergers, consolidations, and acquisitions.
Cognos DecisionStream has a multi-platform, server-based ETL engine and native support for all major relational database platforms. An intuitive graphical interface makes transformation processes easy for the user. They can process large volumes of data in short update windows. With Cognos DecisionStream, IT can set up a dimensional framework that can grow from a department solution to an enterprise platform. Cognos DecisionStream is an integrated component of the comprehensive BI from Cognos.
Fastest time to business intelligence. Cognos DecisionStream's data extraction, transformation, and loading capabilities are declarative in nature, meaning there is no code generation, and no ongoing code maintenance. Using an intuitive visual design environment, IT resources tell DecisionStream where to get data, how to transform it, and where and how to store the resulting outputs.
Coordinated view of your business. Cognos DecisionStream's Dimensional Framework delivers consistency, accuracy, and reusability. It delivers a coordinated view of your key business dimensions, like Time, Location, Channel, Customers, Products, Services and Accounts.
Automatic dimensional management. Cognos DecisionStream is the only tool that completely automates surrogate key generation and management. It automatically maintains links between dimension and fact tables as part of its core operation by replacing business keys with surrogates. This delivers the fastest time to result and reduces development and maintenance time because there is no coding.
Cognos DecisionStream is the only tool with a point and click approach to Slowly Changing Dimensions (SCD). The result? Fastest time to business intelligence plus reduced development and maintenance time.
Back
