FAQ on Testing Oracle Apps with HP UFT

Last week we had our webcast: Testing Oracle Apps More Effectively Using HP UFT, and we had many questions from our live audience. Today we bring you a transcript of the Q&A session plus some extra questions that we had pending due to time constraints. Remember you can request a Free Virtual Testing Assessment here.

What experience and skills should a person have to be a good automated tester?
Test analyst: executes and reports on test results. This resource executes tests but can not create the automated tests, cannot edit/maintain automated tests and likely cannot troubleshoot failures or conflicts.

Automation engineer: developer like skillset. Coding the automation as well as architect skills when root cause analysis to help pinpoint and resolve failures. Automation is a form of development

As a manual tester, should I be worried about my job if my company is considering buying/using automated tools?
Not necessarily. In most cases, companies will still have a compliment of both manual and automated testing. Truth be told, you cannot automate everything. But just to be safe, I recommend that you become proficient with both manual and automated testing and give your company a strong reason to keep you on board!!

What are some of the common benefits of using automated tools?
Repeatability, reliability (human error), faster testing cycles, re-use, cost savings/ROI, last but not least… improved Quality!

How much coding effort is it going to take? (Related to the case study discussed)
The amount of coding to create a script is relatively small. It gets more complex as we start adding things like controls to make sure you’re logged into the server, making sure the database is available, the correct wall selected for the user type you’re emulating, etc. In that respect, you will need to read up, but it’s definitely learnable. If you’ve done basic testing previously, you can do good automation.

Can the same automated test scripts be used by developers, testers and business and operations’ people?
By default, scripts created are stored in the repository. At that point, the scripts can be used by any group, such as developers for expanded unit tests, test personnel for any of the test cycles, business analysts for UAT, for the operations team to run in the patching cycle, etc.

Why choose an automation tool if open source tools are available?
When it comes to functional testing, Open Source has become quite a disruption in this space. What we see, however, is that open source can only do so much. It’s great for niche, for a piece solution or product, but when it comes to encompassing all automation in different technologies, not only Oracle, or ERP, but also the web or mobile, or client server applications, this is where HP UFT takes it to the next level.

Also, bear in mind that while Open Source tools are free, the cost comes immediately on two sides: one, they are very, very technical, so you need a strong background in coding languages, and second, you have a responsibility to the internet public by using those tools, to broadcast what you’ve done and how your experience was – if you don’t do this, your access will be removed and you won’t be able to use these toolsets anymore. We’re all about cutting edge, so there is a need for open source, but on an everyday basis, work needs to be done, and the HP toolsets do an excellent job of providing a platform that works consistently, accurately and offers metrics to review what works and what doesn’t.

How can this tool be leveraged in automating testing of ETL projects? We are moving big data from one set of tables to another.
It really depends on how much data is being accessed. You can create ADO connections within UFT, but may run into performance issues depending on how much data is being accessed.

How does UFT work for EBS Functionality testing?
Similar to how we walked through the demo of UFT, you would record your business process to create a test script against Oracle EBS. You could take to the next step and build out business components using BPT within UFT.

We are using UFT and Loadrunner 12 that is Keyword driven. How much is coding effort would be required? And what frame work can we use?
UFT is used for automated or functional testing, whereas LoadRunner would be used for performance or load testing. Automation framework is a way to organize your automation scripts in a meaningful manner.

Like many other types of frameworks, it is possible to use a combination of a couple of frameworks to meet you program needs and objectives. Common Automation Frameworks are: (* for the ones commonly used with Oracle)

  • Data Driven Testing Framework*
  • Keyword Driven Testing Framework*
  • Event-Driven Testing Framework*
  • Process-Driven Testing Framework*
  • Module Based Testing Framework
  • Library Architecture Testing Framework
  • Behavior Driven Development Framework
  • Hybrid Testing Framework

There are a number of ways to build it out. It would depend on the technology or application(s) you are testing and the business processes that go along with it.