Keyword Driven Excel Based Approach

High Level Framework Architecture Design

 

Objective:

 

Using this framework approach you can configure your test scenarios; test data, repository and keywords from excel sheets. Therefore it will be very easy to maintaining your scripts and object repository in future and it does require less efforts.

No need to maintain large size QTP shared repository more you can maintain your objects in excel sheet.

I have divided this approach into three different layers.

1. AUT – more specific to application and having the following components.

          1. App Config (Application Configuration)

          2. App Scenarios (Define your scenarios in Excel Sheet)

          3. App Test Data (Define your test data in Excel Sheet)

          4. QTP Keywords / Actions (Define your keyword in .vbs file)

          5. Repository (Define your application objects details in Excel Sheet)

2. Framework – core layer of this framework approach and having the all the reusable functions for accessing the web or window based objects. This layer also has the reusable functions for driver script, custom reporting and provide in built recovery.

3. Utilities – under this layer you can developed reusable functions for other utilities like FTP, QC and Outlook etc based on your requirements.

Object Repository Design Architecture:

QTP Keyword / Action Design (.vbs file):

Custom Report Design:

Thanks You,

Mehul Kagathara

Test Scenarios Design: