Tosca Data-Driven Testing with Excel and TDS

 Tosca Data-Driven Testing with Excel and TDS (Test Data Service)

Data-Driven Testing (DDT) in Tricentis Tosca allows testers to execute the same test case multiple times with different sets of input data. This helps increase test coverage and reduces duplication of test cases. You can perform DDT using sources like Excel files or Tosca Test Data Service (TDS).


🔁 What is Data-Driven Testing in Tosca?

A testing approach where test logic is separated from test data.


The same test case is executed multiple times using different data rows.


Ideal for regression, form validation, and boundary value testing.


📁 Method 1: Data-Driven Testing with Excel

✅ Steps to Use Excel in Tosca

1. Prepare Your Excel File

Create an Excel sheet with columns as variable names and rows as data values.


Example:


Username Password

user1 pass1

user2 pass2


2. Import Excel as TestSheet

Go to Modules in Tosca.


Right-click → Scan Excel (or use Tosca Excel Engine).


Import the Excel file as a TestSheet module.


3. Create a Test Case Template

Right-click your test case → Convert to Template.


Use {=ExcelColumnName} to reference Excel values in the test steps.


4. Link Excel Data to Template

Create a TestCase → Right-click → Create TestCase from Template.


Select the Excel TestSheet as the data source.


5. Run the Tests

Each row in the Excel file will run as a separate iteration.


☁️ Method 2: Data-Driven Testing with Tosca TDS (Test Data Service)

TDS is Tosca's built-in test data management service for storing and managing dynamic test data centrally.


✅ Steps to Use TDS in Tosca

1. Enable TDS

Make sure TDS is installed and configured on your system.


2. Create TDS Data Sheet

Go to TCM → Test Data Management → Test Data Sheets.


Create a new sheet and define columns and data records.


3. Create a TestCase Template

Just like with Excel, use {=ColumnName} to map the test data variables.


4. Link TDS Sheet to Template

Create a TestCase from Template.


Choose the TDS data sheet as the data source.


5. Execute Tests

Each TDS row generates a separate test case instance.


🔍 Excel vs TDS: Which Should You Use?

Feature Excel Tosca TDS

Ease of use Very easy, familiar format Centralized, scalable

Version control Manual Integrated

Scalability Limited Enterprise-grade

Team collaboration Manual sharing Central access via Tosca

Automation Requires Excel Engine Native integration


🧠 Summary

Tosca supports DDT through both Excel and TDS.


Use Excel for simple, quick scenarios.


Use TDS for centralized, scalable, and maintainable test data management.


Templates and dynamic values allow for efficient reuse and scalability of tests.

Learn Tosca Training in Hyderabad

Read More

Tosca Steering Parameters: Use Cases and Tips

Working with Tosca Parameters (Buffer, Dynamic Expressions)

Tosca Templates and TestStep Design Patterns

Dynamic Test Cases with Tosca’s TestCase Design

Visit Our IHUB Talent Training Institute in Hyderabad

Get Directions

Comments

Post a Comment

Popular posts from this blog

How to Install and Set Up Selenium in Python (Step-by-Step)

 Here’s your step-by-step guide to installing and setting up Selenium in Python — perfect if you're just getting started with browser automation. 🚀 🐍 Step 1: Install Python If you haven’t already: Download Python: https://www.python.org/downloads/ Make sure to check the box "Add Python to PATH" during installation Verify installation: bash Copy Edit python --version pip --version 📦 Step 2: Install Selenium Library Open your terminal or command prompt and run: bash Copy Edit pip install selenium To verify: bash Copy Edit pip show selenium 🌐 Step 3: Download WebDriver for Your Browser Depending on what browser you want to automate: 🔹 Chrome: Download ChromeDriver: ➡️ https://sites.google.com/chromium.org/driver/ Make sure the driver version matches your installed Chrome version. 🔹 Firefox: Download GeckoDriver: ➡️ https://github.com/mozilla/geckodriver/releases Unzip and place the executable somewhere on your system, like: Windows: C:\WebDrivers\ Mac/Linux: /usr/local...
Read more

Feeling Stuck in Manual Testing? Here’s Why You Should Learn Automation Testing

Feeling Stuck in Manual Testing? Here’s Why You Should Learn Automation Testing Are you feeling like your manual testing career is hitting a ceiling? You’re not alone. Many QA professionals start their careers in manual testing but soon realize the need to level up. If you’re wondering what’s next, automation testing might just be the breakthrough you need. Why Manual Testing Isn’t Enough Anymore Manual testing is essential, especially in exploratory, usability, and ad-hoc testing scenarios. But as applications grow more complex and development cycles become shorter, manual testing can’t keep up. Companies are looking for faster, more efficient testing methods—and that’s where automation comes in. Here are a few signs that you're stuck in manual testing: Repeating the same test cases for every build Working on tight deadlines with limited test coverage Seeing peers move ahead with automation skills Lack of growth in responsibilities or pay scale If any of this sounds familiar, it...
Read more

A Beginner's Guide to ETL Testing: What You Need to Know

A Beginner's Guide to ETL Testing: What You Need to Know Introduction: Understanding the Importance of ETL Testing Have you ever wondered how data gets from one place to another in a way that is both reliable and accurate? What happens when that data is transferred and transformed between systems? The answer lies in the ETL (Extract, Transform, Load) process, a crucial part of data management in many industries. But, how do we ensure that data is being handled correctly in this intricate process? Enter ETL testing. ETL testing is vital for ensuring that your data pipeline is working as expected. But as a beginner, where do you start? What should you focus on? This guide will answer these questions and more, helping you build a solid foundation for mastering ETL testing. Whether you're a data engineer, quality assurance professional, or anyone working with data, this article will provide insights into how ETL testing works, why it's important, and the best practices you need...
Read more