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 generatro cannot validate the SQL without a data source connection.

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

Default JNDI names
IBM® 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 additional help with this task, see the application server documentation.