Specifying information used to build the IBM Cognos data source
The IBM Cognos server requires a Cognos data source in order to access UNICOM Intelligence RDB2 data. The Publish Data activity creates a Cognos data source for the project if one does not already exist. For example, if you use the Publish Data activity to make a project named Museum available to Cognos, a new data source named Museum will be created if a Museum data source does not already exist. If a Museum data source is already present, the existing data source is used.
Note You may need to manually delete an existing Cognos data source if you change the information used to build the data source.
There are three methods for specifying the information used to build a Cognos data source:
▪When the IBM Cognos server is hosted on a Microsoft Windows operating system, and the existing Content Store type is Microsoft SQL server, use Windows Authentication in the Microsoft SQL Server native client.
Note Windows Authentication in the Microsoft SQL Server native client is the most common method for specifying the information used to build a Cognos data source.
▪When the IBM Cognos server is hosted on a Microsoft Windows operating system, but the Content Store type is not Microsoft SQL Server, use SQL Server Authentication in the Microsoft SQL Server native client.
▪When the IBM Cognos server is not hosted on a Microsoft Windows operating system, use SQL Server Authentication with an ODBC driver.
Microsoft SQL Server 2008 native client must be installed on the IBM Cognos server when using the first or second options. Microsoft SQL Server 2008 native client must be installed separately if another version of Microsoft SQL Server is already installed on the IBM Cognos server.
See also