Comments on: Making a DB Connection Using Service Test 11’s Custom Code

By: Govindh

Govindh — Mon, 21 Jan 2013 14:16:32 +0000

Hi joe,

Currently i have just started to explore ST 11.20. I have a requirement to connect to AS400 database, fetch data from it through multiple SQL Queries and compare the result table that is generated through all queries with the SOA Response nodes and also update the result table to an excel file for reference.

I have kept all the sql queries in excel file and i am able to parameterize it succssfully using custom code.
Then i am sending this customcode output property(SQL String) as a input to select data component.

Here i need to write “After Execute step event” to append the result table items to an Dynamic array or list.But i am not able to access the Reslut Table of Select Data Check Point.

Could you help me to get this done. Also suggest me other solutions that may be helpful for me?

By: HP Service Test 11.10 New Database Functionality – VIDEO — Joe Colantonio -- QuickTest Pro, Tech Geek, Bibliomanic, The Software Test Automation Imagineer

Wed, 23 Mar 2011 17:06:58 +0000

[…] function to develop your own C# code that connected to a DB, as well as to perform an operation. (If you’re interested in how to do this, check out my custom code post.) However, in ST11, it is no longer necessary to write code to achieve this functionality. Now […]

By: Joe Colantonio

Joe Colantonio — Tue, 25 Jan 2011 13:49:25 +0000

In reply to Ofer.

@Ofer: Awesome – you made my day! I can’t wait to get my hands on the new version. I really like ST11 — you guys did a great job developing it.

By: Ofer

Ofer — Tue, 25 Jan 2011 13:34:37 +0000

@Joe:
Hi Joe, the support for DB is part of our next release, coming out quite soon.
We are using the same concepts as for Excel – you can bring the data in DT, see it like Excel and data drive.
Also in RT, you can connect to the DB, extract/update data and link it like any other data in the flow.
The user guide will include all the required information.
If you need additional help/information on ST 11 and above, feel free to address me.
Ofer

By: Joe Colantonio

Joe Colantonio — Tue, 25 Jan 2011 13:21:37 +0000

In reply to Ofer.

@Ofer: Hi Ofer – this is great news! Can you please tell me where this functionality is found? I know you can data drive info using Excel or XML but I don’t seen any options to point to a database. I might be missing something but I can’t find this info in the HP ST User guide either. Thanks — Look forward to hearing back from you!

By: Ofer

Ofer — Tue, 25 Jan 2011 09:25:04 +0000

Hi,
I would like to update that we have a complete support for DB in Service Test.
you can connect, extract information and change information. you can use extracted information within your flow for data driven testing.
all that without one line of code.