Desktop User Guides > Professional > Data management scripting > Publishing data > DPM settings for 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 shown in the following example. Further updates can be applied as necessary.
DPM settings for publishing data
This graphic is described in the surrounding text.
These settings all related to publishing data. The DPM settings affect the default user interface behavior.
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.
This properties collection includes information for each Cognos server:
Property or properties collection
The name as displayed in list. The first instance is used in cases where duplicate display names are used.
The Cognos dispatcher URL.
The sub-folder named with the project name. The default value is True.
Public Folders or My Folders.
Anonymous (default value is True)
UsODBCDriver (default value is False)
WindowsAuthentication (default value is True)
This property is used to define 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:
Login without specifying a Cognos user ID or password.
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.
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 isFalse.
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.
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 DataSourceConnectionproperty collection. If you want to change the property value, you must manually add the property.
Cognos Dispatcher URL information
Package location on the Cognos Server
Publishing data