Test Data Generation – Demo Using a Free Online GEDIS Studio Tool (Part -2):
Read part-1 of the test data management tutorials series here.
According to CA Technologies, recent research indicates that 30%- 40% of the defects in software testing are related to the issues of the test data. It is one of many reasons that encourages QA industry to use Test Data Generation (TDM) tools.
TDM tools offer an open-handed facility for having system generated, reliable and secure copies of your dataset in just minutes.
Additionally, TDM tools positively impact the process of rapid and quality software development life cycle and the testing life cycle with specifications like:
- Remarkably enhances the speed of data subset and synthetic data creation.
- Create full production clones reducing your manual effort and time.
- Provides an on-demand workspace and self-service platform for testers, developers, management, and DB administrators to avoid data corruption and time delays.
What You Will Learn:
Test Data Generation Using a Free Online Tool
By applying TDM tools in the field of software testing, you lay the foundation for contributing beyond expectations in making the test cycles release faster. Automating the process of your high volume of required data enhances the efficient use of the application development time. Likewise, you proficiently mitigate slow and complicated data setup with the generation of synthetic data.
Refer to figure-1 of the graphic interface of IBM InfoSphereOptim TMD for better visualizing the whole process of Test Data Management.
Figure1: IBM InfoSphereOptim TMD Graphic Interface
From a cost-efficiency point of view, the use of TDM tools has a direct impact on the cost as:
- Data integration with Test Management Tools
- Minimizing manual efforts in due process of data setup for testing
- Adequately available data for re-usability
- QA teams become more productive, which leads to better human resource management
- Improvements in defect resolution by Development & Data
In part-2 of the test data management tutorial series, we are going to learn about the Automated Test Data Generation process with GEDIS Studio free Online Tool.
Introduction to GEDIS Studio Online
GEDIS Studio is a free online test data management and data generator tool. Its unique features of more than 30 test data generation rules for producing test data, control of the distribution of values, correlation of values, and many other useful possibilities to aggressively test your application under the test with realistic data sets and the large data simulation.
GEDIS Studios can design your generation in a short span of time and give you the platform for organizing well the production of your test data. For any given AUT test case data, we require realistic test data to ensure the thoroughness of our overall testing.
Therefore, we always look at having access to sufficient test data from the production environment and applying Personally Identifiable Information making without harming the practical nature of the data, and identify further requirements of test data for your designed test cases.
Using GEDIS Studio, you will enjoy managing and generating your test data by having the following advantages:
- Realistic Data Production
- Highly Useful for Data display and analysis
- Efficient Platform for Generating SQL, HTML, XML, CSV Script and Data.
The use of GEDIS Studio provides you with an environment where you can operate beyond data generation in areas such as shown below:
- Populate your database based on your testing requirements
- Prepare a realistic testing environment for your AUT
- Automation of data production as per demand
- Production of direct importing formats for Oracle, DB2, MySQL and many other RDMS.
Additionally, GEDIS extends the completeness of your testing by:
- Produce bulk data for the unit, functional and load tests.
- Execution of data-driven testing (QTP/UFT, Selenium or TestPartner).
Access & Registration
As of now, we have gone through what GEDIS does with its unique features. You can generate your test data online even without installing any application on your computer. Once you register your account, then you can right away start working with GEDIS Studio.
GEDIS Studio allocates a personal workspace on its servers. It also provides you with sample projects and reference data that you can import into your workspace to generate data for your own needs.
You can create your account as you press the button “Register” by clicking on this link www.data-generator.com. Then enter all the fields in the registration form and hit “Submit” button.
[NOTE – Click on any image for an enlarged view]
Once you have completed the registration process, GEDIS sends you the confirmation for your account registration along with the login name and the password that you can use to log into the GEDIS Studio online.
After you log into GEDIS Studio, your workspace is empty and you can either create a project or import your project from the existing data located on your workspace page on the configuration panel. When you have a project, you can insert your generator and can add any number of fields that you may need according to your data specification.
GEDIS provides the toolbar like any other application for quick access of its users to major features such as creating project components or your workspace manager. You can browse generators and find fields from “Design” explorer, and you can browse for your batches and the files from “Production” explorer located on the left side of the GEDIS Studio application.
On the right side of the GEDIS Studio application, you have the configuration panel for your project components, the workspace manager, and the help views. The workspace manager displays data from shared and private workspaces for your projects, generators, batches and other data files.
To change the rule in a particular field, select it in the design explorer and double click on the new rule from the rule’s selector.
According to the default model, all the root fields of the generator automatically get added to the “output” file.
Other features of the data display can be in CSV tables or plain text. And by clicking on your “Workspace” tab on the right side of “Design” and “Production” tabs of the application, it displays a page containing the four sub-tabs like “Projects,” “Generators,” “Output” and “Data”.
Under the tab “Projects” there are two folders, one the system generated and the other is “GenieLog.” As you double click on any of the “Projects” or “Generators,” you can import them into your own workspace. GEDIS Studios has made this data available to its users to operate the tool.
As we covered to an extent the introductory part of the GEDIS Studio main page, let’s have a quick tour of generating test data step by step.
Test Data Generation
1) As you are on “Design” tab, click on “Create a New Project” button located on the toolbar. By doing so, you can create a new the New Batch and Default.txt at the same time.
2) On “Documentation” tab, located on the bottom part of the of the application’s right side, click and give your new project the name. In this tutorial, you will see a project called “Open EMR.”
3) Once you have created and named your project, you can “Add Field” from the toolbar. For instance, here we add two fields for “Name” and “Credit Card Number” from the documentation part of the tool on the right side.
4) To apply Data Generation Rule based on our data needs, click on the field “Name” first. Then, click on the tab “Rules” and select the generation rule “Test File Extraction.”
5) When you select the Text File Extraction rule, you can browse to link the name data made available by GEDIS for you. When you click on the browse button where it says FILE, you select the name file from the folder “Names” located in the folder “GenieLog”.
6) Click on your created field “Credit Card Number,” for selecting rule “Credit Card,” which will produce the credit card numbers.
7) When you design rules for two given fields, you click on “Production” tab. This page will show you that the Open EMR project has the “New Batch” and the “Default.txt”.
You can specify what data you need to generate by filling in tabs like NB Records, where you add the number of records.
Here, for example, we put the number of 100 records to be generated:
8) After you complete the data specifications that you need, you click on “Generate” button. Here in the screenshot, you can see in the CSV Viewer format the number of 100 names and the bank account numbers generated based on the required criteria.
Data Correlation and Cross-Dependency
This GEDIS Studio online feature enables you to design generators where you require data correlation.
For example, we generate a dataset of two columns for “Name” and “Country,” where the names are generated in correlation to the population of each country of the world.
In order to do so,
- We created the project Open EMR and added two fields of “Name” and “Country” in the tab of “Design”.
- Select the “Text File Extraction” as the generator rule for the field of “Name”.
- Then, you select the available file data from the folder of name by browsing on the field of the “File”.
- Similarly, you select the generator rule of “Text File Extraction” and navigate to pick up data from the country from the path as ‘Localization/World-Countries-Populations.txt’.
- When you are done with designing rules for two given fields, you click on “Production” tab. This page will show you that your Open EMR project has the “New Batch” and the “Default.Txt”.
- You can specify what data you need to generate by filling in tabs like NB Records and add the number of records that you need for both fields. Here, for example, we put the number 200 records to be generated.
- After you have completed the data specifications that you need, you click on “Generate” button. The screenshot below displays in CSV Viewer format the number of 200 names, country, each country population, areas and density as per the given conditions for test data generation. The population distributed inside the generated test data is the same as a real-world population distribution on Earth.
Parameterization using GEDIS Studio
This parameter is one of GEDIS database testing tool’s most efficient test data generation functions. By using parameters, you can set various generators of different data values for your production.
So, having the option to work with parameters helps you out in the reuse of your different data generators in real-life projects where you have multiple users.
Now, let’s create two parameterized generators with two different values for the address and the family names starting with F in our Open EMR project. As we have already created an Open ERM project along with its two fields of “Name” and “Country”.
- You click on the “Production” tab where you would add both the mentioned parameters
- Click on “default.txt” located in the batch of your Open EMR
- By clicking on “Parameters” tab located between the tabs of “Documentation” and “Rules,” the system displays the parameters page.
- Add a parameter and name it “Address”
- Browse to select the address file from the folder “Words” by clicking on the folder icon located on the right side of your added parameter
- After you select your Address file, you can click either on the button of “View Your File as CSV” or the button of “View Your File as Text”
- You will need to take the same steps to add a new parameter for the Names Starting with F.
There are two added parameters that you can use to work on one of them as you may need for your testing as shown in the screenshot.
In addition to the illustrated features in this tutorial in the context of the Open EMR project, GEDIS Studio provides you with the facilities of working in a broader spectrum of test data generation and test data management.
They are mentioned below:
- Manage your Non-Regression Testing
- Use your Generated Test Data from Import/Export
- Creating Test Data without using GUI for GEDIS Studio
You can access the GEDIS tutorial for your practice and use it by clicking here.
Automated Testing Data Generation tools
Because of the tremendous need we have for test data throughout the process of our software testing, there are different kinds of test data automated generation tools available in the market.
By going through GEDIS Studio as one of the many test data automated tools, we found out that we can create original data in almost any database or text file.
These tools enable us to:
- Creating realistic and meaningful data to complete application testing;
- Introduce any domain specific data for testing;
- Applying personally Identifiable Information (PII) legislation by masking confidential values;
- Applications are delivered rapidly to customers by avoiding manual, time-consuming data creation;
- Automation of thousands of customers, products and account items with different attributes of their ID, email, name, etc.
For your comparative analysis of the listed Test Data Management Tools, here we collected most of the tools available in the market.
=> If you are interested in going through top TDM tools, please read this tutorial.
Here is the list of TDM tools:
- CA Test Data Manager (Datamaker)
- Compuware’s Test Data Management
- Data factory
- Data generator
- Datanamic Data Generator MultiDB
- Delphix Test Data Management
- Double Test data management
- DTM Data Generator
- E-Naxos DataGen
- EMS Data Generator
- GEDIS Studio Online
- GS data generator
- HP Test Data Management
- Informatica Testing Data Management tool
- InfoSphereOptim Test Data Management
- Lisa Solutions for Test Data
- Original Test Data Management
- Redgate SQL Data Generator
- SAP test data migration server
- Solix EDMS Test Data Management
- Upscene Advanced Data Generator
- YDE Data Generator
By using any TDM automated tool, we immensely raise the quality of our functional and performance testing.
These tools help us in providing sufficient data coverage, quicker delivery, cost-efficiency, fewer data related defects, and maximized learning opportunities throughout the testing process.
This tutorial provides you with a list of twenty-nine Automated Test Data Generation tools that you can go through and find the right TDM tool ensuring you have the provision of your required test data. Being exposed to many different numbers of TDM tools will enable you to choose the appropriate one after your re-evaluation of each testing cycle.
We decided to illustrate the major features of GEDIS Studio Online. This tool is available online so that you can have access by having the sample data and many rules for initiating your test in no time.
If you need a free automation tool that does not require you to go through the installation and the database connection, GEDIS is one of them.
Feel free to generate test data using this tool. Let us know if you have any queries. If you want us to cover any other test data management tools, please let us know.