The Cognos® applications need their own data
sources that identify the source of the data for Unica application reports.
About this task
The Cognos data models that are provided in the
Unica reports packages are configured to
use the data source names that are given in the following table:
Table 1. Cognos data sources This two-columned table provides information
about the Unica application in one column, and the Cognos data source names in the second column.
Unica application |
Cognos data source
names |
Unica Campaign |
CampaignDS |
IBM eMessage |
eMessageTrackDS
|
Unica Interact |
- For the design time database: InteractDTDS
- For the runtime database: InteractRTDS
- For the learning database: InteractLearningDS
- For the ETL database: InteractETLDS
|
Unica Plan |
PlanDS |
Unica Collaborate |
- For the Unica Collaborate database:
CollaborateDS
- For the customer database: CustomerDS
- For the Unica Campaign database:
CampaignDS
|
For more information about configuring Cognos data
sources, see IBM
Cognos Administration and Security Guide and the Cognos online help.
Use the following guidelines to create Cognos data
sources for the HCL application databases.
Procedure
-
Use the Administration section of Cognos
Connection.
-
Use the default data source names that are shown in the Cognos data sources table to avoid having to alter the data model.
-
The database type that you select must match that of theHCL application database. Use the
Cognos documentation to determine how to fill
database-specific fields.
Note: For Unica Campaign and IBM eMessage, the appropriate database is Unica Campaign.
-
Be sure that you identify the Unica
application database and not the Cognos content
store.
-
When you configure the Signon section, select the
Password and Create a Signon that the Everyone group can
use options.
-
In the Signon section, specify the user credentials for the Unica application database user.
-
Consult the Cognos data sources table and ensure that
you create all the data sources that are required by the data model for the reports you are
configuring.
For example, the reporting data for Unica Interact is in three databases, so you must create
separate Cognos data sources for each database.
-
If the Unica Campaign system has more than one
partition, create separate data sources for each partition.
For example, if Unica Campaign and IBM eMessage are configured for multiple partitions, create
a separate Unica Campaign and IBM eMessage data source for each partition.
-
Verify that you configured each data source correctly by using the Test
Connection feature.