Security considerations
Security considerations
When working with IBM Cognos 8 and Virtual View Manager, it is possible to specify security at different levels. By default, Virtual View Manager provides a domain named "cognos" to secure the application. An administrator can add other users and set their access permissions. It is also possible to specify metadata and data security in Framework Manager.
You can also limit access by using IBM Cognos 8 to secure a DSN that was created using the administrator user ID and password. By using pass-through logins, you ensure that Virtual View Manager users have user IDs and passwords that are valid on the underlying data source(s).
An ODBC DSN must be created to provide all users connectivity to the Virtual View Manager data source through an ODBC driver. These data sources are local to a computer. All users with the appropriate privileges can access the ODBC data source. The data source name must use fewer than 32 characters.
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
Basic concepts of Virtual View Manager
Basic concepts of Virtual View Manager
The workflow for using Virtual View Manager is separated into three processes:
 | Setting up the environment by installing and configuring the appropriate software and drivers. The installation also installs IBM Informix® and creates a repository to contain your Virtual View Manager content. |
| Creating a data source using Virtual View Manager Studio, which includes accessing and simplifying the metadata using Virtual View Manager Server. |
| Accessing Virtual View Manager views using IBM Cognos 8 and preparing metadata for reporting in IBM Cognos 8. |
Virtual View Manager Server can be installed in the same environment as Cognos 8, but an installation on a separate computer gives better performance and availability. The installation creates a Virtual View Manager repository and starts both the Virtual View Manager process and the Virtual View Manager Server.
Because IBM Cognos 8 uses the Virtual View Manager ODBC driver to access Virtual View Manager data sources, the ODBC driver and driver manager must be installed on each instance of the IBM Cognos 8 report server and the Framework Manager. The driver manager routes all IBM Cognos 8 requests to the appropriate ODBC driver to access the data sources. When you add an ODBC Data Source Name (DSN) using the ODBC Data Source Administrator, you identify an ODBC driver for the driver manager. The driver manager then knows that the data source associated with this DSN is accessed through a particular ODBC driver.
Subscribe to:
Posts (Atom)