SPONSORS:






User Tag List

Thanks Thanks:  0
Likes Likes:  0
Dislikes Dislikes:  0
Results 1 to 7 of 7
  1. #1
    Member
    Join Date
    Oct 2006
    Posts
    59
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Retrieving Data from Oracle DB and loading into an excel or CSV file

    Hi,

    I have a scenario where i need to run a query and retrieve the test data from Oracle DB and load it to a Excel or any file format that I can re-use that test data for another script in load runner. And i need to be able to do this on the fly.
    Can this be accomplished? If so any suggestions on how to do that.
    Any help would be highly appreciated.

    Here is a detailed description of my issue.

    When one of our batch job runs, it creates some data like Object Ids, Usernames, and Pwds in the Oracle DB. I need to be able to run a LR script to query that data and store it to a excel or a notepad and use that data (usernames and pwds) for runinng a load test with another script. The data is very dynamic and I need to capture that on the fly and use it for my Load runner scripts and run a load test.
    While the load test is being run I also need to invoke an executable or a batch file that will notify the DB that the transaction is complete. Can this be done?

    Thanks,
    Vinny.

  2. #2
    Moderator
    Join Date
    Feb 2010
    Location
    Europe
    Posts
    944
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0
    Is this during a test?

    If so it's unlikely that writing out to a file will work...

    I suggest you either look at the VTS (especially if you are using LR11.52 as it's just had a refresh) or a DB solution (MySQL is well documented by both Richard Bishop and Stuart Moncrieff- Google is your friend here)

    as these will allow you to both write to and read from the dynamic data source - without having to jump through too many hoops

    as for notifying the Oracle DB - how are you doing this? a little more info may help get a sensible answer
    Last edited by JimHowell1970; 05-29-2013 at 04:43 AM.

  3. #3
    Member
    Join Date
    Oct 2006
    Posts
    59
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0
    Hi Jim,

    Thanks for the help. I am looking at the VTS. This is something new as i haven't done this before. As per notifying the Oracle DB, the developer said he can build an executable that I can invoke thru LR and that should take care of sending the notification to the DB.

    Thanks,
    Vineel.

  4. #4
    Moderator
    Join Date
    Feb 2010
    Location
    Europe
    Posts
    944
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0
    In that case I'd suggest a .dll if possible for the executable - easy to call from LR

    Which version of LR are you using?

  5. #5
    Member
    Join Date
    Oct 2006
    Posts
    59
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0
    how do I call a .dll in Load runner and I am using LR 11.5

    Thanks,
    Vimeel.

  6. #6
    Moderator
    Join Date
    Aug 2001
    Location
    NC
    Posts
    6,041
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    1 Thread(s)
    Total Downloaded
    0
    Keep in mind that you are now adding an in test query load which will never be there in production. In nearly all cases where I have seen this occur the queries are not supported by an existing index and this results in large amounts of table scan and disk activity on the server which impact the other queries in the system. I would heartily encourage you to pre-load your data into VTS or simply into a CSV based parameter file prior to the test.

    IF you do decide to head down this path be aware that you will not be able to modify an existing parameter file on the fly and have that information available to you during the same test. Why, you may ask? At the beginning of the test all data files are loaded into RAM on the load generators to prevent large amounts of disk based activity during the test execution, as this would distort the performance of the virtual users. As a result any changes to the parameter file will be available at the start of the next test when the updated parameter file is loaded into memory. And, be a realist here, are you comfortable brokering the lock and write access for dozens, perhaps hundreds of virtual users, all trying to update a common data file at the same time? I would daresay that this is a challenge that would hamper most of the users of performance test tools due to weak foundation skills in development.

    Look to VTS if you must. Have one scheduled process run to create a file which is then batch loaded into a VTS table. Then pull your parameters from VTS. This will be equally as complicated from a programming perspecive as would be loading a DLL with all of the code support to query the database yourself.

    My preference would be for no extra in-test load and pre stage data moving from one stage to the next in data files. This way you get no extra load to the database during the test, you have no extra complications from VTS and you can use all of the standard in-built capabilities for reading from data files on a unique basis for each virtual user.
    James Pulley

    Replace ineffective offshore contracts, LoadRunnerByTheHour. Starting @ $19.95/hr USD.

    Put us to the test, skilled expertise is less expensive than you might imagine.

    Twitter: @LoadRunnerBTH @PerfBytes

  7. #7
    Member
    Join Date
    Sep 2008
    Location
    India
    Posts
    394
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0
    Quote Originally Posted by nandivineel View Post
    how do I call a .dll in Load runner and I am using LR 11.5
    lr_load_dll
    Best Regards,
    Sanket Vaidya

    Om - Effortless Text Generation http://sourceforge.net/p/omfortesting/home/description/

 

 

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Search Engine Optimisation provided by DragonByte SEO v2.0.40 (Pro) - vBulletin Mods & Addons Copyright © 2017 DragonByte Technologies Ltd.
Resources saved on this page: MySQL 10.00%
vBulletin Optimisation provided by vB Optimise v2.7.1 (Pro) - vBulletin Mods & Addons Copyright © 2017 DragonByte Technologies Ltd.
User Alert System provided by Advanced User Tagging v3.3.0 (Pro) - vBulletin Mods & Addons Copyright © 2017 DragonByte Technologies Ltd.
vBNominate (Lite) - vBulletin Mods & Addons Copyright © 2017 DragonByte Technologies Ltd.
Feedback Buttons provided by Advanced Post Thanks / Like (Pro) - vBulletin Mods & Addons Copyright © 2017 DragonByte Technologies Ltd.
Username Changing provided by Username Change (Free) - vBulletin Mods & Addons Copyright © 2017 DragonByte Technologies Ltd.
BetaSoft Inc.
Digital Point modules: Sphinx-based search
All times are GMT -8. The time now is 04:20 PM.

Copyright BetaSoft Inc.