Installing the ETL process

To process large numbers of event pattern ETL processes, you can install the ETL process for optimal performance. By default, the ETL process is installed when installing InteractRT.

Before you begin

Before you can install the Interact Event Pattern ETL process, you must have completed the following tasks:
  • Install a complete HCL® Interact setup, including the HCL Marketing Platform server and one or more Interact run-time servers.

    The installation process is described in detail in the Interact Installation Guide.

  • Install and configure the data source in which you want the event pattern ETL process to store its data. This may be the same data source in which the Interact runtime tables are stored, or it may be a different data source for performance reasons.
  • Collect and have available the Marketing Platform server networking information, as described in the Interact Installation Guide. You need this information during this installation process.
  • Be sure that a supported Java run-time environment is installed on the server where you are installing the ETL process.
  • Connect to the server on which you are installing the ETL process with administrator or root privileges.

About this task

When you complete this task, the files necessary to run the ETL process will be available on the server. You will still need to configure the process before you can run it.

Procedure

  1. On the server where you want to run the event pattern ETL process, copy the HCL® Marketing Software master installation program for the operating system along with the HCL Marketing Software Interact installer.
    Remember that both the master installer and the Interact installer must be in the same directory, and that you must run the installer as a user with administrator-level privileges on the server.
  2. Follow the instructions in the HCL Interact Installation Guide to launch the master installation program.
    Be sure to provide the connection information for the HCL Marketing Platform server used by your runtime servers and design time server.
  3. When the HCL Interact installer launches and displays the Interact Components page, select Interact Runtime component, and then the Interact Event Pattern ETL option under the Interact Tuntime component to install.
  4. Follow the prompts until you complete the installation.
  5. On the server where you installed the ETL process, locate the <Interact_Home>/PatternStateETL/ddl directory.
  6. Using your database management software, run the appropriate script in the DDL directory against the database that you will use as the target database for the output from the ETL process.

    The scripts in this directory create four tables in the target database that are required to use the ETL process. Depending on the target database you are using, run one of the following scripts:

    • aci_evpattab_db2.ddl if the target database is HCL DB2.
    • aci_evpattab_ora.ddl if the target database is Oracle.
    • aci_evpattab_sqlsvr.ddl if the target database is Microsoft SQL Server.

Results

You have now installed the event pattern ETL process on the server. If you accepted the default installation directory during installation, you can find the installed files in C:\IBM\IMS\Interact on a supported Microsoft Windows platform, or in /IBM/IMS/Interact on a supported UNIX-like operating system.

What to do next

To continue with the event pattern ETL process, you need to configure the process by modifying files on the ETL process server, and in the Marketing Platform configuration pages. For more information, see Configuring the ETL process.