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 Unica master installation program for the operating
system along with the Unica
Unica Interact installer.
Remember that both the master installer and the Unica 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 Unica Interact Installation Guide to launch the master installation program.
Be sure to provide the connection information for the Unica Platform server used by your runtime servers and
design time server.
-
When the Unica 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 <Unica 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.sql if the target database is IBM DB2.
- aci_evpattab_ora.sql if the target database is Oracle.
- aci_evpattab_sqlsvr.sql if the target database is Microsoft SQL
Server.
- aci_evpattab_mariadb.sql if the target database is MariaDB.
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:\HCL\Unica\Interact on a supported Microsoft Windows platform, or in
/HCL/Unica/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 Platform configuration pages. For more information, see Configuring the ETL
process.