Summary
Data is a vital resource of any software. In SOA projects, data is subjected to go through various transformations and conversions when transmitting from a source to destination. Due to the complex integrations of service-oriented solutions, isolating data-related issues is usually a tedious activity. Therefore, it is important to include a sufficient amount of tests which directly communicate with the databases of your SOA instead of testing through web service interfaces. soapUI allows us to directly call database tables using JDBC Request TestStep. In this chapter, we looked at how soapUI can be used to test databases. We discussed about the properties associated with JDBC requests and how assertions can be used to validate database transactions.