To process large numbers of event pattern ETL processes,
you can install the ETL process on a standalone server for optimal
performance. You install the stand-alone ETL process using the regular HCL®
EMM installer.
Before you begin
Before you can install the stand-alone 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 stand-alone ETL process will be available on the server. You will
still need to configure the process before you can run it.
Procedure
- On the server where you want to run the stand-alone event
pattern ETL process, copy the HCL
EMM master
installation program for the operating system along with the HCL
EMM 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.
- 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.
- When the HCL Interact installer
launches and displays the Interact Components page, select only the Interact Event Pattern ETL option to install.
- Follow the prompts until you complete the installation.
- On the server where you installed the ETL process, locate
the <Interact_Home>/PatternStateETL/ddl directory.
- 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 IBM 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\EMM\Interact on a supported Microsoft Windows platform, or in /IBM/EMM/Interact on a supported UNIX-like operating system.
What to do next
To continue with the stand-alone 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 stand-alone ETL process.