Purchase your Section 508 Compliance Support guide now!

Purchase your Section 508 Compliance Support guide now!

Modeling a Virtual View Manager data source

Modeling a Virtual View Manager data source

Use ODBC to access the Virtual View Manager data source from IBM Cognos 8 using the command-line utility named driverConfig to add an ODBC DSN. The data source associates a particular ODBC driver with the data you want to access through that driver. In order to be able to create an ODBC DSN, the user publishing the views must have the appropriate permissions for the Virtual View Manager configuration files and libraries. The ODBC DSN could be configured this way: 

[SQLServer_TERADATA]
host = localhost
port = 9401
uid = admin
password = ********
domain = cognos
datasource = SQLServer_TERADATA
catalog = Cognos