SQL scripts by data source
Use separate SQL scripts to create views or materialized views for each data source.
- 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 |