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:
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
-
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.
- 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 Interact Runtime component, and then the
Interact Event Pattern ETL option under the Interact Tuntime component 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 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.