
Subscribe to
Computerworld February 02, 2004 (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.
Microsoft is now working on a Reporting Services upgrade that will ship with Yukon, said Thomas Rizzo, director of its SQL Server management team. That version will be able to more easily generate reports from online analytical processing databases, Rizzo said.
Niccolai writes for the IDG News Service.
| Product Details | |
|
|
|
Print this Story |
|
Send Us Feedback |
|
E-mail this Story |
|
Digg this Story |
|
Slashdot this Story |
|
|
|
|
|
|
|
|
|
All Zones Application Performance Zone Business Continuity Zone Data Center Management Zone Enterprise-Class Security Zone The File Data Management Zone Grid Computing on Windows Zone Security Management Zone ITIL Best Practices Zone The SAS Zone Storage Virtualization Zone Business Intelligence and Analytics Zone |
|
|
| ||||||||
| ||||||||
| ||||||||
|

Computerworld Technology Briefing: Meetings @ the Speed of Business For large organizations, Web conferencing gives a major boost to collaboration among far-flung offices. For smaller companies, experts say Web conferencing is no longer a luxury but a necessity for everything from webinars to customer presentations. But the real value lies in saving soft costs and in increases in productivity.Download this briefing
|

|
In Depth: Apple's Leopard leaps to new heights A refined look, revamped apps and new options build on an already solid OS foundation. Read more... |
Creating Tiered Storage Architecture This paper shows how Brocade StorageX enables tiers of storage across Windows and NetApp storage to align storage practices with organizational objectives. Download this white paper now!
|

Best Places to Work in ITWhere can you earn top dollar, get the best benefits, the latest IT and more? Find out in our 14th annual survey. |
| About Us Advertise Contacts Editorial Calendar Help Desk Jobs at IDG Privacy Policy Reprints Site Map |
|
CIO The Industry Standard |