Jump to content

Submissions/Fitnesse – an UAT tool beyond compare for ETL testing

From Wikimania 2010 • Gdańsk, Poland • July 9-11, 2010


This is an open submission for Wikimania 2010.

Title of the submission
Fitnesse – an UAT tool beyond compare for ETL testing
Type of submission (workshop, tutorial, panel, presentation)
Author of the submission
Ashwin Kumar I R
E-mail address or username (if username, please confirm email address in Special:Preferences)
Country of origin
Affiliation, if any (organization, company etc.)
Personal homepage or blog

Fitnesse – an UAT tool beyond compare for ETL testing

In an era where ETL testing needs more emphasis on data transformations, removing the redundancy of data, validating the data that needs to be/are loaded into the tables or databases and the definition of the columns that is stored in the table, there needs to be some superior verification and validation tools that can verify and validate the records that would be loaded. Especially working in an Agile environment, it requires the verification and validation to be at the Top Class level, because for some businesses data is the source of currency.

Fitnesse – derived from the term FIT. The fully integrated standalone wiki, and acceptance testing framework (courtesy - http://fitnesse.org/). This is an UAT tool based on Ward Cunningham’s Framework for Integrated Test. This User Acceptance Testing tool is one of or may be the best tool that can be used for ETL (Extract Transform and Load) testing. Fitnesse enables the customers, users, developers and testers to write sentence like tests which can be mapped with the requirements. And the Verification and Validation is made easy because it uses Wiki as its front end as Fitnesse is an IDE.

Comparing Fitnesse with one of its counterpart Selenium would be a huge discussion in itself. As a brief comparison, In ETL testing, Test Suites and Test Cases in Selenium are written using HTML and the same in Fitnesse using Wiki. Interfaces, functions, assert commands, etc., can be implemented using both Fitnesse and Selenium. However, using Fitnesse would provide an additional comfort, since Wiki is used as its front end and proper coverage in testing the ETL application, since sentence – like tests can be used in mapping the requirements, Colors marking the success/failure of a test marks its capability as an ease of use UAT testing tool.

Track (People and Community/Knowledge and Collaboration/Infrastructure)
Knowledge and Collaboration - Semantic Wikis
Will you attend Wikimania if your submission is not accepted?

Not Sure, Can't afford to make.

Slides or further information (optional)

Would share the presentation provided my Abstract being selected.

Interested attendees

If you are interested in attending this session, please sign with your username below. This will help reviewers to decide which sessions are of high interest. Sign with four tildes. (~~~~).

  1. Add your username here.

--Gorka 12:26, 4 May 2010 (UTC)[reply]