Welcome!

Microservices Expo Authors: Elizabeth White, Pat Romanski, Automic Blog, Liz McMillan, Mamoon Yunus

Related Topics: @CloudExpo, Microservices Expo

@CloudExpo: Article

Using SQL Azure for SOA Quality Testing

SQL Azure provides affordable and rapid collaboration across SOA Test teams using SOAPSonar

I. INTRODUCTION
Throwing its hat in the Platform as a Service (PaaS) ring, Microsoft has joined the likes for Salesforce.com and Google with its annoucement of Microsoft Azure Platform. Microsoft Windows Azure Platform provides three primary components:

  1. Windows Azure: A cloud services operating system that serves as the development, service hosting and service management environment for the Windows Azure platform.
  2. SQL Azure: A cloud hosted relational database that removes the burdens of RDBMS installation, patching, upgrades and overall software management for relational databases.
  3. AppFabric: A platform that enables users to build and manage applications easily both on-premises and in the cloud.

To better understand the components offered by MS Azure, we registered for MS Azure Platform and browsed through the three components. SQL Azure turned out to be the easiest one to configure and do something useful with, so we built a mashup that utilizes MS SQL Azure as a centeral repository for SOA Testing. In this article, we share our impressions of SQL Azure and how to automate SOA quality assurance by building test cases that use data from a SQL Azure instance.

II. BENEFITS OF USING SQL AZURE FOR SOA TESTING

By using a cloud-based RDBMS, such as MS SQL Azure, developer and testors can gain the following benefits:

  • Better Collaboration across testors by sharing test data within and across enterprise boundaries and geographies.
  • Ease of Management by eliminating the burden of downloading, installing, patching and managing a Database used for storing SOA test data values.
  • Increased Nimbleness by eliminating resources contention and scheduling bottlenecks by "spinning up" new instance of Database servers within minutes for SOA Testing teams.
  • Cost Reduction inherently associated with on-demand and elastic nature of cloud computing by eliminating on-premise hardware and software.

III. SETUP AND INSTALLATION OVERVIEW
To understand SQL Azure and its utility for collaborative SOA Testing, we built a mash up between SQL Azure, a target web service IsValidEmail(email address) and SOAPSonar, a SOA Testing tool from Crosscheck Network.  Figure 1 shows the overall setup scenario where SQL Azure is used to maintain and share test data consumed by geographically disparate SOA testers tasked with testing services for a SOA deployment.

Figure 1:  SQL Azure setup for collaborative SOA testing

Figure 1: SQL Azure setup for collaborative SOA testing

We started by registering for an Azure account and creating a SQL Azure Database. After setting firewall rules that permit remote access, we installed Microsoft SQL Management Studio and connected to the SQL Azure Database. With SQL Management Studio, we were able to create tables and insert data into the tables. We then installed SOAPSonar and imported the publicly available WSDL containing a single test service, IsValidOperation(email), that checks for the validity of an email address. The details of SQL Azure setup and data automation for SOA testing configuration are provided below along with details of issues that we encountered along the way.

III. SQL AZURE SETUP
The SQL Azure setup involves acquiring an Azure account, creating a Database instance, configuring firewall rules for remote access, creating tables and inserting data in the tables. These steps are explained is detail below.

Azure Account Registration: Windows Azure platform, provides an introductory SQL Azure Web edition instance with 1GB of storage. Standard rate for the web edition beyond the 3 months is $9.99/month. Setup is simple and straight forward. You can get started by obtaining an Azure Account.

Database Creation: Once you have your account, you can create a database using the online SQL Azure Web Interface.

Figure 2: SQL Azure Create Database Server Interface

The Location field in Figure 2 above provides two options: i) South Central US and ii) East Asia. This indicates that SQL Azure is primed for low-latency, regional content delivery at least for a couple of regions.

Firewall Configuration: One of the areas to watch out for is the Firewall settings below. You will need to check the "Allow Microsoft Service access to this server" check box that will add a Firewall rule as shown in Figure 3 below.

Figure 3: SQL Azure Database Firewall settings for internal access

In addition to firewall rule shown in Figure 3 that enables you to test connectivity within the cloud environment, you must also add a new rule that enables your external network/machine/laptop - acting as a client to communicate with your SQL Azure Server instance. Add Rule shows your local address range that should be permitted to communicate with the SQL Azure Server. If you don't enable such a firewall rule, you'll get an error, such as:

Error initializing Data Source

SQLServer::Server=tcp:yourAzureSQLServer.database.windows.net;

Database=YourDB;UserID=YourAdminUser;Password=YourPassword;

Trusted_Connection=False;Encrypt=True;.

Cannot open server 'yourAzureSQLServer' requested by the login.

