Hybrid Framework Flow: Keyword + Data-Driven

 Functional Regression Testing using a Hybrid Framework

  1. Combines Keyword-driven and Data-driven techniques.
  2. Likely built for Web UI automation.

Breakdown:

MS Access (RUNCHART Table)

  • Test execution summary is stored in a table (RUNCHART).

  • Fields like RUNID, SCN_ID, SCN_DESCRIPTION, EXECUTED_BY, etc.

  • Tags like Regression and execution status are tracked.

  • Indicates test case execution tracking and reporting is handled through MS Access database.


Java Code (Eclipse – ScenarioStepGenerator.java)

  • Code is preparing and executing SQL queries to fetch test scenario steps.

  • Interacts with tables like SCN_FUNC_BATCHING and SCN_STEPS_AUTOMATION.

  • Implements logic to insert/update test steps dynamically.

  • Core automation engine is Java-based and fetches test steps dynamically using scenario IDs.

  • JDBC is used for database connection and query execution.



 

Excel (Object Repository)

  • Excel file (iDataSyncr) is used as UI Object Repository.

  • Fields like SCREEN_NAME, FIELD_NAME, TYPE, and LOCATOR suggest it holds element locators for test scripts.

  • Indicates the use of a data-driven approach to identify elements from Excel at runtime.

  • Shows integration between UI field management and the test automation engine.



Summary of Technologies Used:


Component

Details

Programming Language

Java

Test Design Approach

Keyword + Data-driven

Data Source

MS Access DB + Excel

Execution Control

Database-driven test step management

Test Type

Functional Regression Testing

UI Element Storage

Excel-based Object Repository

IDE

Eclipse

Framework Type



Sample Test Execution Flow Example

Scenario ID: SCN_001 – Login Test

Step
Field Name
Keyword
Test Data
1
Username
InputText
admin
2
Password
InputText
admin123
3
LoginBtn
Click
-
4
HomeLabel
VerifyText
Welcome


 Execution Steps:

  1. Framework reads SCN_001 test steps from the database.

  2. For each step, it pulls the locator from the Excel Object Repository.

  3. Executes keyword action using Selenium (e.g., InputText calls sendKeys()).

  4. Records result and moves to the next step.

  5. At the end, updates run status in RUNCHART table.

Hybrid Automation Framework












Comments

Post a Comment

Popular posts from this blog

Beginner’s Guide to Setting Up Mobile Automation for Android

 Mobile automation has become a crucial part of modern software QA. With mobile apps used for banking, travel, e-commerce, education, and more, ensuring reliable performance on real devices is essential. This blog walks you through the core steps required to set up a mobile automation environment for Android , covering device configuration, tool setup, environment variables, and basic inspection techniques. 1. Install Java (JDK 8u111 Recommended) Mobile automation tools rely heavily on Java. Start by downloading: Java SE Development Kit (JDK 8u111) After installation, configure the environment variable: Set JAVA_HOME Open Environment Variables on your system. Under System Variables , click New . Add: JAVA_HOME = C:\Program Files\Java\jdk1.8.0_111 Edit the Path variable and add: %JAVA_HOME%\bin This ensures Java commands run globally on your machine. 2. Install Android Studio Android Studio includes the Android SDK , which is required for automation tools t...
Read more

Which Framework is Best: Data-Driven or Keyword-Driven?

  Keyword-Driven Framework Best for teams with mixed skill levels (non-coders + testers). Easier to maintain in the long run. Ideal when application changes often —you only update keywords, not scripts. Needs more time and effort to set up initially. Data-Driven Framework Best when test data changes frequently but test logic stays the same. Suitable if your team is comfortable with coding . Less complex than keyword-driven but harder for non-programmers to contribute. ✅ When to Choose What Scenario Recommended Framework Team has non-programmers Keyword-Driven Frequent data changes Data-Driven Need long-term maintainability Keyword-Driven Small team with coding skills Data-Driven Application updates often Keyword-Driven
Read more