Step: Create the IBM® Cognos® data sources for the IBM® EMM application databases

The IBM® Cognos® applications need their own data sources that identify the IBM® EMM application databases; that is, the source of the data for the reports. The IBM® Cognos® data models provided in the IBM® EMM reports packages are configured to use the following data source names:

Cognos® data sources
IBM® EMM application	Cognos® data source name(s)
Campaign	CampaignDS
eMessage	eMessageTrackDS
Interact	InteractDTDS for the design time database InteractRTDS for the runtime database InteractLearningDS for the learning database
Marketing Operations	MarketingOperationsDS
Leads	LeadsDS for the data mart tables

Use the following guidelines to create Cognos® data sources for the IBM® application databases:

Use the Administration section of Cognos® Connection.

Use the default data source names that are shown in the Cognos® data sources table. That way you can avoid having to alter the data model.

The database type you select must match that of the IBM® application database. Use the Cognos® documentation and help topics to determine how to fill out database-specific fields.

Be sure that you identify the IBM® EMM 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 IBM® EMM application database user.

Consult the Cognos® data sources table and ensure that you create all the data sources required by the data model for the reports you are configuring. For example, the reporting data for Interact is located in three databases so you must create separate Cognos® data sources for each one.

If the Campaign system has more than one partition, create separate data sources for each partition. For example, if Campaign is configured for multiple partitions, create a separate Campaign data source for each partition.

Verify that you have configured each data source correctly by using the Test Connection feature.

If you have any questions about configuring Cognos® data sources, see the IBM® Cognos® Administration and Security Guide, "Chapter 6: Data Sources and Connections" and the Cognos® online help.