Client with IP address 'xx.xxx.xxx.xxx' is not allowed to access the server.

Login failed for user 'yourAdmin'.

Database Management: SQL Azure exposes rudimentary database create and drop functions. One of the useful features is Connection Strings as shown in bottom left of Figure 4 below. This is a handy feature that provides you with a copy of the connection string that you can paste in your application to connect to a SQL Azure database instance.

Figure 4: SQL Azure Database Management functions

We are accostomed to the rich, internet-based, phpMyAdmin console for managing MySQL databases including the ability to create, drop, and update tables, browse data and write adhoc SQL queries. We expected similar functionality available through the internet console for Micrsoft SQL Azure. In the case of SQL Azure, however, you have two options for managing your database engine: use sqlcmd utility or SQLSever Management Studio. Both options require client side installation. After a little bit of digging around, we found the right version of SQLManagementStudio x86 Executable "tools only" download that was 155MB in size instead of a full 1.26GB SQL Server 2008 November R2 version. After a relative painless installation of SQL Server Management Studio, we were able to connect to SQL Azure, create a table, and insert data into the tables. Figure 5 below shows the SQL queries exectued on SQL Azure using the SQLServer Management Studio.

Figure 5: SQL Server Management Studio for managing SQL Azure

While creating the tables and inserting data, we stumbled on a requirement that SQL Azure expects you to create an index. Without an index, you will see the following error.

Msg 40054, Level 16, State 1, Line 8 Tables without a clustered index are not supported in this version of SQL Server.

Please create a clustered index and try again.

We expect that newer versions of SQL Azure will provide a richer, internet-based management experience and elimate the burden of installing client tools to manage what is after all a cloud-based component.

IV. DATA AUTOMATION FOR SOA TESTING
Using a cloud-based repository for test data provides a number of benefits including test team collaboration across disparate locations and ease of management. Here are the steps to setup SOA test automation using a SQL Azure instance:

Install SOA Testing Tool: We used SOAPSonar Automation Edition from Crosscheck Networks, .NET-based REST XML/SOAP client used for comprehensive web services testing. SOAPSonar insta ller will ask you for required packages, such as .NET Framework 2.0 or higher, if it is not already available on your machine.

Load WSDL: The WSDL for the public service IsValidEmail(email) is published at the following URL: http://www.webservicex.net/ValidateEmail.asmx?WSDL. Paste this URL into SOAPSonar as shown in Figure 6 below to load the WSDL. Select the IsValidEmail test case in the left Project Tree Panel. Enter a test value and execute the test. You will see the SOAP response in the Response Panel.

Configure SQL Azure DB Connection: To connect SOAPSonar to SQL Azure, click on Connection Strings button as shown in Figure 4 above and copy the ADO.NET connection string to the clipboard. Click on Data Sources as shown in Figure 6 below and select the SQL Server Data Source.

Figure 6: SOAPSonar Automation Data Source Configuration Panel

Now you can paste the connection string into SOAPSonar as shown in Figure 7 below and change the Query to point to your table. In our sample case, the table is named Editor. You can now click on the Tables icon in the lower right of the panel shown in Figure 7 to View Data from SQL Azure.

Figure 7: Setting connection parameter from SOAPSonar to SQL Azure

At this stage, you have established connectivity to SQL Azure and are now ready to use the data for test automation.

Use Automation Data: The database table, Editor, that we used in this mashup consist of an Email column that can be selected for automated invocation of the operation IsEmailValid(emailaddress). Simply select the data source as shown is Figure 8 below and exectute the test.

Figure 8: Setting connection parameter from SOAPSonar to SQL Azure

For all Email enteries in the Editor table, nine in our case, SOAPSonar sends SOAP requests to the IsValidEmail Web service gathers the SOAP responses. You can click on Report View to look at SOAP request and response for each Email value in the table. Using a database in this fashion eliminates mannual setting of a test case for each email address. A single test case can be authored with data used from a data store such as SQL Azure. Test success criteria for each test case can also be inserted in the database tables and used to evaluate sucess or failiure for each request.

V. CONCLUSION
SQL Azure is a promising option for corporations that deploy Micrsoft technology and are interested in leveraging cloud computing to reduce IT costs and respond rapidly to business requirements. For companies that are simply looking for hosted relational databases, other options such as MySQL hosted by Amazon EC2, Rackspace, GoGrid or OpSource serve as strong alternatives.

Our impressions of SQL Azure have been positive. Through firewall rules, security provisions are adequete and not overwhelming for database and application developers. We do expect a richer web-based management interface in the future that goes beyond just creating an dropping databases. Although SQL Management Studio, installed locally on your machine, provides powerful management capabilities, it dilutes the power of installation-free, cloud-based components.

