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
Note: If you observe any issues when executing the mentioned sql files, use the script
terminator based on the database client. If your database client shows errors for
acer_scripts_dbname.sql, create the procedures one after the
other.
Run the following scripts against the Unica Campaign database in the order listed.
Procedure
What to do next
Note: You must configure the stored procedures to run on a regular basis
to populate the staging tables. You cannot see data in the reports until you run the stored
procedures for Unica Deliver
reports.
For more information about running and scheduling the stored procedures, see For Unica Deliver only: How to schedule and run stored procedures.