Creating JDBC data sources
You must configure a JDBC data source for every HCL® EMM for which you want to enable reporting. The HCL EMM Reports SQL Generator tool must be able to connect to the HCL 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:
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.