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 Unica Interact setup, including the Unica Platform server and one or more Unica Interact run-time servers.

    The installation process is described in detail in the Unica 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 Unica Interact runtime tables are stored, or it may be a different data source for performance reasons.
  • Collect and have available the Unica Platform server networking information, as described in the Unica 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 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.
  2. 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.
  3. 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.
  4. Follow the prompts until you complete the installation.
  5. On the server where you installed the ETL process, locate the <Unica 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.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.
    • aci_evpattab_ifx.sql if the target database is OneDB.

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.