Vsts for testers Reading Notes (6)

4. Edit webtest
4. Data Binding
Data Binding
1. Executing a data-driven test is an important aspect of an appropriate load test, because the test is more authentic than the real-world activities, it also helps ensure effective use of server cache and other resources. By using data binding, You can bind data from the source database to a part of a request that requires data, for example, to the form sending parameters of a request. You can click "add data source" to bind data to the database.
2. Use the ole db data source for data binding, including. CSV files, Excel, access, and SQL Server databases. The TXT file can also be used for data binding according to a certain format.
3. Attributes
Set creden
Querystring Parameters
Form field parameters
Request URL
Add Data Binding
1. You can use data binding in Web Testing to enable the database to act as a data source for user input involving HTTP requests in Web Testing. For example, you can store a list of login names and logon passwords for repeated logon attempts during Web testing.

2. You can check the test and decide which part of the test you want to be tested as a data-driven test. Then you can create a data source for this part of the test, such as the access database containing data. Data can be bound to multiple locations in the web test.
You can add data bindings from two locations:
A. add data binding for a query string parameter or form publishing form

B. Add the following content directly in a shortcut:

3. Access Method
When bound to a data source, Team edition for testers supports sequential access, random access, and unique access to records in the database.
Sequence
Starting from the first record, it passes through the entire table row by row. This is the default setting. This access method passes the data in the table in sequence during the duration of the load test.
Random
Random Access between rows in the table. This access method passes the data in the table in sequence during the duration of the load test.
Unique
Data is accessed row by row in sequence, but each record is accessed only once. Non-circular access.
The access method is set in properties:

When your web test is compiled into a load test and runs on a remote rig, you must consider how each proxy machine uses the bound data. For example, when four proxies are used, if the access method is sequential or random, each proxy (rather than each virtual user) will obtain a complete copy of the dataset, in addition, This dataset will be shared among all virtual users created on this proxy. However, if the access method is unique, the dataset is divided between the four proxies.