How many ways we can parameterize data in QTP?

Parameterization is one of the important provisions we have in quick test professional which has enabled the passing of the values to the tests very simple. This parameterization feature enables one to pass multiple values at a time to a test.

And what more? 

The process of parameterization has proven to be a great helping hand while carrying out the data driven testing. Data driven testing is the kind of testing that involves working with multiple sets of data on the same tests. 

The quick test professional comes with various ways for carrying out the process of parameterization:

1. Parameterization via loop statements
2. Parameterization via data table
3. Dynamic test data submission
4. Obtaining test data via front end objects
5. Getting test data directly from the spread sheets, flat files or we can say external files.
6. Getting test data directly from the oracle, MSaccess or we can say data bases.

Now we shall discuss the above 6 different ways of parameterizing the tests in detail.

1. Parameterization via loop statements: 

In this method the sequential numbers or logical numbers can be passed via the loop statements however you cannot pass strings to the tests.

2. Parameterization via data table: 

One data table or spread sheet is provided along every test in quick test professional. The provided data table along with the test can be used very well for the data driven testing. Furthermore the following 3 purposes are served by the data table:

a)   To import the test data from external spread sheets: for doing this open the data table and place the pointer. Then right click and select the import from file option. Then you need to enter the path of the spread sheet to be imported from and hit ok. Later connect to the test.

b)   To import the test data from the external flat files: for doing this open the data table and place the pointer. Then right click and select the import from file option. Then you need to browse the path of the file to imported and press ok. Later connect to the test.

c)   To import the test data from the data bases: for doing this the user needs to first create a DSN of the data base i.e., the data source name by making use of the SQL commands. This can be done by creating a test data base and saving the created data base with .mdb extension in msaccess. Next step involves creation of a data table and filling it up with data. The last step is to create a DSN and you can start importing the data.

    3. Dynamic test data submission: 

   This also involves the use of the loop statements however the data has to be entered again and again by the user.

    4. Obtaining test data via front end objects

   5. Getting test data directly from the spread sheets, flat files or we can say external files.

   6. Getting test data directly from the oracle, MSaccess or we can say data bases.

There is one more method for parameterizing the data apart from those mentioned above and is also less followed. The method makes use of the dictionary object for the purpose of parameterization. There are several types of parameterization namely:

1. Data table
2. Environment variable
3. Random number
4. Test and action

The data table consists of the following parameters:

1. Input parameter
2. Out put parameter
3. Random number
4. Environment variable. 

How Does Run time data (Parameterization) is handled in QTP?

Efficient run time data handling is quite important for proper test automation through quick test professional. In this article we take up discussion regarding how run time data is parameterized or handled during a run session in quick test professional.

The parameterization of run time data is necessary in quick test professional  as it enhances test components. 

What happens in Run-time Data Parameterization?

- In run time data parameterization or handling, a variable is passed as a parameter or an argument via an external source which is generally a generator in most of the cases. 

- This variable or parameter which is passed essentially consists of a value that is assigned via the generator as mentioned in the previous line. 

- The parameterization of the variables in the test component can be done in a series of different check points as well as in a series of a set of different steps as it is required by the situation.

- Apart from normal values, the parameterization of the action data values can also be done. 

- For parameterizing the same value in a series of several steps the data driven wizard can be used.  

How it is handled in QTP?

- Quick test professional test automation suite comes with an in built integrated spread sheet when the run time data table is filled up with the test data. 

- This spread sheet is just like the excel spread sheet and thus multiple test iterations can be created which in turn will save you a big deal on the side of programming efforts. 

- The run time data can be entered either manually or in an automatic way by importing the data from the spread sheets, text files, data bases and so on. 

- The spread sheets in quick test professional come with full functionality as that of the excel spread sheets. 

- Using these spread sheets following tasks can be achieved:

1. Manipulation of the data sets
2. Creation of multiple iterations of the tests
3. Expanding test coverage without unnecessary programming and so on.

- In simple form, parameterization can be defined as providing multiple test data or inputs to the tests. 

- While working on quick test professional, input can be supplied in the below mentioned 4 ways:

1. Input through note pad
2. Input through key board
3. Input or import via a data base
4. Input through excel spread sheet.

What is Run Time Data

Run time data is nothing but a live version of the data that has a current association with the test that is currently under execution. 

There are two methods available for the parameterization of the run time data as mentioned below:

1. DTSheet.GetParameter: with this parameterization method the specified parameter can be retrieved from the run time data table.
2. DTSheet.AddParameter: with this parameterization method a new column is added.

Properties of Run-Time Data

1. Name property: It defines the name of the column in the run time data table.
2. Raw value property: It defines the raw value of a cell residing in the current row of the parameter under consideration. The actual string written in the cell before computation is called the raw value for example actual text present in some formula.
3. Value property: This is the default property of the parameter and used for retrieving as well as setting the value of the cell of the active row in run time data table.
4. Value by row property: It is used for retrieving the value of the in the row specified by the parameter.