5 Replies Latest reply: Dec 18, 2012 3:03 PM by proven983 RSS

    Oracle Test Manager (OTM) and DataBank

    proven983
      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
          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
            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
              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
                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
                  Thank you for your time and your help! It works now!