Welcome!

Microservices Expo Authors: Elizabeth White, Pat Romanski, Kevin Jackson, Yeshim Deniz, Jason Bloomberg

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
You know you need the cloud, but you’re hesitant to simply dump everything at Amazon since you know that not all workloads are suitable for cloud. You know that you want the kind of ease of use and scalability that you get with public cloud, but your applications are architected in a way that makes the public cloud a non-starter. You’re looking at private cloud solutions based on hyperconverged infrastructure, but you’re concerned with the limits inherent in those technologies.
The reality of data ubiquity is here—data is buried in operational statistics, machine logs, stacks of overflowing tickets and customer details, among other things. How can any user get valuable information amid this rapid influx of data? Imagine a situation where your firm’s revenue takes a hit owing to an unexpected failure in some business process. It would be a nightmare for IT admins to sift through the interminable piles of data to deduce exactly why and where the problem occurred. To sav...
What's the role of an IT self-service portal when you get to continuous delivery and Infrastructure as Code? This general session showed how to create the continuous delivery culture and eight accelerators for leading the change. Don Demcsak is a DevOps and Cloud Native Modernization Principal for Dell EMC based out of New Jersey. He is a former, long time, Microsoft Most Valuable Professional, specializing in building and architecting Application Delivery Pipelines for hybrid legacy, and cloud ...
21st International Cloud Expo, taking place October 31 - November 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA, will feature technical sessions from a rock star conference faculty and the leading industry players in the world. Cloud computing is now being embraced by a majority of enterprises of all sizes. Yesterday's debate about public vs. private has transformed into the reality of hybrid cloud: a recent survey shows that 74% of enterprises have a hybrid cloud strategy. Me...
"We are a monitoring company. We work with Salesforce, BBC, and quite a few other big logos. We basically provide monitoring for them, structure for their cloud services and we fit into the DevOps world" explained David Gildeh, Co-founder and CEO of Outlyer, in this SYS-CON.tv interview at DevOps Summit at 20th Cloud Expo, held June 6-8, 2017, at the Javits Center in New York City, NY.
There's a lot to gain from cloud computing, but success requires a thoughtful and enterprise focused approach. Cloud computing decouples data and information from the infrastructure on which it lies. A process that is a LOT more involved than dragging some folders from your desktop to a shared drive. Cloud computing as a mission transformation activity, not a technological one. As an organization moves from local information hosting to the cloud, one of the most important challenges is addressi...
Cloud Expo, Inc. has announced today that Andi Mann and Aruna Ravichandran have been named Co-Chairs of @DevOpsSummit at Cloud Expo Silicon Valley which will take place Oct. 31-Nov. 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA. "DevOps is at the intersection of technology and business-optimizing tools, organizations and processes to bring measurable improvements in productivity and profitability," said Aruna Ravichandran, vice president, DevOps product and solutions marketing...
SYS-CON Events announced today that CA Technologies has been named "Platinum Sponsor" of SYS-CON's 21st International Cloud Expo®, which will take place October 31-November 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA. CA Technologies helps customers succeed in a future where every business - from apparel to energy - is being rewritten by software. From planning to development to management to security, CA creates software that fuels transformation for companies in the applic...
In the decade following his article, cloud computing further cemented Carr’s perspective. Compute, storage, and network resources have become simple utilities, available at the proverbial turn of the faucet. The value they provide is immense, but the cloud playing field is amazingly level. Carr’s quote above presaged the cloud to a T. Today, however, we’re in the digital era. Mark Andreesen’s ‘software is eating the world’ prognostication is coming to pass, as enterprises realize they must be...
Both SaaS vendors and SaaS buyers are going “all-in” to hyperscale IaaS platforms such as AWS, which is disrupting the SaaS value proposition. Why should the enterprise SaaS consumer pay for the SaaS service if their data is resident in adjacent AWS S3 buckets? If both SaaS sellers and buyers are using the same cloud tools, automation and pay-per-transaction model offered by IaaS platforms, then why not host the “shrink-wrapped” software in the customers’ cloud? Further, serverless computing, cl...
Hybrid IT is today’s reality, and while its implementation may seem daunting at times, more and more organizations are migrating to the cloud. In fact, according to SolarWinds 2017 IT Trends Index: Portrait of a Hybrid IT Organization 95 percent of organizations have migrated crucial applications to the cloud in the past year. As such, it’s in every IT professional’s best interest to know what to expect.
A common misconception about the cloud is that one size fits all. Companies expecting to run all of their operations using one cloud solution or service must realize that doing so is akin to forcing the totality of their business functionality into a straightjacket. Unlocking the full potential of the cloud means embracing the multi-cloud future where businesses use their own cloud, and/or clouds from different vendors, to support separate functions or product groups. There is no single cloud so...
The taxi industry never saw Uber coming. Startups are a threat to incumbents like never before, and a major enabler for startups is that they are instantly “cloud ready.” If innovation moves at the pace of IT, then your company is in trouble. Why? Because your data center will not keep up with frenetic pace AWS, Microsoft and Google are rolling out new capabilities. In his session at 20th Cloud Expo, Don Browning, VP of Cloud Architecture at Turner, posited that disruption is inevitable for comp...
Companies have always been concerned that traditional enterprise software is slow and complex to install, often disrupting critical and time-sensitive operations during roll-out. With the growing need to integrate new digital technologies into the enterprise to transform business processes, this concern has become even more pressing. A 2016 Panorama Consulting Solutions study revealed that enterprise resource planning (ERP) projects took an average of 21 months to install, with 57 percent of th...
In 2014, Amazon announced a new form of compute called Lambda. We didn't know it at the time, but this represented a fundamental shift in what we expect from cloud computing. Now, all of the major cloud computing vendors want to take part in this disruptive technology. In his session at 20th Cloud Expo, Doug Vanderweide, an instructor at Linux Academy, discussed why major players like AWS, Microsoft Azure, IBM Bluemix, and Google Cloud Platform are all trying to sidestep VMs and containers wit...
New competitors, disruptive technologies, and growing expectations are pushing every business to both adopt and deliver new digital services. This ‘Digital Transformation’ demands rapid delivery and continuous iteration of new competitive services via multiple channels, which in turn demands new service delivery techniques – including DevOps. In this power panel at @DevOpsSummit 20th Cloud Expo, moderated by DevOps Conference Co-Chair Andi Mann, panelists examined how DevOps helps to meet the de...
"When we talk about cloud without compromise what we're talking about is that when people think about 'I need the flexibility of the cloud' - it's the ability to create applications and run them in a cloud environment that's far more flexible,” explained Matthew Finnie, CTO of Interoute, in this SYS-CON.tv interview at 20th Cloud Expo, held June 6-8, 2017, at the Javits Center in New York City, NY.
Colocation is a central pillar of modern enterprise infrastructure planning because it provides greater control, insight, and performance than managed platforms. In spite of the inexorable rise of the cloud, most businesses with extensive IT hardware requirements choose to host their infrastructure in colocation data centers. According to a recent IDC survey, more than half of the businesses questioned use colocation services, and the number is even higher among established businesses and busine...
For most organizations, the move to hybrid cloud is now a question of when, not if. Fully 82% of enterprises plan to have a hybrid cloud strategy this year, according to Infoholic Research. The worldwide hybrid cloud computing market is expected to grow about 34% annually over the next five years, reaching $241.13 billion by 2022. Companies are embracing hybrid cloud because of the many advantages it offers compared to relying on a single provider for all of their cloud needs. Hybrid offers bala...
@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 ...