Business Intelligence for Microsoft

Overview

Integrate Cognos 8 Business Intelligence into your Microsoft environment to deliver powerful reporting, Scorecarding, and planning capabilities to everyone in your organization.

Windows operating systems

• You can deploy Cognos software on Windows 2000, Windows XP, and in clustered environments.

SQL Server

• Build reports, analysis, scorecards, and financial plans using data from SQL Server and MS Analysis Services.
• Cognos Reporting can use SQL Server functions such as federated database servers, XML, multiple instances of SQL Server, and failover clustering support.
• Cognos Reporting supports Active Directory for security.
• Single sign-on for simplified user experience.
• Use Cognos data integration to build Analysis Services cubes.

Data Transformation Services (DTS)

• Cognos leverages the flexibility of DTS by reading and writing DTS packages as sources and targets.

Internet Information Services (IIS)

• Cognos supports and integrates with the IIS Web server.

Internet Explorer

• Zero-footprint, browser-based interface for reports, scorecards, OLAP, and visualizations.

MS Office

• Use MS Outlook to deliver alerts in PDF or HTML.
• Import, manipulate, and publish BI content in MS Office files.
• Excel interface for planning delivers advanced capabilities through a familiar spreadsheet environment. 

MS SharePoint Portal Server

• Open APIs and Web Services to deliver customized BI content through SharePoint Web Parts.
• Open, Web-based architecture allows integration with .NET applications.
• Service-level APIs let Visual Studio or .NET developers use Cognos WSDL to develop .NET code.

Data warehousing

• Cognos supports open standards and MS technologies including OLE DB, OLE DB for OLAP, and MDX.

Key certifications

• Certified in the Query, Reporting, and Analysis Tools category of the Microsoft Data Warehousing Alliance (DWA)
• Cognos Series 7 is certified to work with SQL Server 2000.
• Managed Microsoft ISV Partner
• Microsoft Certified Partner
• Microsoft SQL Server Data Warehouse certification