Comments
yourfanat wrote: I am using another tool for Oracle developers - dbForge Studio for Oracle. This IDE has lots of usefull features, among them: oracle designer, code competion and formatter, query builder, debugger, profiler, erxport/import, reports and many others. The latest version supports Oracle 12C. More information here.
Cloud Computing
Conference & Expo
November 2-4, 2009 NYC
Register Today and SAVE !..

2008 West
DIAMOND SPONSOR:
Data Direct
SOA, WOA and Cloud Computing: The New Frontier for Data Services
PLATINUM SPONSORS:
Red Hat
The Opening of Virtualization
GOLD SPONSORS:
Appsense
User Environment Management – The Third Layer of the Desktop
Cordys
Cloud Computing for Business Agility
EMC
CMIS: A Multi-Vendor Proposal for a Service-Based Content Management Interoperability Standard
Freedom OSS
Practical SOA” Max Yankelevich
Intel
Architecting an Enterprise Service Router (ESR) – A Cost-Effective Way to Scale SOA Across the Enterprise
Sensedia
Return on Assests: Bringing Visibility to your SOA Strategy
Symantec
Managing Hybrid Endpoint Environments
VMWare
Game-Changing Technology for Enterprise Clouds and Applications
Click For 2008 West
Event Webcasts

2008 West
PLATINUM SPONSORS:
Appcelerator
Get ‘Rich’ Quick: Rapid Prototyping for RIA with ZERO Server Code
Keynote Systems
Designing for and Managing Performance in the New Frontier of Rich Internet Applications
GOLD SPONSORS:
ICEsoft
How Can AJAX Improve Homeland Security?
Isomorphic
Beyond Widgets: What a RIA Platform Should Offer
Oracle
REAs: Rich Enterprise Applications
Click For 2008 Event Webcasts
In many cases, the end of the year gives you time to step back and take stock of the last 12 months. This is when many of us take a hard look at what worked and what did not, complete performance reviews, and formulate plans for the coming year. For me, it is all of those things plus a time when I u...
SYS-CON.TV
eCommerce Business Impact of Third-Party Address Validation Service
End user and business impact of third-party service calls

 

Are you running an eCommerce site that relies on Third-Party Services such as Address-Validation, Credit Card Authorization or Mapping Services? Do you know how fast, reliable and accurate these service calls (free or charged) are for your web site? Do you know whether it has an impact on your end users in case one of these services is not available or returns wrong data?

End User and Business Impact of Third-Party Service Calls
In last week's webinar Daniel Schrammel, IT System Manager at Leder und Schuh (responsible for sites such as www.shoemanic.com or www.jelloshoecompany.com), told his story on the impact of third-party online services to their business. One specific problem they had was with a service that validates shipping address information. If the entered shipping address is valid, users can opt for a "cash on delivery" option that is highly popular in the markets they sell to. If the address can't be validated or the service is unreachable, this convenient way of payment is not available and users have to go with credit card payment. As the eCommerce platform used to run their online stores also comes from a third-party provider, the Leder und Schuh IT team has no visibility into these third-party online service calls, whether they succeed and how that impacts end-user behavior.

Monthly Report Basically Means No Visibility
As stated before, Leder & Schuh uses an eCommerce Solution that was not developed in-house. Therefore they had no option to monitor the service calls from within the application as this was not supported by the platform (no visibility into application code). They had to rely on a monthly report generated by the Address Validation Service telling them how many requests they had last month, how many succeeded, partially succeeded (e.g., street number incorrect) or completely failed. With that aggregated data it was

  • Impossible to tell which queries actually caused the verification to fail (was it really the user entering a wrong address or is the service not using an up-to-date address database?)
  • Hard to tell whether a failing address validation has an impact on a user's decision to actually buy shoes (is there a correlation between address validation and bounce rates?)

Live-Monitoring of Service Quality
In order to solve this problem they had to get visibility into the eCommerce Solution to monitor the calls to the third-party address validation service. They were interested in:

  1. The call count (to validate the service fee they had to pay)
  2. The response code of the service (to see the impact the response had on users bouncing off the site)
  3. The actual input parameters that caused the service to return an address validation error (to verify whether addresses were really bogus or would have been valid)

