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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
