Claims:We Claim:
1. A method of automatically generating test data for testing applications, said method comprising:
determining, by a test data generator, a plurality of test cases based on a plurality of test scenarios, wherein the plurality of test scenarios is created by analyzing requirements of one or more testing applications;
generating, by a test data script generation framework of the test data generator, a plurality of test data scripts associated with the plurality of test cases;
executing, by the test data generator, the plurality of test data scripts on a first test data source to obtain a plurality of test data, associated with the plurality of test cases, from the first test data source based on successful execution;
executing dynamically, by the test data generator, the plurality of test data scripts on a second test data source to obtain the plurality of test data from the second test data source, if the execution of the plurality of test data scripts on the first test data source is determined to fail; and
updating, by the test data generator, the first data source with the plurality of test data obtained from the second test data source.

2. The method as claimed in claim 1, wherein the step of generating the plurality of test data scripts comprises one or more steps of:
receiving the plurality of test cases in an input file having a current file format;
converting the plurality of test cases into a corresponding plurality of test cases having a predetermined standard file format, having text and data segregated from the converted plurality of test cases;
mapping the segregated data with one or more data requirements; and
generating the plurality of test data scripts associated with the mapped data requirements.

3. The method as claimed in claim 1, wherein the step of executing the plurality of test data scripts on the second test data source, comprising the steps of:
accessing, using an Open Data Source framework of the test data generator, the second test data source that comprises a one or more other test data sources, wherein each of the one or more of other test data sources is either a relational or a non-relational type test data source;
generating one or more individual Application Program Interface (API) adaptors for interfacing with each of the one or more other test data sources;
converting the plurality of test data scripts into a query capable of obtaining the plurality of test data from each of the one or more other test data sources using the one or more individual API adaptors
executing the query on each of the relational and non-relational type test data source of the one or more other test data sources to obtain the plurality of test data; and
updating the first test data source with a plurality of test data obtained from execution of the query on each of the one or more other test data sources upon execution of the query.

4. The method as claimed in claim 1, wherein the first test data source is a centralized data repository and the second test data source is an open data repository, wherein the open data repository comprises at least web services, messaging queue, virtual databases and other related databases.

5. A system for automatically generating test data for testing application, said system comprising:
a processor;
a first data source coupled with the processor and configured to store a plurality of test data, databases and schemas; and
a memory communicatively coupled to the processor, wherein the memory stores processor-executable instructions, which, on execution, cause the processor to:
determine a plurality of test cases based on a plurality of test scenarios, wherein the plurality of test scenarios is created by analyzing requirements of one or more testing applications;
generate a plurality of test data scripts associated with the plurality of test cases;
execute the plurality of test data scripts on the first test data source to obtain a plurality of test data, associated with the plurality of test cases, from the first test data source based on successful execution;
execute dynamically the plurality of test data scripts on a second test data source to obtain the plurality of test data from the second test data source, if the execution of the plurality of test data scripts on the first test data source is determined to fail; and
update the first test data source with the plurality of test data obtained from the second test data source.

6. The system as claimed in claim 5, wherein the processor is configured to generate the plurality of test data scripts by performing the steps of:
receiving the plurality of test cases in an input file having a current file format;
converting the plurality of test cases into a corresponding plurality of test cases having a predetermined standard file format, having text and data segregated from the converted plurality of test cases;
mapping the segregated data with one or more data requirements; and
generating the plurality of test data scripts associated with the mapped data.

7. The system as claimed in claim 5, the system further comprises an Open Data Source framework, coupled with the test data generator, capable of obtaining the plurality of test data from the second data source, wherein the second test data source comprises one or more other test data sources, wherein each of the one or more other test data sources is either a relational or a non-relational type test data source.

8. The system as claimed in claim 7, wherein the open data source framework comprises at least:
one or more individual Application Program Interface (API) adaptors for executing the plurality of test data scripts from each of the one or more other test data sources; and
a virtual database for temporarily storing the plurality of test data obtained based on execution of the plurality of test data scripts.

9. The system as claimed in claim 5, wherein the processor is configured to execute the plurality of test data scripts on the second test data source by performing the steps of:
accessing, using the Open Data Source framework, the second test data source that comprises the one or more other test data sources;
generating the one or more individual API adaptors for interfacing with each of the one or more other test data sources;
converting the plurality of test data scripts into a query capable of obtaining the plurality of test data from each of the one or more other test data sources using the one or more individual API adaptors
executing the query on each of the relational and non-relational type test data source of the one or more other test data sources to obtain the plurality of test data; and
updating the first test data source with a plurality of test data obtained from execution of the query on each of the one or more other test data sources in upon execution of the query.

10. The system as claimed in claim 5, wherein the first test data source is a centralized data repository and the second test data source is an open data repository, wherein the open data repository comprises at least web services, messaging queue, virtual databases and other related databases.

Dated this September 30, 2016

Swetha SN
Of K&S Partners
Agent for the Applicant
, Description:FIELD OF THE DISCLOSURE
The present subject matter is related, in general to automated testing of computer applications, and more particularly, but not exclusively to a method and a system for automatically generating test data for testing computer applications.