Welcome!

Microservices Expo Authors: Pat Romanski, Liz McMillan, Simon Hill, Madhavan Krishnan, VP, Cloud Solutions, Virtusa, John Rauser

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
High-velocity engineering teams are applying not only continuous delivery processes, but also lessons in experimentation from established leaders like Amazon, Netflix, and Facebook. These companies have made experimentation a foundation for their release processes, allowing them to try out major feature releases and redesigns within smaller groups before making them broadly available. In his session at 21st Cloud Expo, Brian Lucas, Senior Staff Engineer at Optimizely, discussed how by using ne...
Agile has finally jumped the technology shark, expanding outside the software world. Enterprises are now increasingly adopting Agile practices across their organizations in order to successfully navigate the disruptive waters that threaten to drown them. In our quest for establishing change as a core competency in our organizations, this business-centric notion of Agile is an essential component of Agile Digital Transformation. In the years since the publication of the Agile Manifesto, the conn...
While some developers care passionately about how data centers and clouds are architected, for most, it is only the end result that matters. To the majority of companies, technology exists to solve a business problem, and only delivers value when it is solving that problem. 2017 brings the mainstream adoption of containers for production workloads. In his session at 21st Cloud Expo, Ben McCormack, VP of Operations at Evernote, discussed how data centers of the future will be managed, how the p...
Cavirin Systems has just announced C2, a SaaS offering designed to bring continuous security assessment and remediation to hybrid environments, containers, and data centers. Cavirin C2 is deployed within Amazon Web Services (AWS) and features a flexible licensing model for easy scalability and clear pay-as-you-go pricing. Although native to AWS, it also supports assessment and remediation of virtual or container instances within Microsoft Azure, Google Cloud Platform (GCP), or on-premise. By dr...
The cloud revolution in enterprises has very clearly crossed the phase of proof-of-concepts into a truly mainstream adoption. One of most popular enterprise-wide initiatives currently going on are “cloud migration” programs of some kind or another. Finding business value for these programs is not hard to fathom – they include hyperelasticity in infrastructure consumption, subscription based models, and agility derived from rapid speed of deployment of applications. These factors will continue to...
While we understand Agile as a means to accelerate innovation, manage uncertainty and cope with ambiguity, many are inclined to think that it conflicts with the objectives of traditional engineering projects, such as building a highway, skyscraper or power plant. These are plan-driven and predictive projects that seek to avoid any uncertainty. This type of thinking, however, is short-sighted. Agile approaches are valuable in controlling uncertainty because they constrain the complexity that ste...
identify the sources of event storms and performance anomalies will require automated, real-time root-cause analysis. I think Enterprise Management Associates said it well: “The data and metrics collected at instrumentation points across the application ecosystem are essential to performance monitoring and root cause analysis. However, analytics capable of transforming data and metrics into an application-focused report or dashboards are what separates actual application monitoring from relat...
"This all sounds great. But it's just not realistic." This is what a group of five senior IT executives told me during a workshop I held not long ago. We were working through an exercise on the organizational characteristics necessary to successfully execute a digital transformation, and the group was doing their ‘readout.' The executives loved everything we discussed and agreed that if such an environment existed, it would make transformation much easier. They just didn't believe it was reali...
"Codigm is based on the cloud and we are here to explore marketing opportunities in America. Our mission is to make an ecosystem of the SW environment that anyone can understand, learn, teach, and develop the SW on the cloud," explained Sung Tae Ryu, CEO of Codigm, in this SYS-CON.tv interview at 21st Cloud Expo, held Oct 31 – Nov 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA.
"We're developing a software that is based on the cloud environment and we are providing those services to corporations and the general public," explained Seungmin Kim, CEO/CTO of SM Systems Inc., in this SYS-CON.tv interview at 21st Cloud Expo, held Oct 31 – Nov 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA.
Many enterprise and government IT organizations are realizing the benefits of cloud computing by extending IT delivery and management processes across private and public cloud services. But they are often challenged with balancing the need for centralized cloud governance without stifling user-driven innovation. This strategy requires an approach that fundamentally reshapes how IT is delivered today, shifting the focus from infrastructure to services aggregation, and mixing and matching the bes...
"CA has been doing a lot of things in the area of DevOps. Now we have a complete set of tool sets in order to enable customers to go all the way from planning to development to testing down to release into the operations," explained Aruna Ravichandran, Vice President of Global Marketing and Strategy at CA Technologies, in this SYS-CON.tv interview at DevOps Summit at 21st Cloud Expo, held Oct 31 – Nov 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA.
DevOps promotes continuous improvement through a culture of collaboration. But in real terms, how do you: Integrate activities across diverse teams and services? Make objective decisions with system-wide visibility? Use feedback loops to enable learning and improvement? With technology insights and real-world examples, in his general session at @DevOpsSummit, at 21st Cloud Expo, Andi Mann, Chief Technology Advocate at Splunk, explored how leading organizations use data-driven DevOps to close th...
We just came off of a review of a product that handles both containers and virtual machines in the same interface. Under the covers, implementation of containers defaults to LXC, though recently Docker support was added. When reading online, or searching for information, increasingly we see “Container Management” products listed as competitors to Docker, when in reality things like Rocket, LXC/LXD, and Virtualization are Dockers competitors. After doing some looking around, we have decided tha...
The nature of test environments is inherently temporary—you set up an environment, run through an automated test suite, and then tear down the environment. If you can reduce the cycle time for this process down to hours or minutes, then you may be able to cut your test environment budgets considerably. The impact of cloud adoption on test environments is a valuable advancement in both cost savings and agility. The on-demand model takes advantage of public cloud APIs requiring only payment for t...
DevOps teams have more on their plate than ever. As infrastructure needs grow, so does the time required to ensure that everything's running smoothly. This makes automation crucial - especially in the server and network monitoring world. Server monitoring tools can save teams time by automating server management and providing real-time performance updates. As budgets reset for the New Year, there is no better time to implement a new server monitoring tool (or re-evaluate your current solution)....
The benefits of automation are well documented; it increases productivity, cuts cost and minimizes errors. It eliminates repetitive manual tasks, freeing us up to be more innovative. By that logic, surely, we should automate everything possible, right? So, is attempting to automate everything a sensible - even feasible - goal? In a word: no. Consider this your short guide as to what to automate and what not to automate.
"We are an integrator of carrier ethernet and bandwidth to get people to connect to the cloud, to the SaaS providers, and the IaaS providers all on ethernet," explained Paul Mako, CEO & CTO of Massive Networks, in this SYS-CON.tv interview at 21st Cloud Expo, held Oct 31 – Nov 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA.
From our perspective as consumers, perhaps the best thing about digital transformation is how consumerization is making technology so much easier to use. Sure, our television remote controls still have too many buttons, and I have yet to figure out the digital display in my Honda, but all in all, tech is getting easier for everybody. Within companies – even very large ones – the consumerization of technology is gradually taking hold as well. There are now simple mobile apps for a wide range of ...
"I focus on what we are calling CAST Highlight, which is our SaaS application portfolio analysis tool. It is an extremely lightweight tool that can integrate with pretty much any build process right now," explained Andrew Siegmund, Application Migration Specialist for CAST, in this SYS-CON.tv interview at 21st Cloud Expo, held Oct 31 – Nov 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA.