Patent ID: 8306998

Claim:
A method for recording an interaction with a database, comprising: displaying a database selection page presenting a plurality of databases for receiving selection of one of the databases; displaying a single connection information page for receiving connection parameters of the selected database which are to be used for connecting to the database, wherein the connection parameters capable of being received by the single connection information page are based on the selected database, such that in response to selection of a first database the single connection information page requests a first set of connection parameters, and in response to selection of a second database the single connection information page requests a second set of connection parameters different from the first set of connection parameters; displaying a field selection page for allowing selection of at least one field of the selected database, the field selection forming a portion of a query; displaying a filter page separate from the field selection page for receiving filtering parameters for filtering data in the at least one field of the selected database, the filtering data forming a portion of the query; and generating a transaction pattern specifying a database interaction that performs the query on the selected database using the selected database, the received connection parameters, the selected at least one field of the database, and the received filtering parameters, such that the transaction pattern is a prerecorded interaction with the selected database capable of being replayed for conducting the database interaction to perform the query on the selected database on behalf of a user, wherein the transaction pattern includes a graphical representation of the selected database, the received connection parameters, the selected at least one field of the database, and the received filtering parameters; wherein one of the first set of connection parameters and the second set of connection parameters include requested by the single connection information page includes fields for a server name, a database server resolvable name, a username, and a password.