Stopping the stand-alone ETL process

When you launch the stand-alone ETL process on a server, it runs continuously in the background until stopped.

Open a command prompt on the server where the ETL process is installed.

Navigate to the <Interact_home>/PatternStateETL/bin directory that contains the executable files for the ETL process.

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 data sources 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.

stop. The stop command is required to stop the process. If you use this command, any ongoing ETL operation will complete before the process shuts down.

To shut down the ETL process without waiting for any ongoing operations to complete, use forcestop instead of stop.

The complete command to start the process would therefore take the following form:

command.bat -u <username> -p <password> -c <profileName> stop

The stand-alone ETL process stops.

Note 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