DPM settings for publishing data

After server installation, the Cognos Server configuration settings, with the exception of DispatcherUrl, are stored in DPM. Further updates can be applied as necessary.

These settings all related to publishing data. The DPM settings affect the default user interface behavior.

The SetDefaultForQuestions property determines whether the default question type is set for each question when questions are loaded in the Metadata tab. For more information, see Metadata tab.

This properties collection includes information for each Cognos server:

The name as displayed in lists. The first instance is used in cases where duplicate display names are used.

The sub-folder named with the project name. The default value is True.

This property specifies the root folder in the Cognos Content Store, based on which package is created.

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.

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. You must ensure that the Allow anonymous access property is set to True in IBM Cognos Configuration (Security > Cognos).

▪Specify the appropriate Cognos namespace UserID and password: The userID, password, and Cognos namespace are required. The namespace is defined by clicking IBM Cognos Configuration > Security.

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.

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 is False.

When set to True, the Windows account currently used by the Cognos Service is used to connect to the Microsoft SQL Server.

When using this setting, you must follow these requirements:

▪In Cognos Server, the Cognos Content Store must 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 on the Log On tab of the IBM Cognos Service's Properties dialog.

The default setting is True.

When WindowsAuthetication is set to False, the Miscrosoft 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.

Used to support different Microsoft SQL Server Native Client versions when creating a Cognos Data Source, and when UseODBCDriver is set toFalse. 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

By default, the property does not appear in the DataSourceConnection property collection. If you want to change the property value, you must manually add the property.

The Cognos Dispatcher URL identifies the Cognos Business Intelligence server’s External dispatcher URI, based on where the package will be published. Enter the Cognos Business Intelligence server URL, for example:

http://<server_name>:<port>/p2pd/servlet/dispatch

The setting is required only when creating a Cognos package. The setting is defined in the IBM Cognos Configuration dialog: Environment > External Dispatcher URI.

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.