How to run cloverETL From command line

CloverDX Platform
1

Hi

I have a cloverETL project. I am able to run the code from Netbeans without any problem.

I want to configure the same to run from command line. In order to do that I want to setup the logs to be written to a file instead of command window.

In a Nutshell how do I run the project using command line.

Thanks,
Naveen

2

Hi Naveen,

Running CloverETL graphs from command line is pretty straightforward. In your CloverETL installation, there is a batch file clover.bat (for Windows) or clover (for Linux) which you can use to run the graph provided as an argument. If you run the script without any parameters, it prints out syntax. For example in the open-source engine, the path to the batch file is cloverETL/bin/clover.bat relative to your CloverETL Engine installation.

With regards to configuring the logging output, there are basically two options:

  • redirect the standard output of the batch file to the desired output file

  • configure log4j appender to write the output directly to the desired logging file. Please find a sample configuration file attached. You just need to add

-logcfg log4j.properties

to clover.bat arguments. Detailed documentation on customizing the log4j logging is available at http://logging.apache.org/log4j/1.2/manual.html

log4j.properties


# An example log4j configuration file that outputs to System.out and specified file.
# The output information consists of relative time, log level, thread
# name, logger name, nested diagnostic context and the message in that
# order.

# For the general syntax of property based configuration files see the
# documentation of org.apache.log4j.PropertyConfigurator.


# This options sets the finest level of messages being output
log4j.rootLogger=INFO, Console, File

log4j.logger.org.apache=WARN
log4j.logger.httpclient=WARN
log4j.logger.org.apache.commons.httpclient=WARN

log4j.javax.jms=WARN
log4j.javax.management=WARN
log4j.org.apache=WARN

# Console is set to be a ConsoleAppender which outputs to System.out. 
log4j.appender.Console=org.apache.log4j.ConsoleAppender
log4j.appender.Console.layout=org.apache.log4j.PatternLayout
log4j.appender.Console.layout.ConversionPattern=%-5p [%t] - %m%n

# File is set to be a ConsoleAppender which outputs to selected file. 
log4j.appender.File=org.apache.log4j.FileAppender
log4j.appender.File.file=clover.log
log4j.appender.File.layout=org.apache.log4j.PatternLayout
log4j.appender.File.layout.ConversionPattern=%-5p [%t] - %m%n

Regards,
Jan