Performing Post-Installation Setup Manually

This section describes how to perform ATG Campaign Optimizer setup tasks If you used CIM to set up ATG Campaign Optimizer, the database schemas have already been created and the data sources configured, so you do not need to follow the procedures in this section.

Creating the Database Schema for the ATG Campaign Optimizer Server

Follow these steps to create the database tables required by the ATG Campaign Optimizer server.

  1. If you haven’t done so already, create the database tables for the ATG Adaptive Scenario Engine. For instructions, see the Configuring Databases and Database Access chapter in the ATG Installation and Configuration Guide.

  2. Run the following SQL scripts in your production database:

    <ATG9dir>/CampaignOptimizer9.3/ABTest/sql//database/

    abtest_tracking_ddl.sql
    abtest_markers_ddl.sql
    abtest_metrics_ddl.sql
    abtest_reporting_ddl.sql

    If you installed ATG Campaign Optimizer for Commerce, run the following SQL scripts in your production database:

    <ATG9dir>/DCSCampaignOptimizer9.0/ABTest/sql/database/

    abtest_dcs_reporting_ddl.sql
    abtest_dcs_metrics_ddl.sql

  3. Run the following SQL Scripts in your publishing database:

    <ATG9dir>/CampaignOptimizer9.3/ABTest/sql//database/

    versioned_abtest_ddl.sql
    abtest_preview_ddl.sql
    abtest_markers_ddl.sql
    abtest_metrics_ddl.sql

    If you installed ATG Campaign Optimizer for Commerce, run the following SQL script in your publishing database:

    <ATG9dir>/DCSCampaignOptimizer9.0/ABTest/sql/database/

    versioned_dcs_abtest_ddl.sql

Configuring the ATG Campaign Otpimizer Server Data Source

The ATG Campaign Optimizer server relies on the database instance configured for the underlying ATG Content Administration system. (This database stores the versioned test assets checked in to the ATG Content Administration system. It also stores the profiles of ATG Content Administration and ATG Campaign Optimizer users.) Initially, the ATG Content Administration system uses the default ATG data source. If you haven’t already done so, you need to reconfigure this data source so it points to a production-quality database. For more information, see the ATG Content Administration Programming Guide.

Importing the Initial ATG Campaign Optimizer Data

To import the initial ATG Campaign Optimizer data into your database:

  1. Make sure your DYNAMO_HOME and JAVA_HOME environment variables are set. DYNAMO_HOME should point to <ATG9dir>\home and JAVA_HOME should point to the JDK root directory (C:\Program Files\Java\jdk1.5.0_16, for example).

  2. If you haven’t done so already, import the initial ATG Content Administration data. See the ATG Content Administration Programming Guide for instructions.

  3. Run the following ATG Campaign Optimizer script:

<ATG9dir>/CampaignOptimizer9.0/ABTest/management/install/
importABTestManagement.{bat|sh}
 
loading table of contents...