CODEWITHSUNDEEP
testingautomationdb2etldata-warehouse
Anto
Anto

Reputation: 83

DataWarehouse test automation

What is the best way and what tools are available to automate testing of stored procedures (run in sequences during the ETL process by a scheduler) in a large data warehouse environment?

Upvotes: 0

Views: 1941

Answers (2)

AngocA
AngocA

Reputation: 7693

Automate testing in DB2's SQL PL can be done with the unit testing framework https://github.com/angoca/db2unit. This framework allows you to deal with database basic data types; however, you can create your own assertions and add them in the framework.

If you find it useful but you need more features, you can create an issue explaining what you need.

I am the main developer of that project, and I am looking new ways this project can be used.

Upvotes: 0

ekostadinov
ekostadinov

Reputation: 6940

This area is quite broad for a single answer post. I'm currently responsible for such ETL/DW tests, so I'll share my experience. My approach is to spin the Test framework around the used by our DEVs tool. The QA approach can be found all over the Web, but sadly no common Test framework is there out-of-the-box. Take a look at this and this. Another useful thing is the checklists like this one or this one. Last but not least you can use such frameworks like tSQLt for the MS SQL

automate testing of stored procedures

Actually the domain knowledge is the most important part here.

Upvotes: 1

Related Questions