Simple use of the automatic data generation tool DataFactory

Document directory

•  

Http://www.msnshow.cn/testing/2008/20186.htm

• Simple use of the automatic data generation tool DataFactory ......

I. Introduction:

Quest DataFactory is a fast and easy-to-Generate Test Data tool that can model complex data relationships and has a GUI. DataFactory is a powerful data generator that allows developers and QA to generate millions of rows of meaningful test data effortlessly.

Ii. Working principle:

First, read the schema of the table in the database, that is, the table definition and other content, and display it in the form of a list. Then, the user customizes the specific content of the data to be generated, such as the number range, string length, number of data records to be generated, etc. Finally, run the project to generate data.

Iii. installation:

We can see that DataFactory has version 5.6 on the Internet, but here we use the 5.2 cracked version. I have not studied the differences between the two versions in detail. Interested readers can refer to the relevant information on their own.

Iv. Instructions for use:

DataFactory supports the following database types: DB2, SQL Server, Oracle, and Sybase, And the ODBC data source. This document uses ODBC as an example to describe. Before generating data, you must first set the system ODBC data source, that is, add the data source to be operated (Start> Control Panel> Management Tools> ODBC data source ). For simplicity, create an Access database DataFactory. accdb and create a customer table. Set the data source name to test, as shown in:

Figure 1:

5. Specific operations for data generation:

1. Create a project and select ODBC when adding a database

Figure 2:

2. on the "machine data source" tab, select the test data source (Figure 3). After confirmation, you will be prompted to enter the password to log on (Figure 4). If not specified, click OK. In this way, the database is successfully added (figure 5) and click OK.

Figure 3:

Figure 4:

Figure 5:

3. next, specify the project storage location (such as D:/) (Figure 6). After confirmation, the data source test will appear in the box on the left side of the interface, then, in the "database property" dialog box, select the table (customer, figure 7) to insert the generated data ).

Figure 6:

Figure 7:

4. The database and table content is displayed on the page (figure 8 ).

Figure 8:

Now, you can customize each attribute of a table and set the constraints on the attribute values (figure 9 ).

Figure 9:

In Figure 9, set the ID as an example. The optional attribute values are listed in the List.

5. After setting the attribute, set the table. Double-click customer. In the General Tab Of the displayed dialog box, you can modify the table name or set the number of data records to be generated (Figure 10 ). On the output tab, you can insert the generated data directly to the database table or output it to the file (figure 11 ).

Figure 10:

Figure 11: