Green Mountain Builds Bridge for Web Services

Power company uses Service Integrity's SIFT to link CRM app to back-end billing database.

When Green Mountain Energy Co. purchased U.S. PowerSolutions Corp. in July 2002, it needed to build a Microsoft Corp. .Net Web services bridge between Green Mountains CRM software and the U.S. PowerSolutions back-end billing database.

All was going well until Green Mountain officials encountered latency problems and found their monitoring tools couldnt get at the root cause. Thats when they started looking for a tool to examine the code inside Web services transactions.

Green Mountain, of Austin, Texas, is the largest retail provider of "green" electricity in the United States. It sells renewable energy from wind, water and solar sources in eight states to more than 600,000 customers. Its customer service operations are spread throughout the country; the customer relationship management application resides in its Austin headquarters; the billing database is housed in Waltham, Mass.

Chris Garrick, vice president of IT at Green Mountain, said the company took the Web services route because it wanted to provide a way to provide its customer service representatives with customer and billing information in real time. "Everything started great, then we started to get latency and timeout issues when people requested information from the billing system," Garrick said.

Garrick had an arsenal of tools to monitor what was happening across Green Mountains network, but while the company could isolate the problem to the Web services application, it couldnt pinpoint the problem any closer because its monitoring tools wouldnt allow it to view the code behind the Web services transactions. Green Mountain wanted to avoid replicating the problem using dummy data because that would have added to network traffic and wouldnt have helped isolate the problem.

"We were looking to find a way to monitor the Web services application without creating synthetic transactions. We had a way to have people call in, and we had monitoring tools to show network bandwidth, but we wanted to look inside transactions, look at a Web services call and find out what was causing the slowdown," Garrick said.

Green Mountain also needed to get the problem fixed quickly because the CRM system was high-profile. "We were time-critical on this. This is the main customer information system. All of [the] customer care [group] uses it. All of our sales reps use it. We had to find a solution as quickly as possible," Garrick said.

Garrick also found that there were few vendors to help with the problem, and he lacked the in-house resources to build a homegrown solution. One potential source of help was Service Integrity Inc., of Newton, Mass. Service Integritys SIFT product is an XML-based solution that enables monitoring and analysis inside of Web services. As it turns out, Garrick had known Service Integritys founders when they worked at other companies; that, and Service Integritys SIFT product, made the company a good fit for Green Mountain.

Next Page: Quick installation.