Do you know how do I run SQL against Oracle out of a Test?

Pascal Calovini 10 months ago

Hi There,

a developer sent me a quite interessing request!

He builds database structures in our data ware house based on Oracle and the specialist division write SQL code as Test Step in ALM (17.01). Each Test contains one Test Step and a defined result (normaly empty result).

There are some parameters like environment, User, stage and so on to choose the right database.

Does anybody has a good idea, how to automatically run these SQLs case by case out of a testset?

I can run Sprinter, UFT, UFT Developer, JUnit, custom test types, ... and many other technology but I'd need a starting point, in best case with some experiences.

Thanks a lot

Pascal

Tags:

ALM

SQL

0 Mike Zhang 9 months ago

Hi, It would be helpful if you could provide more details.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Pascal Calovini 9 months ago in reply to Mike Zhang

Hi Mike,

sure: SQL is a language with which you can select or alter data from or into a database. It is written in TEXT and can be stored anywhere. Our specialist division workers design this SQL-Statements, store them in a Test Step in a Test Case in ALM and the Testmanager take these to create Test Instances in Test Sets which are linked to a Test Cycle.

At the moment, we take Ab Initio to take the Test Steps via REST, run the SQL-Statements against Oracle and compares them with the expected Result. This is controlled over UC4 request, which needs many Parameters like Test Cycle Name, Database environment and so on. There are some manually steps to create these UC4-Jobs and request the run. We'd like to provide an easier way to send these SQL-Statements against Oracle like out of Jenkins, oder ALM Scheduler, or, or or, ..
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Menu

ALM/QC Discussions

Verified Answers

Do you know how do I run SQL against Oracle out of a Test?

Tags:

Resources