it_user891201 - PeerSpot reviewer
Sr Consultant at CGI
  • 14
  • 614

What is the best automation tool to test dynamic data?

Hi community,

We are using Smartbear TestComplete but tried Ranorex as well. It is capturing some parts of data but because the data is constantly changing the script is failing as it couldn't find that particular field. We then need to export this data to excel. 

Any suggestions? 


PeerSpot user
19 Answers
it_user1054566 - PeerSpot reviewer
Enterprise Software Account Manager at Micro Focus
Real User
Jun 10, 2019

Have them look at Micro Focus Unified Functional Test solution and speak with a Solution Engineer for exact use case.

Search for a product comparison in Functional Testing Tools
Digital Sales Account Manager for Application Development Management (ADM) at Micro Focus
Real User
Jun 10, 2019

UFT (Unified Functional Testing) would be the best option given the information because it is best suited for developing perpetually changing data/products. But, I’d like to know what kind of data they are looking to export out to Excel.

Senior Digital Business Consultant at HNRG
Jun 10, 2019

In my opinion, Microfocus UFT (Unified Functional Testing) is the right tool for your need and the most valuable tool for Testing Automation.

Senior Automation Test Analyst at Sage Software Australia
Real User
Jun 10, 2019

If we leave "Best Automation Tool" aside first, you can design and build the test framework with the ability of a performing data-driven test (which can read test data from or export data to data source (Such as excel file or database table). You can achieve this using the data driver module build-in in Test Complete or other tools, even can achieve this by using a free tool, such as Selenium/Java.

If the name of specific objects, XPath or controls keep changing, then you will have to find out the rule to follow the changes and achieve the control detecting by advanced script kill.

Content and Social Media Manager at Ranorex
Jun 10, 2019

The latest release of Ranorex Studio introduced a machine-trained algorithm for handling dynamic elements. If you tried an older version, you might want to get a free trial of the new version and see if that resolves the issue for you.

CEO at Appvance
Jun 10, 2019

Appvance's Test designer has self-healing for dynamic accessors. It will fix the scripts by itself as accessors change from build to build using machine learning. It also has the ability to create scripts by itself to add to yours. https://www.appvance.ai

Learn what your peers think about Tricentis Tosca. Get advice and tips from experienced pros sharing their opinions. Updated: February 2023.
687,256 professionals have used our research since 2012.
Managing Director at a tech services company with 11-50 employees
Real User
Top 10
Jun 10, 2019

Dynamic handling is very good with AscentialTest and SilkTest.

Following are the things to be followed:

a. Type of application you are looking on, does the tool support it?
b. Dynamic data needs to be handled at runtime.
c. AscentialTest and SilkTest have a built-in reference operator which helps in handling dynamic objects and also dynamic data.
d. Dynamic Data can be read into a Variable and can be easily written into Excel using the ODBC connectors.
e. Excel comparison and verification is simpler.

Chief Executive Officer at Zeenyx Software
Jun 10, 2019

AscentialTest from Zeenyx Software will have no problem with dynamic data.

Jun 10, 2019

The best one I would suggest is to use Cucumber web driver javascript (Node js) open source framework.
Following are the reasons:-
1. Use of regular expression to find an object
2. You can also find an object using regular expression in 'css' and to be precise you can drill down the tree and find the object with that regular expression for multiple attributes
3. Export in excel/csv etc is very quick and easy in Node js. You can also use npm packages which will ease your way of developing and maintaining
code and extracting into any form will become a minutes job.
4. Moreover, Node js is very powerful compared to any other tool, be it a paid one. I have been using Node js for Microsoft CRM testing and it is
promisingly good. Eventually, the react native thing which most of the applications are implementing now like FB, Netflix, Amazon, etc is a Node js
thing. So upgrading the tests to a react native app testing will be easy as well.

The first two points above will keep your page object recognition method intact and you don't need to change it every now and then. You can use the
same approach elsewhere in your code. I have an open source Cucumber js framework which I use for my current project (https://github.com/DEFRA/waste-permits-integration-tests). I am in a process to create a sample one as well, which anybody can pick up and
start using.

If you can send me the DOM examples of the object you are trying to find, I can send you the sample of the page object definition in JavaScript using a
regular expression.

Test Manager/ QA Consultant at Aspire Systems
Real User
Jun 10, 2019

Is the dynamic data occurring in a web table? In that case, we can use the column headers as keys and fetch all elements inside the table and assign into a list/collection and then iterate them to find the data we require. It's regardless of tools, its just logic we build as a business with reusables.

Jan 17, 2020

We have tested Katalon, UFT, SmartBear, and Ranorex. We much prefer Ranorex.

Director at Inflectra Corporation
Jun 10, 2019

Disclaimer: I work for Inflectra that makes this product. Take a look at Rapise from Inflectra, it has special support for dealing with web applications with changing data and elements. See https://www.inflectra.com/Rapise/ we have free trials and our test automation consults are happy to assist.

FFox - PeerSpot reviewer
Real User
Jun 10, 2019

I use AscentialTest and it will have no problem handling dynamic data. One question, why do you want o export the test data?

Strategic Sales and Marketing Consultant with 10,001+ employees
Jun 10, 2019

Give Dotcom-monitor a try. They use Rich Internet application, so you can use images to validate the page. Your script will work. Also, they have free tech support. Would need to know more details to be sure.

Real User
Jun 11, 2019

ZAPTEST Free edition: https://www.zaptest.com/zaptest-free-edition

reviewer797424 - PeerSpot reviewer
User at Testsigma
Jun 10, 2019

Data is a key element in automation testing. In most cases, people automate testing to test the application with multiple dynamic data sets. You need to select a tool that has inbuilt Test Data Management.

Testsigma (https://testsigma.com) is one such tool. It's a cloud-based test automation testing tool with all the essential elements for end to end testing. It also has a free trial option to try out before you make a decision.

Freelancer - Global Trainer & Consultant for Test Automation at Freelancer
Jun 10, 2019

Every dynamic data can be read using Smartbear's TestComplete. If you wish to read dynamic data, you should use a descriptive method like FindChild in which you can add an array of properties except for text property and read the text after the object is identified.

it_user1004163 - PeerSpot reviewer
SR. Business Process Partner, Commercial Operations at GSK at a pharma/biotech company with 10,001+ employees
Real User
Jun 10, 2019

With Worksoft Certify, we have set up automated data verification tests that check the environment that we want to run the automated test scripts in. Most of those tests just provide a list of data that is missing in the environment that we then have to manually set up in the environment. We have at least one test though that automatically adds the data what is. We can jump environments to auto-test in, from QA to UAT to Staging, run the data verification tests first, get the environment set up, and then run our auto-test cases in that environment.

These automated data verification tests save us a great amount of time in terms of test environment set-up (few hours vs. several days).

Assistant Vice President Sales at TestingWhiz
Jun 10, 2019

TestingWhiz comes with a smart inbuilt Object repository, which allows a user to save the most important back end properties of an object, like Alias, Name, ID, Inner HTML, Xpath, CSSPath and so on, to recognize the elements while executing the test cases. To help you in understanding how it can be used for handling the dynamic changes in data, could you provide some details on what application type you would like to do automation for or on what is the back end language of that application?

Related Questions
Development Specialist at a healthcare company with 1,001-5,000 employees
Jun 3, 2021
I'm working for a company with 1000+ employees and I'm exploring two products: Panaya and Tricentis.  How good is Panaya Test Dynamix in comparison with Tricentis?  Thank you!
2 out of 4 answers
Key Account Manager at a manufacturing company with 10,001+ employees
May 11, 2021
Panaya and Tricentis are both good. Could you share more info on your use case and what are your key selection criteria ?
Director of Community at PeerSpot (formerly IT Central Station)
May 22, 2021
@Jesús Antonio Santos Giraldo ​, can you please share more details about your case as suggested by @John ​so that our peers can assist you with your queston?
Software Development Analyst at Huntington Ingalls Industries
Aug 16, 2021
I'm looking for the best test automation tool for SAP. We have about 600 users and the tests are mostly functional. I see that in a lot of reviews Worksoft is the most popular choice but is it the best and reasonably priced product?
See 1 answer
General Manager Customer Success at a tech services company with 51-200 employees
Aug 16, 2021
Reasonably priced is an interesting term. I'd suggest looking at TCO as a better metric and include the cost of both building and maintaining the automated test suite.  Tricentis Tosca is now a part of the SAP product list and the SP developers are using it to test their own releases. Tosca is replacing the SAP CBTA tooling and the companion product LiveCompare is replacing SAP's Component Analyser. Google "SAP Tricentis Partnership" for details.
Related Articles
Ariel Lindenfeld - PeerSpot reviewer
Director of Community at PeerSpot
Aug 21, 2022
We’re launching an annual User’s Choice Award to showcase the most popular B2B enterprise technology products and we want your vote! If there’s a technology solution that’s really impressed you, here’s an opportunity to recognize that. It’s easy: go to the PeerSpot voting site, complete the brief voter registration form, review the list of nominees and vote. Get your colleagues to vote, too! ...
Related Categories
Related Articles
Ariel Lindenfeld - PeerSpot reviewer
Director of Community at PeerSpot
Aug 21, 2022
PeerSpot User's Choice Award 2022
We’re launching an annual User’s Choice Award to showcase the most popular B2B enterprise technol...
Download Free Report
Download our free Tricentis Tosca Report and get advice and tips from experienced pros sharing their opinions. Updated: February 2023.
687,256 professionals have used our research since 2012.