SQL scripts by data source
The following table shows which scripts you need to generate for each data source, the resulting script names and, for creating views or materialized views, which script should be run against which IBM® Unica® application database. Note the following.
*
The table lists the default names for the data sources and the generated scripts, which you might have changed.
*
The Interact reporting schemas reference more than one data source. Generate a separate SQL script for each data source.
Reporting schema
Data source (default names)
Script name (default names)
All Campaign reporting schemas
Campaign system tables
(campaignPartition1DS)
Campaign.sql, unless you generated separate scripts for each reporting schema. If you did, each script is named after the individual schema.
eMessage Mailing Performance
eMessage tracking tables, which are with the Campaign system tables
(campaignPartition1DS)
eMessage_Mailing_ Performance.sql
Interact Deployment History, Interact Performance, and Interact Views
Interact design time database
(campaignPartition1DS)
Interact.sql
Interact Learning
Interact Learning tables
(InteractLearningDS)
Interact_Learning.sql
Interact Run Time
Interact run time database
(InteractRTDS)
Interact_Runtime.sql
Copyright IBM Corporation 2012. All Rights Reserved.