Installing the Aggregation and Adjustment Service

Installing Aggregation and Adjustment

  1. Download install_ version.exe to the Aggregation and Analysis server, and then double-click the executable to launch the installation wizard. Do not extract the file to a folder structure that contains spaces.
  2. On the Choose Install Folder page, enter the installation path or click Choose to select the installation path.
  3. On the Before We Begin page, select Yes or No for the questions shown to help the installation wizard understand your installation environment. The selections do not affect whether or not the wizard installs the selected modules, but the selections allow you to enter database connection information for the selected modules.
    1. For Would you like to install or upgrade a database with this installation for either myMicros or iCare?, select No.
    2. For Will different features connect to the myMicros Database using different database IP Addresses, select Yes if you expect to use more than one IP/SID to connect to the Enterprise Back Office database. For example, select Yes in an Oracle Real Application Cluster (RAC) environment that does not use a virtual IP and when features such as Remote Transfer Agent connect to a different node. If you select No, you can still modify the connection strings, but you cannot view individual database information screens by feature.
  4. If you are performing an upgrade:
    1. On the Use existing Portal configuration page, select Yes to use the existing configurations, or select No to configure a new install set.
    2. On the Additional Features page, select No to continue using the existing set of features, or select Yes to add features to the existing install set.
  5. On the Choose Install Set page, select Aggregation and Adjustment Service.
  6. On the Choose Backup Path page, enter a folder path or click Choose and select a folder path for storing a backup of the existing installation.

    The wizard creates and names folders using incremental numbers. For example, RTA_1, RTA_2, and RTA. The latest backup folder does not have an appended number, and the wizard only stores up to three backup copies.

  7. On the Aggregation Database connection Information page, configure the connection to the Enterprise Back Office, Gift and Loyalty, and Aggregate_DB databases:
    1. Select Enable Monitor.
    2. Select Oracle or Sql Server depending on the Enterprise Back Office database type.
    3. Enter the database SID and server port for the Core database and the Aggregate_DB database.
    4. Enter the hostname for the Core database and the Aggregate_DB database.
    5. Enter the hostname, additional connection properties, and the server port for the Gift and Loyalty database.
    6. Enter login credentials to the Core and Aggregate_DB databases, typically the AGG user created during database install.
    7. Enter login credentials to the Gift and Loyalty database, typically the MMSQL user created during database install.
  8. On the Aggregation and Adjustment Configuration page, configure the database connection to the Aggregation and Adjustment service as described in the following table:

    Table 8-2 Aggregation and Adjustment Service Login

    Field Description

    Core database login and Core database password

    Enter the core database login credentials.

    RTA database login and RTA database password

    Enter the RTA database login credentials.

    Portal database login and Portal database password

    Enter the Enterprise Back Office database login credentials.

    Location Activity database login and Location Activity database password

    Enter the location activity database login credentials.

    Name for Analysis/Aggregation Instance

    Enter a unique name for this instance of the analysis/aggregation service. The service inserts the name into the database to denote which service processed a job.

    Connection Cache Type

    Select a connection cache type from the drop-down list.

  9. On the Review page, select your preferred review type:
    • Normal: Review the install folder, features, and disk space requirements.

    • Advanced: Review and edit individual variables in the installation files, then review the install folder, features, and disk space requirements.

  10. Review the log files for errors. The installation wizard writes logs to the C:\temp\ folder during installation, and to the installation path after completing installation.
  11. Connecting Reporting and Analytics to the Aggregation and Adjustment Service provides instructions for setting up Reporting and Analytics to connect to the Aggregation and Analysis service.

Connecting Reporting and Analytics to the Aggregation and Adjustment Service

  1. Download install_ version.exe to the Reporting and Analytics application server, and then double-click the executable to launch the installation wizard. Do not extract the file to a folder structure that contains spaces.
  2. On the Choose Install Folder page, enter the installation path or click Choose to select the installation path.
  3. On the Before We Begin page, select Yes or No for the questions shown to help the installation wizard understand your installation environment. The selections do not affect whether or not the wizard installs the selected modules, but the selections allow you to enter database connection information for the selected modules.
    1. For Would you like to install or upgrade a database with this installation for either myMicros or iCare?, select No.
    2. For Will different features connect to the myMicros Database using different database IP Addresses, select Yes if you expect to use more than one IP/SID to connect to the Enterprise Back Office database. For example, select Yes in an Oracle Real Application Cluster (RAC) environment that does not use a virtual IP and when features such as Remote Transfer Agent connect to a different node. If you select No, you can still modify the connection strings, but you cannot view individual database information screens by feature.
  4. If you are performing an upgrade:
    1. On the Use existing Portal configuration page, select Yes to use the existing configurations, or select No to configure a new install set.
    2. On the Additional Features page, select No to continue using the existing set of features, or select Yes to add features to the existing install set.
  5. On the Choose Install Set page, select Portal.
  6. On the Choose Backup Path page, enter a folder path or click Choose and select a folder path for storing a backup of the existing installation.

    The wizard creates and names folders using incremental numbers. For example, RTA_1, RTA_2, and RTA. The latest backup folder does not have an appended number, and the wizard only stores up to three backup copies.

  7. Follow the instructions for the installation wizard. You do not need to change values from the Reporting and Analytics installation.
  8. On the Portal Specific Settings - Aggregation and Adjustment Service page, enter the hostname and port of the server with the Aggregation and Analysis service installation.
  9. On the Review page, select your preferred review type:
    • Normal: Review the install folder, features, and disk space requirements.

    • Advanced: Review and edit individual variables in the installation files, then review the install folder, features, and disk space requirements.

  10. Review the log files for errors. The installation wizard writes logs to the C:\temp\ folder during installation, and to the installation path after completing installation.
  11. Set the Aggregation Service memory configurations for your environment.