etlTest

etlTest is a testing framework for data integration code.

The home for etlTest is on GitHub .

The goal of etlTest is to make creating and executing tests for data integration code as simple as possible. We have achieved this through the use of YAML files to store test data sets and the actual tests. Those files then get translated into Python unittests and can be executed from the command line. The results will show where there is more work to be done.

We have initially focused on unit tests, but we are planning on building out to cover other types of testing as well.

We are always looking for new feature requests, bugs, and other contributions! To learn more on how to contribute, please refer to our Contributing page. To see what is on the roadmap, please check out our Issue Board.

• 1. Introduction
  • 1.1. Overview
  • 1.2. Why etlTest?
  • 1.3. How Does It Work?
• 2. Contributing
  • 2.1. Getting Started
  • 2.2. Making Changes
  • 2.3. Submitting Changes
  • 2.4. Additional Resources
• 3. Setting Up
• 4. Configuration Settings
  • 4.1. etlTest Settings
  • 4.2. Data Connections
  • 4.3. User Properties
  • 4.4. Data Integration Tools
  • 4.5. Settings File Location
  • 4.6. Variable Replacement
• 5. Development Standards
  • 5.1. Command Line Options
  • 5.2. Sample Data Files
  • 5.3. Test Files
  • 5.4. Test Components
  • 5.5. Templates
• 6. Tutorial
  • 6.1. Preparing Your Environment
  • 6.2. Writing Your First Test
  • 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