Corporations can use Quality Assurance and Testing as low-hanging use-cases for cloud computing. Companies should be less concerned about storing test data in external clouds compared to, for example, real customer data. Using SQL Azure for SOA test automation provides better collaboration for test teams, ease of database management and a cheaper alternative to procuring and maintaining on-premise test infrastructure.

VI. REFERENCES

  1. The NIST Defintion of Cloud Computing
  2. Microsoft Windows Azure Platform
  3. Microsoft SQL Management Studio Tools Only Installation
  4. Sample Datebase Table, Editor with data insert SQL Scripts: DDJ-Index.sql
  5. Email Validation Web service
  6. SOA Testing Tool: SOAPSonar from Crosscheck Networks

More Stories By Mamoon Yunus

Mamoon Yunus is an industry-honored CEO and visionary in Web Services-based technologies. As the founder of Forum Systems, he pioneered XML Security Gateways & Firewalls and was granted a patent for XML Gateway Appliances. He has spearheaded Forum's direction and strategy for eight generations of award-winning XML Security products. Prior to Forum Systems, Yunus was a Global Systems Engineer for webMethods (NASD: WEBM) where he developed XML-based business integration and architecture plans for Global 2000 companies such as GE, Pepsi, Siemens, and Mass Mutual. He has held various high-level executive positions at Informix (acquired by IBM) and Cambridge Technology Group.

He holds two Graduate Degrees in Engineering from MIT and a BSME from Georgia Institute of Technology. InfoWorld recognized Yunus as one of four "Up and coming CTOs to watch in 2004." He is a sought-after speaker at industry conferences such as RSA, Gartner, Web Services Edge, CSI, Network Interop, and Microsoft TechEd. Yunus has the distinction of showcasing Forum Systems' entrepreneurial leadership as a case study at the MIT Sloan School of Management. He has also been featured on CNBC as Terry Bradshaw's "Pick of the Week."

