Chapter 46

Working with Database

QTP provides built-in support to databases. Connection to the application database is required to verify the expected results against the actual results. Suppose that we are automating a retail banking Web site, and we need to validate that the transaction amount is equal to the amount debited from the debtor account. In this case, we can directly connect to the AUT database and can match the amount deducted from debtor account to the transaction amount. QTP provides the flexibility to connect to the AUT database using database checkpoint. In this chapter, we will discuss how we can connect to various databases and extract required data from them using Microsoft’s ActiveX Data Objects (ADO). ADO is an application ...

Get Agile Automation and Unified Funtional Testing now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.