{"id":1257,"date":"2020-09-09T10:23:58","date_gmt":"2020-09-09T10:23:58","guid":{"rendered":"https:\/\/data-science.gotoauthority.com\/2020\/09\/09\/test-data-management-support-in-test-automation-development\/"},"modified":"2020-09-09T10:23:58","modified_gmt":"2020-09-09T10:23:58","slug":"test-data-management-support-in-test-automation-development","status":"publish","type":"post","link":"https:\/\/wealthrevelation.com\/data-science\/2020\/09\/09\/test-data-management-support-in-test-automation-development\/","title":{"rendered":"Test-data management\u00a0 support in Test Automation Development"},"content":{"rendered":"<div>\n<p>Data is centric in testing of several applications because data is critical to organizations. Businesses are becoming more data-driven, and hence it is imperative that as Automation Test developers, the value of the test-data is understood and\u00a0 completely harnessed during Test Automation development. The test-data involved in both Manual\/Automation testing encompasses the test-data inputs, test-data outputs, and the test-data flow.<\/p>\n<p><a href=\"https:\/\/testproject.io\/\">TestProject.io<\/a> is the world\u2019s first free cloud-based, community-powered test automation platform which caters to this important aspect of Test Automation development. The tool successfully adheres to the importance of keeping test-data centric in Automation Test solutions.<\/p>\n<p>To start with, <strong>organizing and managing test data<\/strong> is very easy in TestProject. We are aware that as an application gets bigger and more tests are added, test data management becomes more difficult. This tool allows easy and clear management of the elements, tests, parameters by helping the Automation Test Developer associate data, be as an input or output in the UI as follows:<\/p>\n<p>The tool makes the tests<strong> maintainable<\/strong> by allowing the Test data to be <strong>easily added, deleted, modified<\/strong>\u00a0 making it\u00a0 <strong>flexible<\/strong> in the perspective when business\u00a0 requirements change. It also allows test data to be associated with Web<strong>, Android and iOS apps<\/strong>, allowing <strong>several types of input <\/strong>\u2013 web pages, JSON, PDFs etc. The test data can be also tested on <strong>several browsers<\/strong> such as Chrome, Firefox, Safari, Edge, Internet Explorer.<\/p>\n<p>TestProject enables easy collaboration in a test automation team- by allowing\/dis-allowing sharing of the test cases,<strong> test data <\/strong>etc as and when applicable. Eventually the team has shareable test repository which can be easily managed and controlled.<\/p>\n<p><strong>Sharing<\/strong> of parameters is available in levels \u2013<strong>Test level and Project level<\/strong>. For example,<\/p>\n<p>Hence, because of this, the test data can be easily <strong>re-usable<\/strong>, without having to mention the same test data repeatedly in some cases.<\/p>\n<p>TestProject also has a \u201cSecret Parameter\u201d feature built in the smart test recorder that allows storing <strong>sensitive test data<\/strong> in an encrypted state.<\/p>\n<p>There are also powerful Addons available in TestProject that can help the Automation Developers complete their tasks easily and quickly .For example, there are several\u00a0 <strong>Random Data Generator Addons <\/strong>available. \u2018Random Login Credentials Addon\u2019 is one such Addon which generates random credentials to be entered for several tests.\u00a0 Similarly, there are many more Random data generators available, such as for generating random dates, character\/word\/number etc as per several requirements. This definitely makes the job of an Automation developer much easier, and helps save time.<\/p>\n<p>In TestProject, we can <strong>choose<\/strong> the input data source to be <u>the <strong>default input parameters<\/strong><\/u> or to be <strong>associated with the <u>data- driven method<\/u><\/strong> as follows :<\/p>\n<p>The <strong>Data-driven Testing<\/strong> method of testing is necessarily important in cases when the coverage<strong> of any data variable <\/strong>comes into picture<strong>.<\/strong> We are aware that Data driven tests are tests that run multiple times, but with different values for some of the variables in the test. For example if you wanted to test that the username field on a login page could handle several different types of inputs you could create a separate test for each input, or you could use a data driven tests to drive the same login test multiple times, but just using a different username input each time. We are aware that Data-driven Testing is a very good approach if you have huge volumes of data to be tested for the same scripts.<\/p>\n<p>One such support for Data driven testing in this tool is the <strong>Parameterization<\/strong> of variables. Once the parameters are added, like in the screenshot below, the parameter can be navigated to and picked for use.<\/p>\n<p>In order to run a \u2018<strong>Data-driven\u2019 test<\/strong>, the Automation Developer would need to associate the test with various <strong>Data Sources<\/strong>. One such example is as follows, where the Developer can associate the test with the input CSV data source as follows:<\/p>\n<p>Since Testproject supports Data-driven test development, it results in <strong>stronger Test Coverage<\/strong>. That is, large volume of data can be managed and executed thereby improving <strong>regression<\/strong> testing and better coverage.<\/p>\n<p>Speaking about data sources, Testproject also provides addons that help to work with several database as PostgreSQL, MySQL, MSSQL, Db2, Oracle. The tool can be easily linked with the databases by providing details as:<\/p>\n<p>All this also shows the fact that the tool <strong>clearly separates the test cases and the test data<\/strong> and hence allows testers to test their applications using different data values and parameters without the need for changing test script\/cases. While making a change in data sets such as addition, or deletion, doesn\u2019t have implication with test cases.<\/p>\n<p>Also, once the test is generated by the Automation developer, it can be viewed both in the \u2018Manual Test\u2019 view or the \u2018Test document\u2019 view. In both cases, once either of the options are chosen and they are downloaded, the test data is clearly mentioned in their respective columns in the documents.<\/p>\n<p>For example, the \u2018Manual Test\u2019 document that gets generated automatically shows the Test Data used as,<\/p>\n<p>And, the \u2018Test\u2019 document that gets generated automatically shows the Test Data\u2019s default values used as,<\/p>\n<p>While assesing the test results,\u00a0 the tool clearly gives details on failures, helping the automation developer to easily debug the issue\/ decide to open a defect. For example, the details are clearly showed as :<\/p>\n<p><a href=\"https:\/\/testproject.io\/\">TestProject.io<\/a> tool can also be easily integrated with many other tools, such as Jenkins, qTest, Slack etc, and the testcases\/test data etc are easily synced during this association. Example, in the cases of Jenkins, we can associate the build step by linking it with the TestProject data source as follows :<\/p>\n<p>Eventually, TestProject has emerged as a powerful test Automation framework, having very attractive features especially to the fact that it imparts the value of Test-data being centric in the\u00a0 Automation Test tasks. Along with the fact that the tool supports the ideology of having the test-data to be the driving base to the whole Test Automation framework process, it\u00a0 also enables sharing and syncing with other teams and tools during the development, management and execution of the Test Automation Solution.<\/p>\n<div id=\"author-bio-box\">\n<h3><a href=\"https:\/\/data-science-blog.com\/en\/blog\/author\/danm\/\" title=\"All posts by Dan M\" rel=\"author\">Dan M<\/a><\/h3>\n<div class=\"bio-gravatar\"><img loading=\"lazy\" src=\"https:\/\/data-science-blog.com\/en\/wp-content\/uploads\/sites\/4\/2020\/09\/Dan_Martin-80x80.jpg\" width=\"70\" height=\"70\" alt=\"Dan M\" class=\"avatar avatar-70 wp-user-avatar wp-user-avatar-70 alignnone photo\"><\/div>\n<p class=\"bio-description\">Dan has hands-on experience in digital marketing since 2007. He has been building teams and coaching others to foster innovation and solve real-time problems. Dan also enjoys photography and traveling.<\/p>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>https:\/\/data-science-blog.com\/en\/blog\/2020\/09\/09\/test-data-management-support-in-test-automation-development\/<\/p>\n","protected":false},"author":0,"featured_media":1258,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[2],"tags":[],"_links":{"self":[{"href":"https:\/\/wealthrevelation.com\/data-science\/wp-json\/wp\/v2\/posts\/1257"}],"collection":[{"href":"https:\/\/wealthrevelation.com\/data-science\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wealthrevelation.com\/data-science\/wp-json\/wp\/v2\/types\/post"}],"replies":[{"embeddable":true,"href":"https:\/\/wealthrevelation.com\/data-science\/wp-json\/wp\/v2\/comments?post=1257"}],"version-history":[{"count":0,"href":"https:\/\/wealthrevelation.com\/data-science\/wp-json\/wp\/v2\/posts\/1257\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/wealthrevelation.com\/data-science\/wp-json\/wp\/v2\/media\/1258"}],"wp:attachment":[{"href":"https:\/\/wealthrevelation.com\/data-science\/wp-json\/wp\/v2\/media?parent=1257"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wealthrevelation.com\/data-science\/wp-json\/wp\/v2\/categories?post=1257"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wealthrevelation.com\/data-science\/wp-json\/wp\/v2\/tags?post=1257"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}