Running the stand-alone ETL process
When you launch the stand-alone ETL process on a server, it runs continuously in the background until stopped. The process follows the instructions in the Marketing Platform configuration properties to determine frequency, database connections, and other details during its operation.
Before you can run the stand-alone ETL process, you must have installed the process on a server, and configured both the files on the server and in the Marketing Platform correctly for your configuration.
If you are running the ETL process on Microsoft Windows for a language other than US English, use chcp at the command prompt to set the code page for the language you are using. For example, you might use any of the following codes: ja_jp=932, zh_cn=936, ko_kr=949, ru_ru=1251 and for de_de, fr_fr, it_it, es_es, pt_br, use 1252. To ensure proper character display, use the chcp command in the Windows command prompt prior to launching the ETL process.
After you have installed and configured the stand-alone ETL process, you are ready to launch the process.
1.
2.
Navigate to the <Interact_home>/PatternStateETL/bin directory that contains the executable files for the ETL process.
3.
Run the command.bat file (on Microsoft Windows) or command.sh file (on UNIX-like operating systems) with the following parameters:
*
-u <username>. This value must be a valid Marketing Platform user, and you must have configured that user with access to the TargetDS and RuntimeDS datasources that the ETL process will use.
*
-p <password>. Replace <password> with the password matching the user you specified. If the password for this user is blank, specify two double quotes (as in -p ""). The password is optional when you run the command file; if you omit the password with the command, you are prompted to enter it when the command runs.
*
-c <profileName>. Replace <profileName> with the exact name you specified in the Marketing Platform in the Interact | PatternStateETL configuration you created.
The name you enter here must match the value you specified in the New category name field when you created the configuration.
*
start. The start command is required to start the process.
The complete command to start the process would therefore take the following form:
command.bat -u <username> -p <password> -c <profileName> start
The stand-alone ETL process runs, and continues to run in the background until you stop the process or until the server is restarted.
The first time you run the process, the accumulated event pattern data may take a considerable amount of time to run. Subsequent times that the process runs will work with only the most recent set of event pattern data and will take less time to complete.
Be aware that you can also provide the help argument to the command.bat or command.sh file to see all available options, as in the following example:
command.bat help