Install ETLUnit for Existing ETLUnit Project

Owned by Michael Bruton (Deactivated)
May 23, 2015

ETLUnit 3.9.6

 

Draft in Progress

This document is a draft and is under development.

 

Assumptions

  • System Requirements have been met.  That means you have Maven and Git version control installed on your local computer.

Steps

  • Download the project you want to use from Bitbucket.

 

  • Package the project.

    • In the root of the ETLUnit project, open a command shell.
    • Issue the following mvn package command:

 

Maven Package Cmd
userme@LO-PPBBKK55 /c/src/etlunit-samples (master)
$ mvn clean package -DskipTests

 

  • Change your working directory to the /bin folder, then issue the etlunit command.

 

ETLUnit Command
userme@LO-PPBBKK55 /c/src/etlunit-samples (master)
$ cd bin
userme@LO-PPBBKK55 /c/src/etlunit-samples/bin (master)
$ etlunit

 

  • The ETLUnit command shell ("ClamShell") will open up.  You are ready to issue ETLUnit test commands.

 

 

ClamShell
Updating meta data . . .
Caching local copy . . .
 .d8888b.  888                         .d8888b.  888               888 888
d88P  Y88b 888                        d88P  Y88b 888               888 888
888    888 888                        Y88b.      888               888 888
888        888  8888b.  88888b.d88b.   :Y888b.   88888b.   .d88b.  888 888
888        888     :88b 888 :888 :88b     :Y88b. 888 :88b d8P  Y8b 888 888
888    888 888 .d888888 888  888  888       :888 888  888 88888888 888 888
Y88b  d88P 888 888  888 888  888  888 Y88b  d88P 888  888 Y8b.     888 888
 :Y8888P:  888 :Y888888 888  888  888  :Y8888P:  888  888  :Y8888  888 888
                                                  Command-Line Interpreter
Java version: 1.7.0_21
Java Home: c:\Java\jdk1.7.0_21-x64\jre
OS: Windows 7, Version: 6.1

userme >

 

 

 

  • Try typing the word "test" and press enter.  Do all the tests pass?

Troubleshooting

If this is your first time packaging an ETLUnit project, you may encounter dependency problems when you first issue the 'etlunit' command.

 

Dependency Problem
$ etlunit
Project is up to date
java.lang.reflect.InvocationTargetException
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
        at java.lang.reflect.Method.invoke(Unknown Source)
        at org.bitbucket.bradleysmithllc.java_cl_parser.CommonsCLILauncher.invokeMain(CommonsCLILauncher.java:1061)
        at org.bitbucket.bradleysmithllc.java_cl_parser.CommonsCLILauncher.mainWithInstance(CommonsCLILauncher.java:685)
        at org.bitbucket.bradleysmithllc.java_cl_parser.CommonsCLILauncher.main(CommonsCLILauncher.java:234)
        at org.bitbucket.bradleysmithllc.java_cl_parser.CommonsCLILauncher.mainClean(CommonsCLILauncher.java:179)
        at org.bitbucket.bradleysmithllc.etlunit.cli.CliMain.main(CliMain.java:41)
Caused by: java.lang.NoClassDefFoundError: org/apache/commons/beanutils/DynaBean
        at org.bitbucket.bradleysmithllc.etlunit.util.JSonBuilderProxy.key(JSonBuilderProxy.java:242)
        at org.bitbucket.bradleysmithllc.etlunit.cli.CliMain.go(CliMain.java:53)
        ... 9 more
Caused by: java.lang.ClassNotFoundException: org.apache.commons.beanutils.DynaBean
        at java.net.URLClassLoader$1.run(Unknown Source)
        at java.net.URLClassLoader$1.run(Unknown Source)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.net.URLClassLoader.findClass(Unknown Source)
        at java.lang.ClassLoader.loadClass(Unknown Source)
        at java.lang.ClassLoader.loadClass(Unknown Source)
        ... 11 more

 

 

  • Package the cloned etl-agent project.

 

Maven Package command for etl-agent project
userme@LO-PPBBKK55 /c/src/etl-agent/parent (master)
$ mvn clean package -DskipTests

 

  • If all goes well, the Maven dependency problem should be taken care of.  The missing jar file was downloaded and placed in your Maven repository by the mvn package command.
  • Return to your etlunit project, to the /bin folder, and try the 'etlunit' command again.

 

Try the 'etlunit' command again
userme@LO-PPBBKK55 /c/src/etlunit-samples/bin (master)
$ etlunit
Updating meta data . . .
Caching local copy . . .
 .d8888b.  888                         .d8888b.  888               888 888
d88P  Y88b 888                        d88P  Y88b 888               888 888
888    888 888                        Y88b.      888               888 888
888        888  8888b.  88888b.d88b.   :Y888b.   88888b.   .d88b.  888 888
888        888     :88b 888 :888 :88b     :Y88b. 888 :88b d8P  Y8b 888 888
888    888 888 .d888888 888  888  888       :888 888  888 88888888 888 888
Y88b  d88P 888 888  888 888  888  888 Y88b  d88P 888  888 Y8b.     888 888
 :Y8888P:  888 :Y888888 888  888  888  :Y8888P:  888  888  :Y8888  888 888
                                                  Command-Line Interpreter
Java version: 1.7.0_21
Java Home: c:\Java\jdk1.7.0_21-x64\jre
OS: Windows 7, Version: 6.1

userme >