Test Complete Video Series -- Part 6 (Data Driven Testing) Video Lecture | Automation Training with TestComplete - Software Testing

hi today in execute automation dot-com
video tutorial session and test complete
we will discuss about the energy one
testing using a duo okay so using eighty
will so far in part one session these
are how how to perform the data driven
testing using Excel sheets in CSV so in
part two we're going to discuss how to
perform the same directed on operation
using a duo driver that we have in test
complete using this area driver we can
leverage the power of accessing data
from a database using either ODBC
connections or using the DNS which we
create new BC driver options in the
operating system
so using Eddy with driver we can access
the database such as sequel server and
oracle or even my sequel i believe but i
didn't hear it in my SQL so you can use
the options using those SQL server
products main server database server
products available okay so today we're
going to discuss off how to use area
driver to access the database which is
available in my host machine windows 7
from one of the remote machine which is
running in my you know virtual machine
in sequence or in Server 2008 operating
system okay so so here is the same
script which we saw in the part one of
our you know demonstration in Excel and
CSV so what I'm going to do right now is
I'm just going to comment these course
which is available already so I'm just
going to comment this guy and what I'm
going to do is I'm going to use the the
DDT dot ed u-- a driver so i'm going to
choose this and if you click control
shift and space here so it will show you
the connection strings and the table
name well this is my you know ritual
machine which doesn't have any any of
the sequencer product installed so i'm
going to access the database from my
remote host machine scuse me so don't do
that
what I'm going to do is I'm just going
to
you know create a connection string from
accessing you know by creating an ODBC
connectivity so you can do this by you
know searching the ODBC option juice
available in your operating system I
have already created the ODBC I mean DNS
here for my host machine using this car
through dB
so I'm just going to use this guy right
now so go to the store you not to create
this connection string I used to use
this trick I will use this store add new
item and here there is an option called
DB table so I will just select that one
and to say okay it already exists so I'm
just gonna create one excuse me so I'm
gonna say add a table here so right now
we have a I'm going to specify a table
the main trick of this is I'm just
trying to access the connection string
from my remote machine in order to do
that I'm doing all these steps okay just
be with it right now and you'll
understand why I'm doing this one
afterwards so I'm going to select the
ODBC okay and I'm going to select a DNS
which I have already created so I'm
going to select this guy and I'm gonna
enter the username and password for my
machine sequel server so I'm selecting
that and it lists all my database which
is available so I'm going to select the
database employee details so as you
could see here in my on second it's
pretty much slow today so I'm going to
select this excuse me employee details
database in order to you know select the
options I mean the tables which is
available within this database so let's
select this and I'm going to click the
hit this ok button
oh my god this is slow today so what I'm
going to do is okay we just got back up
so what I'm going to do is I'm just
going to show you the database which I'm
using here so this is the employee
details database which I have right now
and it has a table called details table
so our intention is to access this
detailed table from the database server
which is a database available in my host
machine Windows seven and I'm going to
retrieve this informations like name age
and phone numbers from this sequel
server database so this is what is the
intention so let's go back again to the
virtual machine in Windows Server 2008
and from there we will try to access
this particular you know database so
let's just the connection so it succeeds
and I'm going to click this okay button
and here is the connection string so I'm
just going to copy this connection
string thesis this is why I actually
created the whole table structures and
other stuff from these stores in
testcomplete so in order to whoops on a
second under the username and password
once again and this will you know with
leave us the tables okay so here is the
detail tables as you know this is the
table which we have in these so it
receives all these name age and phone
number right now okay great
so finish okay super so if it's just
good connected so I'm gonna use this guy
this description the connection string
which is I have copied from the head of
each table before when I was creating
let me use this and we know that the
database table name is details so I'm
gonna just you know use that and I'm
gonna say okay so what have we have did
right now is using this a DDT dot edu or
driver I have copy pasted the connection
strings this is the whole intention to
create a connection string edges copied
pasted this one and right now as did in
our CSV driver I'm going to use the same
DDT dot current driver dot that drive
method I'm gonna choose the same unit
test dot caller so unit unit one caller
right so this will pull us the caller
here okay so it's going to be the same
thing so in the color this is the same
structure which I have created for
that's way it's it's gonna be same
that's why what I'm going to do is I'm
just going to execute this once again
and just execute this and see if it's is
running fine or not so I'm just going to
give this guy and oops we got an error
here okay it says that the the password
is not correct okay okay
so what I'm going to do right now is I'm
going to just add a field here called
password so I'm gonna outsource my
password right now it's equal to say
this project a right so okay so I did
this and I'm gonna see this guy right
now and I'm gonna just run this once
again let's see if it works
hey that's working fine as you could see
here I could just pull the data from the
database using the same ad or driver
method which I have so which games like
Karthik 27 and hits the phone number
similarly JOHN CARTER fortify and his
phone number and those made 40 phone
numbers so it just came up so this way
it just works pretty fine so this is how
you can pull the data from the radio
driver so so this is the data driven
testing using testcomplete using the you
know ad will try word and pull the data
from the sequel server database so I
hope you enjoyed the data driven testing
part one and also the part two and
really thank you very much for watching
and just wait for the upcoming video
sessions of this competing exclamation
cap thank you