Welcome!

Microservices Expo Authors: Liz McMillan, Jyoti Bansal, Yeshim Deniz, Dan Blacharski, Elizabeth White

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
Today we can collect lots and lots of performance data. We build beautiful dashboards and even have fancy query languages to access and transform the data. Still performance data is a secret language only a couple of people understand. The more business becomes digital the more stakeholders are interested in this data including how it relates to business. Some of these people have never used a monitoring tool before. They have a question on their mind like “How is my application doing” but no id...
Is your application too difficult to manage? Do changes take dozens of developers hundreds of hours to execute, and frequently result in downtime across all your site’s functions? It sounds like you have a monolith! A monolith is one of the three main software architectures that define most applications. Whether you’ve intentionally set out to create a monolith or not, it’s worth at least weighing the pros and cons of the different architectural approaches and deciding which one makes the most s...
Developers want to create better apps faster. Static clouds are giving way to scalable systems, with dynamic resource allocation and application monitoring. You won't hear that chant from users on any picket line, but helping developers to create better apps faster is the mission of Lee Atchison, principal cloud architect and advocate at New Relic Inc., based in San Francisco. His singular job is to understand and drive the industry in the areas of cloud architecture, microservices, scalability ...
When you decide to launch a startup company, business advisors, counselors, bankers and armchair know-it-alls will tell you that the first thing you need to do is get funding. While there is some validity to that boilerplate piece of wisdom, the availability of and need for startup funding has gone through a dramatic transformation over the past decade, and the next few years will see even more of a shift. A perfect storm of events is causing this seismic shift. On the macroeconomic side this ...
Cloud promises the agility required by today’s digital businesses. As organizations adopt cloud based infrastructures and services, their IT resources become increasingly dynamic and hybrid in nature. Managing these require modern IT operations and tools. In his session at 20th Cloud Expo, Raj Sundaram, Senior Principal Product Manager at CA Technologies, will discuss how to modernize your IT operations in order to proactively manage your hybrid cloud and IT environments. He will be sharing be...
Cloud Expo, Inc. has announced today that Aruna Ravichandran, vice president of DevOps Product and Solutions Marketing at CA Technologies, has been named co-conference chair of DevOps at Cloud Expo 2017. The @DevOpsSummit at Cloud Expo New York will take place on June 6-8, 2017, at the Javits Center in New York City, New York, and @DevOpsSummit at Cloud Expo Silicon Valley will take place Oct. 31-Nov. 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA.
A Man in the Middle attack, or MITM, is a situation wherein a malicious entity can read/write data that is being transmitted between two or more systems (in most cases, between you and the website that you are surfing). MITMs are common in China, thanks to the “Great Cannon.” The “Great Cannon” is slightly different from the “The Great Firewall.” The firewall monitors web traffic moving in and out of China and blocks prohibited content. The Great Cannon, on the other hand, acts as a man in the...
To more closely examine the variety of ways in which IT departments around the world are integrating cloud services, and the effect hybrid IT has had on their organizations and IT job roles, SolarWinds recently released the SolarWinds IT Trends Report 2017: Portrait of a Hybrid Organization. This annual study consists of survey-based research that explores significant trends, developments, and movements related to and directly affecting IT and IT professionals.
NHK, Japan Broadcasting, will feature the upcoming @ThingsExpo Silicon Valley in a special 'Internet of Things' and smart technology documentary that will be filmed on the expo floor between November 3 to 5, 2015, in Santa Clara. NHK is the sole public TV network in Japan equivalent to the BBC in the UK and the largest in Asia with many award-winning science and technology programs. Japanese TV is producing a documentary about IoT and Smart technology and will be covering @ThingsExpo Silicon Val...
In his general session at 19th Cloud Expo, Manish Dixit, VP of Product and Engineering at Dice, discussed how Dice leverages data insights and tools to help both tech professionals and recruiters better understand how skills relate to each other and which skills are in high demand using interactive visualizations and salary indicator tools to maximize earning potential. Manish Dixit is VP of Product and Engineering at Dice. As the leader of the Product, Engineering and Data Sciences team at D...
Keeping pace with advancements in software delivery processes and tooling is taxing even for the most proficient organizations. Point tools, platforms, open source and the increasing adoption of private and public cloud services requires strong engineering rigor – all in the face of developer demands to use the tools of choice. As Agile has settled in as a mainstream practice, now DevOps has emerged as the next wave to improve software delivery speed and output. To make DevOps work, organization...
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...
This recent research on cloud computing from the Register delves a little deeper than many of the "We're all adopting cloud!" surveys we've seen. They found that meaningful cloud adoption and the idea of the cloud-first enterprise are still not reality for many businesses. The Register's stats also show a more gradual cloud deployment trend over the past five years, not any sort of explosion. One important takeaway is that coherence across internal and external clouds is essential for IT right n...
Back in February of 2017, Andrew Clay Schafer of Pivotal tweeted the following: “seriously tho, the whole software industry is stuck on deployment when we desperately need architecture and telemetry.” Intrigue in a 140 characters. For me, I hear Andrew saying, “we’re jumping to step 5 before we’ve successfully completed steps 1-4.”
In his session at 20th Cloud Expo, Scott Davis, CTO of Embotics, will discuss how automation can provide the dynamic management required to cost-effectively deliver microservices and container solutions at scale. He will discuss 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.
In large enterprises, environment provisioning and server provisioning account for a significant portion of the operations team's time. This often leaves users frustrated while they wait for these services. For instance, server provisioning can take several days and sometimes even weeks. At the same time, digital transformation means the need for server and environment provisioning is constantly growing. Organizations are adopting agile methodologies and software teams are increasing the speed ...
Software as a service (SaaS), one of the earliest and most successful cloud services, has reached mainstream status. According to Cisco, by 2019 more than four-fifths (83 percent) of all data center traffic will be based in the cloud, up from 65 percent today. The majority of this traffic will be applications. Businesses of all sizes are adopting a variety of SaaS-based services – everything from collaboration tools to mission-critical commerce-oriented applications. The rise in SaaS usage has m...
The proper isolation of resources is essential for multi-tenant environments. The traditional approach to isolate resources is, however, rather heavyweight. In his session at 18th Cloud Expo, Igor Drobiazko, co-founder of elastic.io, drew upon his own experience with operating a Docker container-based infrastructure on a large scale and present a lightweight solution for resource isolation using microservices. He also discussed the implementation of microservices in data and application integrat...
We'd all like to fulfill that "find a job you love and you'll never work a day in your life" cliché. But in reality, every job (even if it's our dream job) comes with its downsides. For you, the constant fight against shadow IT might get on your last nerves. For your developer coworkers, infrastructure management is the roadblock that stands in the way of focusing on coding. As you watch more and more applications and processes move to the cloud, technology is coming to developers' rescue-most r...
2016 has been an amazing year for Docker and the container industry. We had 3 major releases of Docker engine this year , and tremendous increase in usage. The community has been following along and contributing amazing Docker resources to help you learn and get hands-on experience. Here’s some of the top read and viewed content for the year. Of course releases are always really popular, particularly when they fit requests we had from the community.