Development And Implementation Of Data Integration GUI/SDK Automation Testing Framework Based On Groovy

Oracle Data Integration is an enterprise software system that is used to realize the ETL(Extract, Transformation and Load), which could be installed on most of the System and supports almost all RDBMS database. Besides, ODI supports a wide variety of application such as SAP and Sibel system with its rich and strong features. Meanwhile, due to its powerful features and rich user interface, it is difficult for the ODI team to delivery an extremely high quality product, and it brings the ODI testing team a great challenge that it occupies the engineer lots of time to execute the testing plan, especially, the GUI/SDK regression testing consumes the QA team lots of testing resource.To achieve these purposes, we introduce the automation framework in our daily testing work so that the automation testing could replace the manual testing to execute those regression testing. By doing this, we could release the occupied resource from the regression testing, put these released resource to the other testing tasks to enhance product's quality, it is not also helps the team to improve the testing efficiency, but also exclude the distributing factors caused by the manual testing.The thesis starts from the actual testing demand of ODI, to achieve the goal of improving the testing efficiency, guaranteeing the testing quality and reducing the testing cost by researching and implementing the GUI/SDK automation framework with groovy technology. The paper extends the automation testing to the detail GUI/SDK testing for the ODI testing purpose, states the the research direction of the paper and its feasibility, the main purpose and expected results are also given later. Establish the frameworks as a three-layer framework, and then detail describes each layer's scope, responsibility and its features. The paper also explains how to use groovy to implement the automation framework, provides some simple demos of how to develop the test script using the automation framework and how it helps engineering to simplify the process of testcase creation, the testing result report is delivered to the engineer when the automation script is completed.Eventually, prove the framework's validity and feasibility by comparing the testcase execution time of manual and automation, which also proves the ODI automation achieve the goals we set at the beginning of this paper, and the real value of the paper.