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 ...

Get IBM Cognos 8 Planning now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.