SQL scripts by data source

Use separate SQL scripts to create views or materialized views for each data source.

The following table provides information about the scripts that you must generate for each data source, the resulting script name, and the scripts that must be run against the HCL Unica application database for creating views or materialized views:

Note:
  • The table lists the default names for the data sources and generated scripts. Your names may be different.
  • The product reporting schemas reference more than one data source. Generate a separate SQL script for each data source.
Installer placed report design files possess database connection tokens. You must update them for your system database. You must run insightsdbutil.sh/bat utility to update the same. You may have one or more data sources configurations for the report. Refer the following table for the same.
Reports Configurations
Campaign Reports CampaignDS
Interact Reports

InteractDTDS

InteractETLDS

InteractLearningDS

InteractRTDS

Plan Reports PlanDS
Deliver Reports DeliverDS
Collaborate Reports
Note: Collaborate reports are available from version 12.1.0.3 onwards.
CampaignDS

CollaborateDS

CustomerDS
The following table provides information about the scripts that you must generate for each data source, the resulting script name, and the scripts that must be run against the Unica application database for creating views or materialized views.
Note: The table lists the default names for the data sources and generated scripts. Your names may be different.

The Unica Interact reporting schemas reference more than one data source. Generate a separate SQL script for each data source.

This three-columned table provides information about the reporting schema in one column, data source (default names) in the second column, and the script name (default names).

Reporting schema Data source and default name Default script name
All Unica Campaign reporting schemas Unica 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.
Unica Deliver Mailing Performance Unica Deliver tracking tables, which are with the Unica Campaign system tables

campaignPartition1DS

Deliver_Mailing_ Performance.sql
Unica Interact Deployment History, Unica Interact Performance, and Unica Interact Views Unica Interact design time database

campaignPartition1DS

Interact.sql
Unica Interact Learning Unica Interact Learning tables

InteractLearningDS

Interact_Learning.sql
Unica Interact Run Time Unica Interact run time database

InteractRTDS

Interact_Runtime.sql