Creating JDBC data sources

You must configure a JDBC data source for every IBM® EMM for which you want to enable reporting. The IBM EMM Reports SQL Generator tool must be able to connect to the IBM EMM application databases to generate SQL scripts that create reporting tables. The SQL Generator can generate SQL scripts that create views or materialized views without access to the application databases. However, the SQL generator cannot validate the SQL without a data source connection.

About this task

When you configure JDBC data sources, use the default JNDI name that is listed in the following table:

Table 1. Default JNDI names

This two-columned table provides information about the HCL application in one column, and the default JNDI name in the second column.

HCL application	Default JNDI name
Campaign	campaignPartition1DS If there are multiple partitions, create a data source for each partition.
Interact	+ campaignPartition1DS for the design-time database InteractRTDS for the runtime database InteractLearningDS for the learning tables

If you do not use the default JNDI names, make a note of the names that you use. You must specify the correct name of the data source when you run the SQL Generator tool.

If you need more help with this task, see the application server documentation.