cognosimport Node Properties

The IBM Cognos BI source node imports data from Cognos BI databases.

Example

node = stream.create("cognosimport", "My node")
node.setPropertyValue("cognos_connection", ["http://mycogsrv1:9300/p2pd/servlet/dispatch",
 True, "", "", ""])
node.setPropertyValue("cognos_package_name", "/Public Folders/GOSALES")
node.setPropertyValue("cognos_items", ["[GreatOutdoors].[BRANCH].[BRANCH_CODE]", "[GreatOutdoors]
.[BRANCH].[COUNTRY_CODE]"])

Table 1. cognosimport node properties
`cognosimport` node properties	Data type	Property description
`mode`	`Data` `Report`	Specifies whether to import Cognos BI data (default) or reports.
`cognos_connection`	["string",flag,"string", "string" ,"string"]	A list property containing the connection details for the Cognos server. The format is: `["Cognos_server_URL", login_mode, "namespace", "username", "password"]` where: `Cognos_server_URL` is the URL of the Cognos server containing the source. `login_mode` indicates whether anonymous login is used, and is either `true` or `false`; if set to `true`, the following fields should be set to `"".` `namespace` specifies the security authentication provider used to log on to the server. `username` and `password` are those used to log on to the Cognos server. Instead of `login_mode`, the following modes are also available: `anonymousMode`. For example: `['Cognos_server_url', 'anonymousMode', "namespace", "username", "password"]` `credentialMode`. For example: `['Cognos_server_url', 'credentialMode', "namespace", "username", "password"]` `storedCredentialMode`. For example: `['Cognos_server_url', 'storedCredentialMode', "stored_credential_name"]` Where `stored_credential_name` is the name of a Cognos credential in the repository.
`cognos_package_name`	string	The path and name of the Cognos package from which you are importing data objects, for example: `/Public Folders/GOSALES` Note: Only forward slashes are valid.
`cognos_items`	["field","field", ... ,"field"]	The name of one or more data objects to be imported. The format of field is [namespace].[query_subject].[query_item]
`cognos_filters`	field	The name of one or more filters to apply before importing data.
`cognos_data_parameters`	list	Values for prompt parameters for data. Name-and-value pairs are enclosed in square brackets, and multiple pairs are separated by commas and the whole string enclosed in square brackets. Format: [["param1", "value"],…,["paramN", "value"]]
`cognos_report_directory`	field	The Cognos path of a folder or package from which to import reports, for example: `/Public Folders/GOSALES` Note: Only forward slashes are valid.
`cognos_report_name`	field	The path and name within the report location of a report to import.
`cognos_report_parameters`	list	Values for report parameters. Name-and-value pairs are enclosed in square brackets, and multiple pairs are separated by commas and the whole string enclosed in square brackets. Format: [["param1", "value"],…,["paramN", "value"]]