to get results from DB you can with evrything, all you need are scripting language + ODBC driver. Do you use VBScript in selenium?
http://www.google.com/search?q=vbscript+odbc first link. On Thu, Nov 19, 2009 at 11:18 AM, Automation <[email protected]> wrote: > Thanks Roman. I started looking into Selenium and was able to record > very basic test, but I would like to verify the results against DB > table. I am not sure how Selenium will be able to do it? > > On Nov 19, 9:38 am, Roman Zilber <[email protected]> wrote: > > Try to play with Selenium, the test you want to do is not very > complicated, > > I would estimate it as one-two weeks to create working prototype, but if > you > > don't experience with automation and programming it can take much longer. > > QTP temporary license can expired faster. > > > > The decision to buy software take a long time in companies, even if > create > > working test you wouldn't be able to use for long time. Buying QTP only > for > > report testing may be not a good investment. Recording in Selenium is > simple > > as in QTP try it. If you want to convenience the management any working > > automation will be good. > > > > > > > > On Thu, Nov 19, 2009 at 6:22 AM, Automation <[email protected]> > wrote: > > > Thanks a lot for your response. > > > > > Our company doesn't have a QTP, I have to convenience management that > > > we can save resources if we do automation for report testing. I was > > > looking for tools and I thought may be I will use the trial version of > > > QTP for initial development and if mgmt. is impressed make them buy > > > the tool. > > > > > But as you suggested, I can definately look into free tools. > > > > > Once again thanks for your advise. > > > > > On Nov 18, 10:42 pm, Roman Zilber <[email protected]> wrote: > > > > > run the reports from web > > > > > > QTP is a tool which "knows" to interact with GUI, so it a right tool > to > > > do > > > > it (if a flow to run reports is very simple, you can consider to use > free > > > > tools, such as Selenium, but if the company has QTP, use QTP) > > > > > > > match the results with the database > > > > > > You will probably do it with VBScript, so QTP can do it. > > > > > > If you new to automation, here is a small advice :) > > > > Try to split your script to independent steps, for example: > > > > Step I: > > > > 1) Prepare input data table for running reports (table1, file1.xls) > > > > 2) Generate reports from web, and collect results to output table > > > (table2) > > > > 3) save the table as Excel file2.xls > > > > > > Step II: > > > > - using table1, retrieve same data you have on web reports to table3 > from > > > > DB, save it file3.xls > > > > > > Step III: > > > > - compare file2.xls and file3.xls > > > > > > Roman > > > > > > On Wed, Nov 18, 2009 at 12:21 PM, Automation <[email protected] > > > > > wrote: > > > > > Hi All, > > > > > > > I am very new to automation. In my orginization, I would like to > > > > > automate tests which are currently run manually. My requirement is > to > > > > > run the reports from web and match the results with the database. > My > > > > > question is, is QTP a correct tool to satisfy my requirements? If > not, > > > > > which other tools I should look in to. > > > > > > > I will be very thankful for the feedback. > > > > > > > Thanks. > > > > > > > -- > > > > > You received this message because you are subscribed to the Google > > > > > "QTP - HP Quick Test Professional - Automated Software Testing" > > > > > group. > > > > > To post to this group, send email to [email protected] > > > > > To unsubscribe from this group, send email to > > > > > [email protected]<mercuryqtp%[email protected]> > <mercuryqtp%2bunsubscr...@googlegroups.com> > > > <mercuryqtp%2bunsubscr...@googlegroups.com> > > > > > For more options, visit this group at > > > > >http://groups.google.com/group/MercuryQTP?hl=en-Hide quoted text - > > > > > > - Show quoted text - > > > > > -- > > > You received this message because you are subscribed to the Google > > > "QTP - HP Quick Test Professional - Automated Software Testing" > > > group. > > > To post to this group, send email to [email protected] > > > To unsubscribe from this group, send email to > > > [email protected]<mercuryqtp%[email protected]> > <mercuryqtp%2bunsubscr...@googlegroups.com> > > > For more options, visit this group at > > >http://groups.google.com/group/MercuryQTP?hl=en- Hide quoted text - > > > > - Show quoted text - > > -- > You received this message because you are subscribed to the Google > "QTP - HP Quick Test Professional - Automated Software Testing" > group. > To post to this group, send email to [email protected] > To unsubscribe from this group, send email to > [email protected]<mercuryqtp%[email protected]> > For more options, visit this group at > http://groups.google.com/group/MercuryQTP?hl=en > -- You received this message because you are subscribed to the Google "QTP - HP Quick Test Professional - Automated Software Testing" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/MercuryQTP?hl=en
