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
- 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
-
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.
- aci_evpattab_ifx.sql if the target database is OneDB.