Yukon to Get Reporting Services

The ongoing effort to expand the SQL Server database into a broader business intelligence and applications platform continues as Microsoft adds enterprise reporting services to its flagship database.

Microsoft on Tuesday announced plans to include enterprise reporting functionality in the beta version of "Yukon" that will be available later this year. Yukon, the code-name for the next version of SQL Server, is expected to be generally available in late 2003 or early 2004.

"This will extend the SQL Server Business Intelligence offering. We started off with OLAP services in SQL Server 7.0. In SQL Server 2000, we added data warehousing and data mining analytical capability. We think this is the next step that customers have been asking for," says Sheryl Tullis, product manager for SQL Server at Microsoft.

Enterprise reporting allows companies to create reports on critical business information tailored to individual employees and built out of up-to-the-minute business data.

An example, says Microsoft's product manager for business intelligence Brian Biglin, would be a sales reporting application for a pharmaceutical company with 50,000 sales reps globally. "I want to generate a personalized, detailed sales history for each sales rep, yet I want it secured. With traditional BI tools, that's fairly hard to do, plus that user community doesn't want to get in ad hoc. They don't know what they're drilling for," Biglin says.

The reporting capability will be delivered as a set of services as part of the database, similar to the way Microsoft delivers OLAP and data mining capabilities in SQL Server 2000 Analysis Services. Also like Analysis Services, Microsoft will support reporting from other platforms that are OLE DB or ODBC compliant -- a selling point for the majority of organizations that don't have their business critical databases on Windows.

Much as bundling OLAP services in SQL Server 7.0 for no more than the cost of the database represented a threat to OLAP vendors, SQL Server Reporting Services could threaten vendors who sell reporting solutions. The most obvious company in that category is Crystal Decisions, formerly Seagate, with its ubiquitous enterprise reporting software, Crystal Reports, that has been bundled in dozens of products over the years.

Tullis says Microsoft officials have talked extensively with Crystal about their plans and believe the new SQL Server services and Crystal's products will be complementary. Crystal did not immediately respond to a request for an interview.

Tullis says other BI vendors, including ProClarity Corp., are supportive. "We're hoping that by offering a complete, integrated package, that it's going to help a lot of partners to quickly build applications. That's good for the BI industry overall. The more people using BI, the better, and the better it is for their bottom line." Tullis.

About the Author

Scott Bekker is editor in chief of Redmond Channel Partner magazine.


  • Microsoft Warns IT Pros on Windows Netlogon Fix Coming Next Month

    Microsoft on Thursday issued a reminder to organizations to ensure that their systems are properly patched for a "Critical"-rated Windows Netlogon vulnerability before next month's "update Tuesday" patch distribution arrives.

  • Microsoft Nudging Skype for Business Users to Teams

    Microsoft on Thursday announced some perks and prods for Skype for Business unified communications users, with the aim of moving them to the Microsoft Teams collaboration service instead.

  • How To Improve Windows 10's Sound and Video Quality

    Windows 10 comes with built-in tools that can help users get the most out of their sound and video hardware.

  • Microsoft Offers More 'Solorigate' Advice Using Microsoft 365 Defender Tools

    Microsoft issued yet another article with advice on how to use its Microsoft 365 Defender suite of tools to protect against "Solorigate" advanced persistent threat types of attacks in a Thursday announcement.

comments powered by Disqus