This discussion is archived
5 Replies Latest reply: Dec 18, 2012 1:03 PM by proven983 RSS

Oracle Test Manager (OTM) and DataBank

proven983 Newbie
Currently Being Moderated
Hello,

How can I execute scripts with using databank (.csv) in Oracle Test Manager? With Open Script is working perfect! If I can not use databanks in OTM what is the other possibility to do that?

Thanks!

Edited by: user1039007 on Dec 13, 2012 1:06 PM

Edited by: user1039007 on Dec 18, 2012 10:53 AM
  • 1. Re: Oracle Test Manager (OTM) and DataBank
    834498 Journeyer
    Currently Being Moderated
    Hello
    You can use databank in OTM but you have to give several run time parameters in the textbox provided when defining/executing a test case.
    Please check OpenScript user manual to see the parameters to use.

    Something like:
    -iterations i : number of iterations to run
    -delayPercentage -1 -delayMin 2 -delayMax 2 : replace think time by 2secs
    -dbopts “alias=xxx :iterations=zzz:startindex=y :whenOut=STOP_USER“
    alias : databank alias name
    startIndex : line number to start with in the db
    whenOut : what to do when out of record.

    JB
  • 2. Re: Oracle Test Manager (OTM) and DataBank
    proven983 Newbie
    Currently Being Moderated
    Jean-Baptiste thank you for your help! How can I upload .csv file in OTM? Is there any special way to do that or OTM just have to have access to the same repository as OpenScript have ?

    Thanks!

    Edited by: user1039007 on Dec 18, 2012 10:52 AM
  • 3. Re: Oracle Test Manager (OTM) and DataBank
    proven983 Newbie
    Currently Being Moderated
    I solved the problem with uploading csv file. Where I have to put iterations number in ?

    Thank you!
  • 4. Re: Oracle Test Manager (OTM) and DataBank
    834498 Journeyer
    Currently Being Moderated
    Better to use a shared repo between OpenScript & OTM server
    => you use a shared folder on the OTM server
    => you mount the drive on your computer where OS is installed
    => you define the repo in openscript using the letter path.

    Concerning iteration number, see doc page 81 (chap 7-7)

    Select Quick Run from the right-click shortcut menu.
    This dialog box has the following options:
    System - select the system on which you want to run this test. Systems are
    configured using the Systems Manager.
    Run Name - specify a name to use to identify this test run.
    Version - select the version of software you are using or select Other to enter a
    version that is not in the list.
    Command line run settings - specify any additional arguments or command line
    settings to use when running an Oracle OpenScript script. See the Oracle
    OpenScript User’s Guide for additional information about using command line
    settings.


    JB
  • 5. Re: Oracle Test Manager (OTM) and DataBank
    proven983 Newbie
    Currently Being Moderated
    Thank you for your time and your help! It works now!

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points