Reporting Tools Added to SQL Server
IDG News Service -
Microsoft Corp. last week shipped software that adds reporting capabilities to SQL Server 2000, rounding out the line of business intelligence tools the company integrates with its relational database.
SQL Server 2000 Reporting Services has been available for beta testing since October. One of the testers was The Long & Foster Cos., a Fairfax, Va.-based real estate services firm that wants to standardize on the technology to deliver nearly 300 corporate reports to its 13,000 employees.
Lance Morimoto, senior manager of e-commerce and application development at Long & Foster, said it now uses a mishmash of reporting tools from vendors like Cognos Inc. and Crystal Decisions Inc., which was acquired by Business Objects SA in December. Long & Foster has completed a pilot program involving 35 reports and is happy with the Reporting Services software so far, he said.
The company created the 35 reports with Microsoft's new Report Writer authoring tool, which is offered as an add-on to the vendor's Visual Studio .Net development suite. "The whole solution is pretty tightly integrated with .Net," Morimoto noted.
But he added that it's too early to tell whether Report Writer will suffice for porting Long & Foster's 250 existing reports to Microsoft's technology. There may still be a need to use third-party software like Crystal Reports, he said.
Dan Zerfas, vice president of application development at First Premier Bank in Sioux Falls, S.D., said the version of Report Writer that was included with the second beta release of Reporting Services in November was much better than the initial test code. "It's like night and day," he said.
First Premier had been building reports using Microsoft's SQL Query Analyzer and Access database. Its developers were able to virtually cut and paste the Access code into Reporting Services, which saved a lot of time, Zerfas said. They also liked the software's user interface, he added.
Philip Russom, an analyst at Forrester Research Inc., said he doesn't expect Microsoft's entry into the market to hurt reporting tools vendors too badly. Report Writer is a "Version 1" product that needs to mature, Russom said, adding that the success of Reporting Services depends partly on whether vendors such as Cognos and Business Objects agree to support Microsoft's Report Definition Language. That would let reports authored with third-party tools be managed and distributed through Microsoft's software.
Microsoft released Reporting Services 11 months after announcing its plan to add the technology . It originally planned to introduce the software with Yukon, a 64-bit upgrade of SQL Server. But the Yukon launch was delayed until later this year, prompting Microsoft to offer the reporting capabilities with SQL Server 2000.
Reprinted with permission from
Story copyright 2009 International Data Group. All rights reserved.
Additional Resources


White Papers & Webcasts
Differentiating With Technical Support: JBoss Customer Support Study
JBoss' expert technical support services is clearly acknowledged by its client base. The comprehensive nature by which their service is unsurpassed. Every category...
Managing And Protecting Your Ever Increasing Mobile Assets
(Source: Absolute Software) Your users are becoming more mobile each day. This is great for productivity - yet challenging for IT control. Natalie...
The JBoss SOA Assessment Tool: Spend Less, Do More
SOA does not have to be overly complex or expensive. The JBoss SOA Assessment Tool can help you chart a course to a...
IDC Webcast: Linux Adoption in a Global Recession
Join Al Gillen from IDC and Michael Applebaum from Novell in this on-demand webcast to see how Linux has emerged as an even...
The CIO's New Guide to Design of Global IT Infrastructure
Is it possible to eliminate the impact of distance? This paper explores the 5 key principles successful CIOs are using to redesign IT...
Novell Opens PR Video
Is the Linux desktop for me? Customers are looking for ways to be more flexible and save money. Using Linux offers a great...
IBM Lotus Notes Performance Brief
This is a Performance Brief that illustrates how Riverbed Steelhead appliances accelerate Lotus Notes R7....
2 Minutes to IT workload automation
Take just 2 minutes to watch this short CONTROL-M flash video. Well show you how BMC CONTROL-M can put money back into your...
Business Value of Performance IDC Whitepaper
Are you looking for a comprehensive solution that addresses insufficient or congested bandwidth, impaired application performance, slow remote backup and replication or obstacles...
Security Configuration Management
In this web video, follow along with Jim Hansen, Senior Product Manager with Big Fix, as he explains why Security Configuration Management is...
Subscribe to Computerworld
