Running examples

Preliminaries

Complete documentation to clover.ETL.

Detailed examples description.

Clover Examples zip file contains complete Eclipse project, so if you use clover.GUI you can import it to your workspace.

Prerequisites

I assume that you have downloaded a binary package of clover.ETL engine and Clover Examples or you built one from sources. Extract both zip files to the same directory.
When executing examples, You have to be in directory where you unzipped the examples. Let's assume you have extracted the archives into /home. Then when executing any example, you have to be switched in /home/cloverETL/examples (the directory where the .grf files are).

Common things

The examples presented here use various inputs and create various outputs. In general, input data is taken from files stored in data/ subdirectory. Outputs are created in output/ subdirectory and required metadata is read from metadata/ subdirectory.

In the directory with examples there is file workspace.prm with WORKSPACE parameter definition. You have to change this parameter to proper value before running graphs.

For graphs, which connect to database you have to configure connection properly . Example configuration files (koule_postgre.cfg, interbase.cfg and oracle.cfg) are included to example package.

For graph with transformation code tools.jar should be in classpath (if you use CloverGUI set it in example project properties).

To run graphs you can use scripts (run.bat or run.sh) included in examples package. They assumes that environment variable JAVA_HOME is set to java home directory. Or you can use old fashion way:

  JARSPATH="../cloveretl.engine.jar:../lib/commons-logging.jar:../lib/poi-2.5.1.jar"
  JARSPATH="$JARSPATH:../lib/commons-cli-1.0.jar:../lib/jms.jar:../lib/jxl.jar"

  JARSPATH="$JARSPATH:../lib/log4j-1.2.12.zip:../lib/javolution.jar:javaExamples"
  java -cp "$JARSPATH" org.jetel.main.runGraph -plugins ../plugins graphSimpleCopy.grf

Important notes

There is shown above how to run transformations on Linux (Unix) machine. If you have Windows installed, just change the java -cp "../cloveretl.engine.jar:../lib/commons-logging.jar:../lib/log4j-1.2.12.zip:../lib/javolution.jar:javaExamples" into -cp "../cloveretl.engine.jar;../lib/commons-logging.jar;../lib/log4j-1.2.12.zip;../lib/javolution.jar;javaExamples" - the Java classpath delimiter on Windows is ; (semicolon) not : (colon).

clover.ETL requires Java (JVM) version 1.5 or higher !

Importing examples to Eclipse

Step 1

Begin the import from the Eclipse File menu item.

Step 2

This screenshot shows the screen as it initially comes up. Select General and then Existing Project into Workspace.

Step 3

This is the next page of wizard. If you haven't extracted examples from archive, change the radio button. Then click proper Browse button to choose a directory or an archive file.

Step 4

After clicking Finish button project will import to your workspace.

Set WORKSPACE and connection parameters and you can run graphs.