DPM settings for publishing data

Professional > Data management scripting > Publishing data > 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.

DPM settings for publishing data

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	UsODBCDriver (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

When using the Anonymous option, 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 specific Cognos namespace are required. The namespace is defined via IBM Cognos Configuration > Security.

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 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

Note By default, the property does not appear in the DataSourceConnectionproperty collection. If you want to alter the property value, you must manually add the property.