@MicroservicesExpo Stories
@DevOpsSummit at Cloud Expo taking place Oct 31 - Nov 2, 2017, at the Santa Clara Convention Center, Santa Clara, CA, is co-located with the 21st International Cloud Expo and will feature technical sessions from a rock star conference faculty and the leading industry players in the world. The widespread success of cloud computing is driving the DevOps revolution in enterprise IT. Now as never before, development teams must communicate and collaborate in a dynamic, 24/7/365 environment. There is ...
With Cloud Foundry you can easily deploy and use apps utilizing websocket technology, but not everybody realizes that scaling them out is not that trivial. In his session at 21st Cloud Expo, Roman Swoszowski, CTO and VP, Cloud Foundry Services, at Grape Up, will show you an example of how to deal with this issue. He will demonstrate a cloud-native Spring Boot app running in Cloud Foundry and communicating with clients over websocket protocol that can be easily scaled horizontally and coordinate...
Docker is on a roll. In the last few years, this container management service has become immensely popular in development, especially given the great fit with agile-based projects and continuous delivery. In this article, I want to take a brief look at how you can use Docker to accelerate and streamline the software development lifecycle (SDLC) process.
DevOps at Cloud Expo, taking place October 31 - November 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA, is co-located with 21st Cloud Expo and will feature technical sessions from a rock star conference faculty and the leading industry players in the world. The widespread success of cloud computing is driving the DevOps revolution in enterprise IT. Now as never before, development teams must communicate and collaborate in a dynamic, 24/7/365 environment. There is no time to w...
In his session at 20th Cloud Expo, Scott Davis, CTO of Embotics, discussed how automation can provide the dynamic management required to cost-effectively deliver microservices and container solutions at scale. He also discussed how flexible automation is the key to effectively bridging and seamlessly coordinating both IT and developer needs for component orchestration across disparate clouds – an increasingly important requirement at today’s multi-cloud enterprise.
IT organizations are moving to the cloud in hopes to approve efficiency, increase agility and save money. Migrating workloads might seem like a simple task, but what many businesses don’t realize is that application migration criteria differs across organizations, making it difficult for architects to arrive at an accurate TCO number. In his session at 21st Cloud Expo, Joe Kinsella, CTO of CloudHealth Technologies, will offer a systematic approach to understanding the TCO of a cloud application...
API Security has finally entered our security zeitgeist. OWASP Top 10 2017 - RC1 recognized API Security as a first class citizen by adding it as number 10, or A-10 on its list of web application vulnerabilities. We believe this is just the start. The attack surface area offered by API is orders or magnitude larger than any other attack surface area. Consider the fact the APIs expose cloud services, internal databases, application and even legacy mainframes over the internet. What could go wrong...
The goal of Continuous Testing is to shift testing left to find defects earlier and release software faster. This can be achieved by integrating a set of open source functional and performance testing tools in the early stages of your software delivery lifecycle. There is one process that binds all application delivery stages together into one well-orchestrated machine: Continuous Testing. Continuous Testing is the conveyer belt between the Software Factory and production stages. Artifacts are m...
In IT, we sometimes coin terms for things before we know exactly what they are and how they’ll be used. The resulting terms may capture a common set of aspirations and goals – as “cloud” did broadly for on-demand, self-service, and flexible computing. But such a term can also lump together diverse and even competing practices, technologies, and priorities to the point where important distinctions are glossed over and lost.
In his session at @DevOpsSummit at 20th Cloud Expo, Kelly Looney, director of DevOps consulting for Skytap, showed how an incremental approach to introducing containers into complex, distributed applications results in modernization with less risk and more reward. He also shared the story of how Skytap used Docker to get out of the business of managing infrastructure, and into the business of delivering innovation and business value. Attendees learned how up-front planning allows for a clean sep...
Most companies are adopting or evaluating container technology - Docker in particular - to speed up application deployment, drive down cost, ease management and make application delivery more flexible overall. As with most new architectures, this dream takes a lot of work to become a reality. Even when you do get your application componentized enough and packaged properly, there are still challenges for DevOps teams to making the shift to continuous delivery and achieving that reduction in cost ...
Enterprise architects are increasingly adopting multi-cloud strategies as they seek to utilize existing data center assets, leverage the advantages of cloud computing and avoid cloud vendor lock-in. This requires a globally aware traffic management strategy that can monitor infrastructure health across data centers and end-user experience globally, while responding to control changes and system specification at the speed of today’s DevOps teams. In his session at 20th Cloud Expo, Josh Gray, Chie...
"At the keynote this morning we spoke about the value proposition of Nutanix, of having a DevOps culture and a mindset, and the business outcomes of achieving agility and scale, which everybody here is trying to accomplish," noted Mark Lavi, DevOps Solution Architect at Nutanix, in this SYS-CON.tv interview at @DevOpsSummit at 20th Cloud Expo, held June 6-8, 2017, at the Javits Center in New York City, NY.
We have already established the importance of APIs in today’s digital world (read about it here). With APIs playing such an important role in keeping us connected, it’s necessary to maintain the API’s performance as well as availability. There are multiple aspects to consider when monitoring APIs, from integration to performance issues, therefore a general monitoring strategy that only accounts for up-time is not ideal.
Web services have taken the development world by storm, especially in recent years as they've become more and more widely adopted. There are naturally many reasons for this, but first, let's understand what exactly a web service is. The World Wide Web Consortium (W3C) defines "web of services" as "message-based design frequently found on the Web and in enterprise software". Basically, a web service is a method of sending a message between two devices through a network. In practical terms, this ...
In his session at 20th Cloud Expo, Mike Johnston, an infrastructure engineer at Supergiant.io, discussed how to use Kubernetes to set up a SaaS infrastructure for your business. Mike Johnston is an infrastructure engineer at Supergiant.io with over 12 years of experience designing, deploying, and maintaining server and workstation infrastructure at all scales. He has experience with brick and mortar data centers as well as cloud providers like Digital Ocean, Amazon Web Services, and Rackspace. H...
All organizations that did not originate this moment have a pre-existing culture as well as legacy technology and processes that can be more or less amenable to DevOps implementation. That organizational culture is influenced by the personalities and management styles of Executive Management, the wider culture in which the organization is situated, and the personalities of key team members at all levels of the organization. This culture and entrenched interests usually throw a wrench in the work...
When you focus on a journey from up-close, you look at your own technical and cultural history and how you changed it for the benefit of the customer. This was our starting point: too many integration issues, 13 SWP days and very long cycles. It was evident that in this fast-paced industry we could no longer afford this reality. We needed something that would take us beyond reducing the development lifecycles, CI and Agile methodologies. We made a fundamental difference, even changed our culture...
As many know, the first generation of Cloud Management Platform (CMP) solutions were designed for managing virtual infrastructure (IaaS) and traditional applications. But that’s no longer enough to satisfy evolving and complex business requirements. In his session at 21st Cloud Expo, Scott Davis, Embotics CTO, will explore how next-generation CMPs ensure organizations can manage cloud-native and microservice-based application architectures, while also facilitating agile DevOps methodology. He wi...
We have Continuous Integration and we have Continuous Deployment, but what’s continuous across all of what we do is people. Even when tasks are automated, someone wrote the automation. So, Jayne Groll evangelizes about Continuous Everyone. Jayne is the CEO of the DevOps Institute and the author of Agile Service Management Guide. She talked about Continuous Everyone at the 2016 All Day DevOps conference. She describes it as "about people, culture, and collaboration mapped into your value streams....