Technical Integration
AN INTEGRATED SOLUTION
The following table shows how the Cognos and Microsoft solutions are integrated:
| MS COMPONENT |
COGNOS INTEGRATION |
| WINDOWS |
Cognos software runs on these operating systems, even in clustered environments. It leverages Windows security and scales well. For example, Cognos ReportNet deployments of 20,000 users yielded an average response time of 1.4 seconds and 6.7 million PDF pages per day of batch reports. |
SQL SERVER
 DTS |
Cognos products, including Cognos Visualizer, Metrics Manager, and PowerPlay, deliver rich BI to any user across the organization, using the SQL relational database and Analysis Services as the source for data. Cognos supports advanced functionality in SQL Server and Analysis Services and extends messaging through such features as notifications, dashboards, and scorecards.
Cognos ReportNet supports Active Directory for security and can use SQL Server functions such as federated database servers, XML, multiple instances of SQL Server, and failover clustering support. Cognos ReportNet, Enterprise Planning, and Metrics Manager can use SQL Server as a repository. Cognos DecisionStream can build and generate Analysis Services cubes. Cognos products can use a single sign-on for a simpler user experience.
|
| Cognos leverages the flexibility of Microsoft Data Transformation Services (DTS) by reading and writing DTS packages as sources and targets. |
| INTERNET INFORMATION SERVICES |
Cognos supports and integrates with the IIS Web server. |
| INTERNET EXPLORER |
Because Cognos products are zero-footprint, users can access corporate information through Internet Explorer or other browsers without any additional software. They can use IE for any CPM activity, such as viewing and bookmarking reports, performing queries and analysis, scorecarding, and dashboarding. |
| OFFICE |
Microsoft Outlook can be used to deliver Cognos NoticeCast event notifications and to email reports in various formats such as PDF and HTML. Office documents can include embedded Cognos reports. Cognos business intelligence and planning products include Excel add-ins and plug-ins. |
| SHAREPOINT |
Cognos provides APIs and Web Services to deliver customized BI content through SharePoint Web Parts. Cognos' Service-Oriented Architecture, an open Web-based architecture, allows Cognos products to integrate with .NET applications. Cognos' service-level APIs let Visual Studio or .NET developers use the WSDL from Cognos and develop .NET code. |
|