Step: Create and populate the Optimize system tables manually, if necessary

If the Optimize installer could not connect with the Campaign system tables during the installation process, you see an error message that notifies you of this failure. The installation process proceeds, but in this case you must create and populate the Optimize system tables manually.

To create and populate the Optimize system tables, run the SQL scripts listed in this section against the database or schema that holds the Campaign system tables.

The SQL scripts are located in the ddl directory under your Optimize installation.

If your Campaign system tables are configured for unicode, use the appropriate script located in the ddl/unicode directory under your Optimize installation.

Scripts for creating Unica® Optimize tables
Data source type	Script name
IBM® DB2®	aco_systab_db2.sql
Microsoft™ SQL Server	aco_systab_sqlsvr.sql
Oracle	aco_systab_ora.sql

There is only one script to populate the Optimize tables, aco_populate_tables.sql. There is no unicode equivalent script for the aco_populate_tables.sql script used to populate the tables.