6. The etlTest Tutorial

This is a walk through is intended to assist new users in writing, generating, and executing tests for data integration code. We have tried to keep topics specific to each function of the tool in their own section. This guide assumes that etlTest has been installed on the environment that the tutorial is being performed on. Please refer to the installation instructions found on the Setup page if etlTest has not been installed.

For the purposes of this tutorial, we will assume you have access to the following:

• Local MySQL instance (software is available from MySQL )
• Local Pentaho Data Integration instance (software is available from SourceForge )
• Database built using the etlUnitTest_build.sql script, found in the scripts directory of where etlTest is installed, or from the Sample Database Script page
• Sample data integration code, found in the samples/etl directory of where etlTest is installed (user_dim_jb.kjb and user_dim_load_tr.ktr)

In addition, while you are free to make any modifications to directory locations, we will be using the defaults found in the sample settings files.

• 6.1. Preparing Your Environment
• 6.2. Writing Your First Test
  • 6.2.1. What to test for?
• 6.3. Creating A Sample Data set
• 6.4. Configuring Your Data Integration Tool
• 6.5. Generating Test Code
• 6.6. Executing Your Tests
• 6.7. Sample Database Script