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:

    <ATG10dir>/CampaignOptimizer10.1/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 with Commerce Extensions, run the following SQL scripts in your production database:

    <ATG10dir>/DCSCampaignOptimizer10.1/ABTest/sql/database/

    abtest_dcs_reporting_ddl.sql
    abtest_dcs_metrics_ddl.sql

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

    <ATG10dir>/CampaignOptimizer10.1/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:

    <ATG10dir>/DCSCampaignOptimizer10.1/ABTest/sql/database/

    versioned_dcs_abtest_ddl.sql

Configuring the ATG Campaign Optimizer 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.

Configuring the External Profile Repository Data Source

If you have not done so already, configure the data source used by the external profile repository on the asset management (ATG Content Administration) server so that it points to the database on the production server.

For detailed information, see Configuring Profile Repository Data Sources in the ATG Business Control Center Administration and Development Guide for detailed information.

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 <ATG10dir>\home and JAVA_HOME should point to the JDK root directory (C:\Program Files\Java\jdk1.6.0_18, 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:

<ATG10dir>/CampaignOptimizer10.1/ABTest/management/install/
importABTestManagement.{bat|sh}