DPM settings for publishing data
After server installation, the Cognos Server configuration settings, with the exception of DispatcherUrl, are stored in DPM as illustrated below. Further updates can be applied as necessary.
The above settings all related to publishing data. The DPM settings affect the default user interface behavior.
ApplicationSettings
The
SetDefaultForQuestions property is used to determine whether the default question type is set for each question when questions are loaded in the
Metadata tab. For more information, see
Metadata tab.
CognosServers
This properties collection includes information for each Cognos server:
Property or properties collection | Description |
|---|
DisplayName | The name as displayed in list. The first instance is used in cases where duplicate display names are used. |
DispatcherURL | The Cognos dispatcher URL. |
CreatePackageInSubFolder | The sub-folder named with the project name. The default value is True. |
RootFolderInCognosContentStore | Public Folders or My Folders. |
CredentialsForLoginCognos | Anonymous (default value is True) |
| Namespace |
| UserID |
| Password |
DataSourceConnection | UseODBCDriver (default value is False) |
| WindowsAuthentication (default value is True) |
| UserID |
| Password |
RootFolderInCognosContentStore
This property is used to define the root folder in the Cognos Content Store, based on which package is created.
CreatePackageInSubFolder
This property indicates whether the package will be published to a location such as: /Public Folders/Household. When set to False, the package will be published to a location such as: /Public Folders/. The default value is True.
CredentialsForLoginCognos
This property collection provides the login credentials for each Cognos Server (credentials are required in order to connect to the Cognos service). There are two credential options:
▪Anonymous: Login without specifying a Cognos user ID or password.
▪Specify the appropriate Cognos namespace UserID and password: The UserID, password and specific Cognos namespace are required. The namespace is defined via IBM Cognos Configuration > Security.
Note When using the Anonymous option, you must ensure that the Allow anonymous access property is set to True in IBM Cognos Configuration (Security > Cognos).
DataSourceConnection
This property collection provides Cognos Data Source information for each Cognos Server in order to connect to the physical interview project-related SQL Server database.
▪UseODBCDriver: When set to False, the Cognos data source is built based on the Microsoft SQL Server 2008 Native Client. When set to True, the Cognos data source is built based on ODBC with the RDB2 database name (which is not always the same as the project ID) and must be manually built in advance. The default setting isFalse.
▪WindowsAuthentication: When set to True, the Windows account currently used by the Cognos Service is used to connect to the Microsoft SQL Server. The default setting is True.
When using this setting, you must adhere to the following requirements:
▪In Cognos Server, the Cognos Content Store should be based on the Microsoft SQL Server Database (Windows Authentication).
▪In Cognos Server, the IBM Cognos Service must be changed from Local System account to This account, and This account needs to be set as a Windows account that is used to log into the RDB2 database. The setting is located on the IBM Cognos Service’s Properties dialog via the Log On tab.
▪UserName and Password: When WindowsAuthetication is set toFalse, the Microsoft SQL Server User and Password must be used to create the Cognos Data Source sign-on. The SQL Server account should have, at a minimum, read and write permission for the related database.
▪Provider: Used to support different Microsoft SQL Server Native Client versions when creating a Cognos Data Source, and when UseODBCDriver is set to False. The property supports the following values:
▪SQLNCLI11: Based on Microsoft SQL Server 2012 Native Client
▪SQLNCLI10: Based on Microsoft SQL Server 2008 Native Client (the default value)
▪SQLNCLI: Based on Microsoft SQL Server 2005 Native Client
Note By default, the property does not appear in the DataSourceConnection property collection. If you want to alter the property value, you must manually add the property.
Cognos Dispatcher URL information
The Cognos Dispatcher URL identifies the Cognos Business Intelligence server’s External dispatcher URI, based on where the package will be published. Enter the appropriate Cognos Business Intelligence server URL (for example, http://<server_name>:<port>/p2pd/servlet/dispatch). The setting is only required when creating a Cognos package. The setting is defined in the IBM Cognos Configuration dialog: Environment > External Dispatcher URI.
Package location on the Cognos Server
Including the package name and location in the Cognos Content Store where the package is published, for example /Public Folders/HouseHold, means the package named Household is in Public Folders, and is accessible for Cognos Reporting tools.
See also
