Book Image

IBM Cognos Business Intelligence

Book Image

IBM Cognos Business Intelligence

Overview of this book

IBM Cognos is Business Intelligence software that enables businesses to fully utilize their maximum potential. It connects people with information from virtually any data source whenever and wherever they need it so that they can make better decisions, faster.Take the practical, hands-on approach to managing your reporting environment with "IBM Cognos Business Intelligence" - packed with coverage of all the latest features to truly help you maximize your potential.With this in-depth practical guide you will learn how to fully utilize IBM Cognos 10 so that your business can make smarter decisions, achieve better results and gain a deeper understanding of your company's data. You will learn about critical topics like Report Studio, Query Studio, Analysis Studio, Security and Administration as well as in-depth coverage of other features like Business Insight, Business Insight Advanced, and Active Reports, which were introduced with IBM Cognos 10.
Table of Contents (21 chapters)
IBM Cognos Business Intelligence
Credits
Foreword
About the Author
Acknowledgement
About the Reviewers
www.PacktPub.com
Preface
Index

Adding data source connections


After the installation, the first thing that you will need to do, in order to take advantage of your new Cognos BI environment, is to add a data source. A data source is a connection used to connect a set of data. In this case, it is a connection to connect data that you want to use for building reports. Cognos BI can connect to virtually any data source. There are native connections available for most major data source types, including but not limited to, DB2, SQL Server, Oracle, Neteeza, and so on. In addition to this, you can create ODBC data source connections to any data source that is supported through ODBC, and you can connect to nontraditional data sources through a tool that is delivered free of charge with Cognos BI called IBM Virtual View Manager. With the addition of Dynamic Query Mode, it is best practice to use JDBC drivers to connect to data sources so that Dynamic Query Mode can be fully utilized.

Let's walk through creating a data source connection...