Forum Discussion

pgutow's avatar
15 years ago

soapUI + database

Hello,

I do not have much experience with soapUI, so I'm sorry if the question is newbish. Could you please direct me at some useful guides? The problem I am struggling with is as follows: data in our database is being updated quite often. I try to find a way to automate soapUI scripts so they will follow any changes in database without my help. Is it possible to make soapUI ask database to find a specific record in the database and then use data from this record , send it to endpoint and validate the response using self-adjusting assertions?

Right now whenever I start the testing I have to manually find the record, run the request. Next day, this record is no longer available so I have to find new one.

1 Reply

  • You have to add a groovy step. This one will conect to your database to retrieve this information.
    Dont forget to add your database drievr in the ext folder.
    For a full exampel search on google : groovy sql soapui