ETL software to build data marts and warehouses for reporting and analysis
IBM® Cognos® DecisionStream™ delivers a consistent data foundation for reporting and analysis across the enterprise.
Deliver a consistent data foundation for BI, working with ERP data, flat files, or data accessible by ODBC application protocol interface.
- Dimensional data marts organize your data by subject area (sales, finance) and by data category (customer, product).
- Multi-platform, server-based ETL engine processes large volumes of data in short update windows with minimal hardware investment.
- Intuitive, graphical interface makes transformation processes quick and easy for the user.
- Flexible, dimensional framework adapts to business changes and can scale up from a department solution to an enterprise platform.
- See IBM Cognos 8 Business Intelligence - Expand the value of IBM Cognos DecisionStream with IBM Cognos 8 BI.
Learn more
Buy Cognos DecisionStream
IBM Software Subscription and Support is included in the product price for the first year.
Download software online after purchase - no shipping costs.
Not available to purchase online. Other ways to purchase or learn more.
Contact IBM
- Request a quote
- E-mail IBM
- Or call us at: 1800 557 343
Priority code: 109HF06W
Architecture
Working within existing data architectures, the pipelined transformation engine reads the data in a single pass, delivering high throughput with minimal hardware investment.
From any client machine, process builds or jobs on any server machine located in the network using Web Services.
Administration
IBM® Cognos® DecisionStream integrates with source control systems, promotes or shares components from environment to environment and performs component impact analysis.
For any build or job, see in a graphical environment how it has performed over time by reviewing log files and analyzing statistics or view any current process as it executes regardless of where the execution takes place.
Dimensional
Gain more than just Star Schema deliveries:
The software organizes common descriptors such as customer, time and location into dimension tables and places measures into fact tables. Distributed data sources are integrated into a consistent, enterprise-wide view.
Gain more than just Star Schema deliveries including Automated surrogate management, Automated delivery of conformed dimensions and facts, Automated support for slowly changing dimensions, automated hierarchy definitions and validation and automated late arriving facts and dimensions.
Ease of use
Prototype and test warehousing solutions prior to deployment.
Create a JobStream to manage the data integration process in a drag-and-drop environment.
Use interactive wizards to develops builds in rapid time.
Integration
Using an open SQL interface, the IBM Cognos DecisionStream Connector for SAP R/3 can access all tables through the SAP Application Layer. Pre-built ABAP functions interpret and resolve the SQL code.
Selectively choose what facts and dimensions are to be delivered to the IBM Cognos ReportNet environment (IBM Cognos Framework Manager) to enable instant reporting from the reporting structure.
In support of IBM Cognos Series 7 reporting and analysis, create default IBM Cognos Architect models, reporting catalogs, PowerCubes® and key reports optimized for each data mart.
Popular Cognos DecisionStream downloads
-
Analytic applications
- Cognos 8 Workforce Performance
- Cognos Business Insight
- Cognos Consumer Insight
- Cognos Customer Performance Sales Analytics
- Cognos DecisionStream
- Cognos Financial Performance General Ledger Analytics
- Cognos Financial Performance Payables Analytics
- Cognos Financial Performance Receivables Analytics
- Cognos NoticeCast
- Cognos Supply Chain Performance Procurement Analytics
- Cognos Workforce Performance
- Cognos Workforce Performance Talent Analytics
- IBM Intelligent Operations Center
Considering a purchase?
Contact IBM
Considering a purchase?
- Request a quote
- E-mail IBM
- Or call us at: 1800 557 343
Priority code: 109HF06W