Enterprise-scale data warehousing data mart projects typically involve the merging of data from multiple sources, such as ERP or legacy systems, or purchased data (such as mailing lists).

Cognos DecisionStream can extract, merge, transform, and aggregate data from multiple data sources. The designer has complete control over all of these functions.

Quickly and easily define and test connections to any data source, including native access to all major relational database systems, to SAP/R3, and to ODBC data sources.

Use the defined connections to access data across multiple databases in a single dimension or fact build.

Designers can use a built-in visual SQL tool to select which tables, views, or columns to include in the data source.