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 already exists, it is used.
You might need to delete an existing Cognos data source if you change the information used to build the data source.
To build a Cognos data source, use one of the following methods to specify the information used:
▪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.
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