Using dynaTrace allowed them to accomplish these and other general Application Performance Management goals without needing to modify the Third-Party eCommerce Platform and without any help from the third-party address validation service. The following dashboard shows the calls to the address validation service. On the top line we see green, representing the calls that return with a success; orange, representing validations with partial success; and red, representing those calls that failed. The bottom left chart shows an aggregation of these three return states showing spikes where up to 30% of the validation calls don't return a success.

Monitoring third-party service calls, the response code and impact on end users

Monitoring the service like this allows Leder & Schuh to:

  • Get Live Data on Service Invocations -> don't have to wait until the end of the month
  • Can look at those addresses that failed -> to verify if the data was really invalid or whether the validation service uses an out-of-date database
  • Can verify the number of calls made to the service -> verify if they don't get charged for more calls matches what they get charged
  • Can monitor availability of the service -> in case the service is not reachable this breaches the SLA

Impact of Service Quality to User Experience and Business
As indicated in the beginning, the option "cash on delivery" is much more popular than paying by credit card. In case the address validation service returns that the address is invalid or the service is down (not reachable), the user only gets the option to pay with credit card. Correlating the status and the response time of the service call with the actual orders that come in allows Leder & Schuh to see the actual Business Impact. It turns out that more users bounce off the site if the only payment option they are given is paying by credit card (Functional Impact) or if the validation service takes too long to respond (Performance Impact). The following dashboard shows how a business can be impacted by the quality of service calls:

Quality of service calls (performance or functional) has a direct impact on orders and revenue

Want to Learn?
During the webinar we also talked about general Response Time, Service Level and System Monitoring they are now doing on their eCommerce Platform. With the visibility they got they achieved some significant application performance improvements and boosted overall business. Here are some of the numbers he presented:

  • 50% less database queries
  • 30% faster Landing Pages
  • 100% visibility into all transactions and third-party calls
About Andreas Grabner
Andreas Grabner has been helping companies improve their application performance for 15+ years. He is a regular contributor within Web Performance and DevOps communities and a prolific speaker at user groups and conferences around the world. Reach him at @grabnerandi

In order to post a comment you need to be registered and logged in.

Register | Sign-in

Reader Feedback: Page 1 of 1

SOA World Latest Stories
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 b...
With the rise of DevOps, containers are at the brink of becoming a pervasive technology in Enterprise IT to accelerate application delivery for the business. When it comes to adopting containers in the enterprise, security is the highest adoption barrier. Is your organization ready to ...
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 c...
There is a huge demand for responsive, real-time mobile and web experiences, but current architectural patterns do not easily accommodate applications that respond to events in real time. Common solutions using message queues or HTTP long-polling quickly lead to resiliency, scalability...
Enterprises are moving to the cloud faster than most of us in security expected. CIOs are going from 0 to 100 in cloud adoption and leaving security teams in the dust. Once cloud is part of an enterprise stack, it’s unclear who has responsibility for the protection of applications, ser...
Many organizations adopt DevOps to reduce cycle times and deliver software faster; some take on DevOps to drive higher quality and better end-user experience; others look to DevOps for a clearer line-of-sight to customers to drive better business impacts. In truth, these three foundati...
Subscribe to the World's Most Powerful Newsletters
Subscribe to Our Rss Feeds & Get Your SYS-CON News Live!
Click to Add our RSS Feeds to the Service of Your Choice:
Google Reader or Homepage Add to My Yahoo! Subscribe with Bloglines Subscribe in NewsGator Online
myFeedster Add to My AOL Subscribe in Rojo Add 'Hugg' to Newsburst from CNET News.com Kinja Digest View Additional SYS-CON Feeds
Publish Your Article! Please send it to editorial(at)sys-con.com!

Advertise on this site! Contact advertising(at)sys-con.com! 201 802-3021


SYS-CON Featured Whitepapers
ADS BY GOOGLE