O'Reilly logo

IBM Cognos 8 Planning by Rich Babaran, Ned Riaz, Jason Edwards

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Connecting to external data sources

With Analyst, you can connect to a variety of data sources, such as a text file or a database. The simplest method of doing this is by using a File Map. With a File Map, you can connect to the delimited ASCII text files, and configure the file so that the data can be imported into a D-Cube. A more advanced method uses an ODBC connection. ODBC stands for Open Database Connectivity. This method allows you to connect to any data source for which you have configured a data source name. This includes text files, spreadsheets, and databases. To use this method, you must have the appropriate drivers installed on your computer, and you must be familiar with basic SQL. Once configured, the data source becomes available ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required