For Unica Deliver only: Creating stored procedures, staging tables, and indexes
After you install or upgrade reporting templates, you must run specific SQL scripts before you generate Unica Deliver reports. The SQL scripts create stored procedures and staging tables.
About this task
- acer_indexes_dbname.sql
- acer_tables_dbname.sql
- acer_scripts_dbname.sql
Run the following scripts against the Unica Campaign database in the order listed.
Procedure
-
acer_indexes_dbname.sql
Make sure that you allow sufficient time for the script to complete. The time depends on the volume of data that is stored in the Unica Deliver system tables.
-
acer_tables_dbname.sql
This script creates the delta processing staging tables in the Unica Deliver system schema.
-
acer_scripts_dbname.sql
Important: For DB2® databases, change the termination character from ; (semicolon) to ! (exclamation point).
This script creates the stored procedures that you must configure after you install reports for Unica Deliver.
-
Navigate to Campaign\reports\tools directory, under your Campaign
installation and locate the following scripts.
- uare_lookup_create_DB_type.sql
Populate the following scripts as per your locale.uare_lookup_populate.sql
(For English)uare_lookup_populate_de.sql
uare_lookup_populate_es.sql
uare_lookup_populate_fr.sql
uare_lookup_populate_it.sql
uare_lookup_populate_ja.sql
uare_lookup_populate_ko.sql
uare_lookup_populate_pt.sql
uare_lookup_populate_ru.sql
uare_lookup_populate_zh.sql
What to do next
For more information about running and scheduling the stored procedures, see For Unica Deliver only: How to schedule and run stored procedures.