Installing the stand-alone ETL process

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 IBM® EMM installer.

Before you can install the stand-alone Interact Event Pattern ETL process, you must have completed the following tasks:

Install a complete IBM® Interact setup, including the IBM® 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.

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.

On the server where you want to run the stand-alone event pattern ETL process, copy the IBM® EMM master installation program for the operating system along with the IBM® 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 IBM® Interact Installation Guide to launch the master installation program.

Be sure to provide the connection information for the IBM® Marketing Platform server used by your runtime servers and design time server.

When the IBM® 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.

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.

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.