2019-06-06 15:07:00 UTC

What is the best automation tool to test dynamic data?


Right now 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? 

Thanks!

Guest
1818 Answers
Vendor

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.

2019-06-10 23:25:58 UTC10 June 19
Vendor

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

2019-06-10 19:56:33 UTC10 June 19
Real User

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.

2019-06-10 17:04:21 UTC10 June 19
Vendor

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

2019-06-10 16:37:07 UTC10 June 19
Vendor

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

2019-06-10 12:42:40 UTC10 June 19
UserTOP 20

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.

2019-06-10 11:55:04 UTC10 June 19
ConsultantTOP 5LEADERBOARD

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

2019-06-10 09:47:49 UTC10 June 19
Vendor

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.

2019-06-10 20:08:12 UTC10 June 19
Real User

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

2019-06-10 19:34:32 UTC10 June 19
Vendor

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.

2019-06-10 19:30:49 UTC10 June 19
Real UserTOP 5LEADERBOARD

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.

2019-06-10 15:10:33 UTC10 June 19
User

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.

2019-06-10 13:00:31 UTC10 June 19
Real UserTOP 5LEADERBOARD

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.

2019-06-10 08:13:31 UTC10 June 19
Real User
2019-06-11 00:46:38 UTC11 June 19
Vendor

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.

2019-06-10 15:02:41 UTC10 June 19
ConsultantTOP 5

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.

2019-06-10 14:48:05 UTC10 June 19
Real UserTOP 5

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).

2019-06-10 14:38:25 UTC10 June 19
Vendor

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?

2019-06-10 12:51:24 UTC10 June 19
Find out what your peers are saying about Worksoft, Micro Focus, Sauce Labs and others in Functional Testing Tools. Updated: September 2019.
371,062 professionals have used our research since 2012.
Sign Up with Email